Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Configuring AR Balance ID for Siebel Receivables Analytics and Siebel Profitability Analytics

This task is a step in the Process of Configuring Siebel Financial Analytics for Oracle 11i.

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

However, if you want to maintain your AR balance at a different grain, you can redefine the Balance ID value in the applicable mapplets. You have to modify both the regular mapplet (MPLT_SAI_AR_XACTS) as well as the update mapplet (MPLT_SAI_AR_XACTS_UPDATE) for Oracle 11i.

To modify the AR Balance ID

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In Mapplet Designer, open the MPLT_SAI_AR_XACTS mapplet.
3. Double-click the Expression transformation to open the Edit Transformations window, and click the Ports tab to edit the Balance ID definition in the EXT_NU_AR_BALANCE_ID column.
4. Validate and save your changes to the repository.
5. Repeat Step 2 to Step 4 for the MPLT_SAI_AR_XACTS_UPDATE mapplet.