Financial Reporting, Budgetary Control, and Analytics
This domain tests how balances become reports and how budgets become controls, plus the analytics tools that sit on top of GL data.
Financial reporting
Financial Reporting Studio assembles reports from row sets, column sets and grids; account groups package natural account ranges for reuse; Smart View pulls balances into spreadsheets; the Financial Reporting Center runs, schedules and bursts reports. Reports read whichever ledger, ledger set or reporting currency you select.
Analytics
Oracle Transactional Business Intelligence exposes GL subject areas such as balances and journal lines, so ad hoc analysis does not require a separate data model.
Budgetary control
A budget holds amounts per period; a control budget adds checking rules. Options decide whether a journal or subledger document is checked, whether the outcome is Absolute (block), Advisory (warn and allow override) or None, and what tolerance applies. Encumbrance accounting extends checks to purchase orders and requisitions.
Worked example
Control budget 100,000, actual 95,000, new requisition 15,000. Reasoning: funds available are 5,000. With Absolute control the requisition fails; with Advisory it saves with a warning and an authorised user may override; with None no check fires. A 10% tolerance raises the ceiling to 105,000, so the 15,000 requisition still fails.
Traps
Treating a budget as a control budget; expecting advisory failures to block posting; mixing budget periods with accounting periods; forgetting that accounts excluded from budgetary control bypass funds checks entirely.