Configure AP Balance ID for Oracle Payables Analytics

The AP Balance ID controls the level at which the balance in W_AP_BALANCE_F is maintained. This section contains configuration information for Oracle Payables Analytics that is specific to Oracle. By default, the Accounts Payable (AP) Balance ID is maintained at the following granularity:

SET_OF_BOOKS_ID||'~'||CODE_COMBINATION_ID||'~'||VENDOR_SITE_ID||'~'||
ORG_ID||'~'||VENDOR_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.
To modify the Accounts Payable Balance ID:

Note:

To modify the Accounts Payable Balance ID, you must modify the following mapplets:

• mplt_SA_ORA_APTransactionFact_LiabilityDistribution
• mplt_SA_ORA_APTransactionFact_ExpenseDistribution
• mplt_SA_ORA_APTransactionFact_Payment

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_APTransactionFact_LiabilityDistribution).
3. Double-click the Expression transformation to open the Edit Transformations dialog.
4. Display the Ports tab, and edit the expression for the EXT_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.