Configure the AR Schedules Extract

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.
To modify the extract filter for Accounts Receivable schedules:

1. In Informatica PowerCenter Designer, open the appropriate Oracle Applications folder (for example, SDE_ORAVersion_Adaptor).
   
2. In Mapplet Designer, open the mplt_BC_ORA_ARTransactionFact_ARSchedules mapplet.
   
3. Double-click the Source Qualifier to open the Edit Transformations dialog.
   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.