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

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 Informatica PowerCenter Designer, open the appropriate Oracle Applications folder (for example, SDE_ORAVersion_Adaptor).
   
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 dialog.
   
4. Display the Ports tab, and edit the expression for the EXT_NU_AR_BALANCE_ID port.
   For example, you might click the Expression field to display the Expression Editor and modify the text in the Formula box.
   
5. Validate and save your changes to the repository.
   
6. Repeat steps 1 to 5 for each mapplet that is listed above.