Inquiry, Reporting, and Analysis
General Ledger includes powerful online inquiry and reporting features for reviewing and reporting on your consolidated balances. The system also provides sophisticated tools for analyzing your consolidated results.
Drilling Down to Subsidiary Detail
From your consolidated parent set of books, you can drill between:
- Consolidated and subsidiary entities
- Detail accounts and journal entries
- Summary and detail account balances
- Journals and subledger transactions
General Ledger's "drill anywhere" functionality immediately provides you with a clear perspective of any subsidiary, any account, any journal, or any subledger transaction. You can drill down to account balances, review consolidation journal entries, drill down further to your subsidiary sets of books, review subsidiary account balances, then drill down further to subsidiary journal entries and even to your subsidiaries' subledger details.
For more details on General Ledger's inquiry and drilldown capabilities, see the sections listed below:
Using FSG and Report Wizard
From the Global Consolidation System you can access General Ledger standard reports and the Financial Statement Generator. Use these tools to create and run consolidated and consolidating reports for review and analysis by your management. You can also use GL Desktop Integrator's Report Wizard to create and run your reports.
See: GL Desktop Integrator Report Wizard
To use the GCS to run reports:
1. Navigate to the Consolidation Workbench window.
2. Select a consolidation mapping for which you've finished posting to your parent set of books.
3. Choose the Report button from the State Controller.
4. From the Reports window, select Financial to run FSG reports or select Standard to run standard reports and listings.
5. Choose OK to save your work. The Run Financial Reports window or the Submit Requests window will appear, depending on your report type selection above.
Financial Analyzer Integration
Oracle Financial Analyzer uses a multi-dimensional data model that is ideal for on-line analytical processing (OLAP). Financial Analyzer provides a complete set of tools for planning, analyzing, and reporting corporate financial data. With the Express multidimensional database at its core, Financial Analyzer lets you set up a customized system that reflects your corporation's unique organizational structure and facilitates the management of your financial data at all business levels. It handles organizational consolidations across multiple hierarchies and automatically performs line item and time aggregations.
General Ledger is tightly integrated with Financial Analyzer so you can analyze your consolidated parent data with the powerful OLAP tools provided by Financial Analyzer.
See: Financial Analyzer Integration
See Also
Global Consolidation System
Consolidation Workbench
Mapping Subsidiaries to Your Parent
Preparing Subsidiary Data
Transferring Subsidiary Data to Your Parent
Transferring Consolidation Sets
Posting Subsidiary Data
Creating Eliminating Entries