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

Configuring the AR Schedules Extract

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

By default, Oracle Receivables Analytics extracts only completed schedules; that is, transactions where the RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG(+) = Y. If you want to extract additional types of AR schedule entries, you must remove the filter in the Business Component mapplet. By modifying or removing the filter, you can extract other entries, such as those that were marked as incomplete.

You must modify both the regular mapplet (mplt_BC_ORA_ARTransactionFact_ARSchedules) as well as the primary extract mapplet (mplt_BC_ORA_ARTransactionFact_ARSchedulesPrimary). Repeat the following procedure for each mapplet.

To modify the extract filter for Accounts Receivable schedules

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 mplt_BC_ORA_ARTransactionFact_ARSchedules mapplet.
3. Double-click the Source Qualifier to open the Edit Transformations window.

   In the User Defined Join field and in the SQL Query field, modify the statement:

   AND RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG(+) = Y

4. Validate and save your changes to the repository.
5. Repeat Step 2 to Step 4 for the mplt_BC_ORA_ARTransactionFact_ARSchedulesPrimary mapplet.