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

Configuring the General Ledger Balance ID

This task is a step in the Process of Configuring Oracle Financial Analytics for Oracle 11i. The General Ledger Balance ID controls the level at which the balance in W_GL_BALANCE_F is maintained. By default, the General Ledger Balance ID is maintained at the following granularity for Oracle 11i:

TO_CHAR(INP_SET_OF_BOOKS_ID)||'~'||TO_CHAR(INP_CODE_COMB_ID)||'~'||TO_CHAR(INP_ORG_ID)

However, if you want to maintain your General Ledger Balance ID at a different grain, you can redefine the GL Balance ID for any applicable mapplets.

To modify the General Ledger Balance ID

NOTE:  To modify the General Ledger Balance ID, you must modify the following mapplets:

• mplt_SA_ORA_APTransactionFact_LiabilityDistribution
• mplt_SA_ORA_APTransactionFact_ExpenseDistribution
• mplt_SA_ORA_APTransactionFact_Payment
• mplt_SA_ORA_APTransactionFact_PaymentSchedule
• mplt_SA_ORA_ARTransactionFact_Adjust
• mplt_SA_ORA_ARTransactionFact_ARScheduleDerive
• mplt_SA_ORA_ARTransactionFact_CreditMemoApplication
• mplt_SA_ORA_ARTransactionFact_ReceivableApplication
• mplt_SA_ORA_GLCOGSFact
• mplt_SA_ORA_GLOtherTransactionFact
• mplt_SA_GLRevenueFact

1. In PowerCenter Designer, open the appropriate Oracle Applications 11i folder (for example, SDE_ORA11510_Adaptor). For more information, see About the Name of the Oracle 11i Folder in Informatica.
2. In Mapplet Designer, open the Source Adapter mapplet (for example, mplt_SA_ORA_APTransactionFact_LiabilityDistribution).
3. Double-click the Expression transformation to open the Edit Transformations window and select the Ports tab.
4. Edit the Balance ID definition in the EXT_GL_BALANCE_ID column.
5. Validate and save your changes to the repository.
6. Repeat steps 1 to 5 for each mapplet that is listed above.