GL Balances Are Populated in Oracle EBS

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

• By extracting the GL balances directly from Oracle General Ledger, as follows:
  1. In DAC, go to the Design view, and then display the Subject Areas tab.
  2. Query for the Subject Area 'Financials – General Ledger'. Display the Configuration Tags subtab, and query for the tag 'Oracle – Extract GL Balance'. Activate the tag by deselecting the Inactive check box.
  3. Inactivate the tag 'Financials – Calculate GL Balance by selecting the is Inactive check box.
  4. Click Assemble to reassemble the Subject Area.
  5. Rebuild the Execution Plans that contain this Subject Area.

• 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, go to the Design view, and then display the Subject Areas tab.
  2. Query for the Subject Area 'Financials – General Ledger'. Display the Configuration Tags subtab, and query for the tag 'Financials – Calculate GL Balance'. Activate the tag by deselecting the Inactive check box.
  3. Inactivate the tag 'Oracle – Extract GL Balance' by selecting the is Inactive check box.
  4. Click Assemble to reassemble the Subject Area.
  5. Rebuild the Execution Plans that contain this Subject Area.