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

Configuring AP Balance ID for Siebel Payables Analytics

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

This section contains Siebel Payables Analytics configuration information that is specific to Oracle 11i.

By default, the Accounts Payable (AP) Balance ID is maintained at the following granularity:

GL_ACCOUNT_ID||'~'||VENDOR_SITE_ID||'~'||ORGANIZATION_ID

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

To modify the Accounts Payable Balance ID

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In Mapplet Designer, open the MPLT_SAI_AP_XACTS_INSERT 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_BALANCE_ID column.
4. Validate and save your changes to the repository.
5. Repeat Step 2 to Step 4 for the MPLT_SAI_AP_XACTS_UPDATE mapplet.