To better understand GL balances finance teams often need to quickly trace those balances back to the underlying transactions. This tutorial shows how to create a GL summary-to-detail analysis using Configurable Account Analysis (CAA) in Oracle Fusion ERP Analytics, allowing you to move from aggregated views to subledger-level detail in a single workflow.
In this guide, you’ll learn how to:
- Build a summary view of GL account activity using a CAA subject area, including key dimensions like fiscal quarter, journal source, and journal category.
- Configure workbook and dashboard filters (such as fiscal year and ledger) to control data scope and improve performance.
- Create pivot tables that combine journal debit and credit measures to provide a complete view of accounting activity across subledgers.
- Set up a data action (analytics link) to enable drill-down from summary metrics directly to a detailed transaction canvas
- Analyze subledger transaction details—such as invoice number, supplier, event class, and posting status—filtered automatically based on your selection.
With CAA, you can connect GL balances to the underlying transaction activity in just a few clicks—making it easier to investigate variances, validate results, and gain deeper financial insights.
Watch the full tutorial to see these steps in action, and explore additional report authoring tips for Oracle Fusion ERP Analytics here.
For more information on using CAA, check out this webinar recording about typical use cases for CAA in Oracle Fusion ERP Analytics: Modernizing Financial Intelligence: Unlock Actionable GL Insights with CAA and Fusion ERP Analytics.
