Aggregated GL balances are populated in W_GL_BALANCE_A. This table stores GL Balances by only 3 qualified GL segment by default - Natural Account segment, Balancing segment and Cost center segment. The GL balances are not summarized by non-qualified segments as installed by default. If you want to include the non-qualified segments, then you must modify the ODI interfaces.
To Set Up GL Balance Segment Aggregates:
- In ODI Designer Navigator, connect to your ODI repository.
- Open temporary interface PLP_GLBalanceAggrByAcctSegCodes.SQ_W_GL_BALANCE_F.
- Open the Mapping tab.
- Right-click GL_SEGMENT<N>_WID in General Account Balances (W_GL_BALANCE_F) and click Add Column to Target Table.
- Change Execute On to Staging of GL_SEGMENT<N>_WID in Property Inspector.
- Open main interface PLP_GLBalanceAggrByAcctSegCodes.W_GL_BALANCE_A.
- Modify the expression of SEGMENT<N>_WID as follows. SQ_W_GL_BALANCE_F.GL_SEGMENT<N>_WID.
- Change Execute On to Source in Property Inspector.