Oracle Cloud GL study plan
Oracle Cloud GL · Give each week a clear focus.
8 weeks · About 7 hours per week
Oracle Cloud GL Fundamentals & General Ledger Configuration
Map the Oracle Cloud GL data model (ledger, chart of accounts, accounting calendar, currency) and write a one-page diagram of how they connect
Explain the four C's (chart of accounts, calendar, currency, convention) and how each constrains journal entry
Distinguish primary ledger, secondary ledger, reporting currency ledger, and ledger set use cases
Configure a chart of accounts structure with balancing and cost center segments in a sandbox environment
Your checkpoint
A labeled architecture diagram plus a sandbox ledger created with a four-segment chart of accounts and a 12-period accounting calendar
General Ledger Configuration
Configure accounting calendar period types and verify open/close status transitions
Define value sets with correct validation types and assign them to chart of accounts segments
Set up ledger options including retained earnings, cumulative translation adjustment, and journal approval
Document the accounting configuration owner and how it controls shared setup across ledgers
Your checkpoint
A configuration workbook listing every value set, segment, calendar, and ledger option set in the sandbox, with screenshots of each completed setup page
General Ledger Configuration & Journals and Period Close
Configure journal approval rules and test a rejected and an approved journal end to end
Create journal sources and categories and explain how they drive reversal and posting behavior
Enter, post, and reverse a manual journal, then trace the resulting subledger accounting entries
Set up recurring journal templates and generate at least two periods of entries
Your checkpoint
A test script log showing one approved, one rejected, one reversed, and two recurring journals with their resulting accounting entries
Journals and Period Close
Execute a full period close checklist from subledger accounting through GL posting
Reconcile subledger balances to GL balances and document any differences
Run revaluation and translation, then verify the resulting unrealized gain/loss and translated balances
Explain the difference between posting, closing, and permanently closing a period
Your checkpoint
A completed period close checklist for one period with reconciliation evidence and a one-page summary of revaluation versus translation results
Journals and Period Close
Configure and run period-end accruals and automatic reversals in the next period
Perform a consolidation or intercompany balancing scenario and verify the balancing entries
Troubleshoot three common posting failures (unbalanced journal, closed period, missing conversion rate)
Describe the journal import process and validate an imported journal batch
Your checkpoint
A troubleshooting guide covering at least three posting errors with cause, fix, and a verified resolution in the sandbox
Financial Reporting and Allocations
Build an account group and a financial reporting report using the report components (row set, column set, content set)
Create a report that compares actual to budget for a chosen cost center hierarchy
Explain how allocations work: basis, target, offset, and allocation rule sequencing
Configure a cost allocation rule and run it for one period
Your checkpoint
A working financial report showing actual versus budget by cost center, plus an allocation run with before-and-after balances
Financial Reporting and Allocations & Oracle Cloud GL Fundamentals
Design a multi-step allocation with a statistical basis and verify the calculated results manually
Use Smart View to refresh a report and drill through to journal detail
Build a dashboard or infolets view summarizing close status and key balances
Revisit domain 1 concepts and connect ledger design choices to reporting and allocation outcomes
Your checkpoint
A reconciliation worksheet proving the allocation output matches a manual calculation, plus a Smart View drill-through screenshot
Oracle Cloud GL Fundamentals & General Ledger Configuration & Journals and Period Close & Financial Reporting and Allocations
Complete a timed 60-question practice set weighted by domain percentage and score each domain
Re-study the two weakest domains using targeted notes rather than full rereads
Recite the configuration dependencies (value set to segment to chart of accounts to ledger) from memory
Walk through a full close-to-report cycle without notes as a final integration check
Your checkpoint
A scored practice exam with a domain-by-domain breakdown and a one-page remediation plan for the weakest two domains
Milestones
Week 2: Sandbox ledger is fully configured and you can explain each chart of accounts segment and calendar choice without notes
Week 4: One complete period close executed end to end with subledger-to-GL reconciliation evidence
Week 6: A financial report and a cost allocation both run successfully and results are verified manually
Week 8: Timed practice exam completed with per-domain scores and a written remediation plan for the two weakest domains