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

Configuring AR Balance ID for Oracle Receivables Analytics and Oracle General Ledger and Profitability Analytics

This task is a step in the Process of Configuring Oracle Financial Analytics for Oracle 11i. The AR Balance ID controls the level at which the balance in W_AR_BALANCE_F is maintained.

By default, the AR Balance ID is maintained at the following granularity:

set_of_books_id || '~' || code_combination_id || '~' || customer_id || '~' || customer_site_use_id || '~' transaction_currency_code || '~' || org_id

However, if you want to maintain your AR balance at a different grain, you can redefine the Balance ID value in the applicable mapplets.

To modify the AR Balance ID

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

• mplt_SA_ORA_ARTransactionFact_Adjust
• mplt_SA_ORA_ARTransactionFact_ARScheduleDerive
• mplt_SA_ORA_ARTransactionFact_CreditMemoApplication
• mplt_SA_ORA_ARTransactionFact_ReceivableApplication

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 mapplet (for example, mplt_SA_ORA_ARTransactionFact_Adjust).
3. Double-click the Expression transformation to open the Edit Transformations window.
4. Click the Ports tab to edit the Balance ID definition in the EXT_NU_AR_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.