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
- 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.
- In Mapplet Designer, open the mapplet (for example, mplt_SA_ORA_ARTransactionFact_Adjust).
- Double-click the Expression transformation to open the Edit Transformations window.
- Click the Ports tab to edit the Balance ID definition in the
EXT_NU_AR_BALANCE_ID column.
- Validate and save your changes to the repository.
- Repeat steps 1 to 5 for each mapplet that is listed above.
|