Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >

Configuring How GL Balances Is Populated

Oracle BI Applications provides two ways to populate the GL balances (stored in the W_GL_BALANCE_F table), as follows:

1. By extracting the GL balances directly from Oracle General Ledger, as follows:
   1. In DAC, for the Subject Area 'Financials - General Ledger', in the 'Configuration Tag' tab, make sure that the tag 'Oracle - Extract GL Balance' is unchecked for the 'Inactive' checkbox.
   2. Make sure the tag 'Financials - Calculate GL Balance is checked in the 'Inactive' checkbox.
   3. Click Assemble to redesign the subject area.
   4. After the subject area has been redesigned, redesign the execution plans that contain this subject area.
2. By calculating the GL balances based on the records in the W_GL_OTHER_F table, which stores all journal lines, as follows:
   1. In DAC, for the Subject Area 'Financials - General Ledger', in the 'Configuration Tag' tab, make sure that the tag 'Financials - Calculate GL Balance' is unchecked for the 'Inactive' checkbox.
   2. Make sure the tag 'Oracle - Extract GL Balance' is checked in the 'Inactive' checkbox.
   3. Click Assemble to redesign the subject area.
   4. After the subject area has been redesigned, redesign the execution plans that contain this subject area.