Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >

Configuring AP Balance ID for Oracle Payables Analytics


This task is a step in the Process of Configuring Oracle Financial Analytics for Oracle 11i. 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 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.

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
  • mplt_SA_ORA_APTransactionFact_PaymentSchedule
  1. 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.
  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 window.
  4. Click the Ports tab to edit the Balance ID definition in the EXT_NU_BALANCE_ID column.
  5. Validate and save your changes to the repository.
  6. Repeat steps 1 to 5 for each mapplet that is listed above.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.