Explore Financial Subject Areas in Oracle Transactional Business Intelligence

In this example, you examine Financial subject areas in Oracle Transactional Business Intelligence. Here's the list of Financial products with subject areas: Assets, Budgetary Control, Cash Management, Expenses, General Ledger, Intercompany, Payables, Receivables, Revenue Management, and Subledger Accounting.

1. Start from the Financial Reporting Center.

2. Click Tasks.

3. Click Open Workspace for Financial Reports.

4. Select Navigate > Applications > BI Catalog.

5. You have to create an analysis to see the subject areas you have access to:

   1. Click the New icon.

   2. Click Analysis.

   Subject areas are organized in folders and the information they contain varies based upon reporting requirements. General Ledger subject areas cover account balances, journals, and period statuses.

6. Select the General Ledger Transactional Balances - Real Time subject area. The term Real Time in the subject area name indicates the information is up-to-date as of the latest general ledger journal posting. You can use this subject area to create trial balances and general queries to review changes in account balances over time. Here are some of the folders that appear in the Subject Area pane.

   • Balancing Segment

   • Cost Center Segment

   • Currency

   • Time

   • Ledger

   • Ledger Set

   You can expand folders to see their components. For example, the Time folder contains accounting period and year. If you have more than one ledger, you can create an analysis that filters by ledger and ledger set. You can query a specific general ledger balance, or groups of general ledger balances.

7. Click the Add or Remove Subject Areas icon in the Subject Areas toolbar to view more subject areas and the type of information they hold.

   For example, with the Payables subject areas you can examine information about suppliers, supplier balances, and invoices, including freight and tax charges. You can also see how invoices and payments affect the general ledger. An analysis can show which invoices were paid on time and whether checks have cleared.

   The Receivables subject areas include customer information, customer balances, and invoice details such as terms and receipts, credit memos, and revenue adjustments. Similar to Payables, you could analyze how receipts affect general ledger account balances.