Configure the AR Adjustments Extract for Oracle Receivables Analytics

By default, Oracle Receivables Analytics extracts only approved adjustment entries against accounts receivable transactions. Approved adjustments are entries where the AR_ADJUSTMENTS_ALL.STATUS = A. If you want to extract additional types of AR adjustment entries, you can remove the filter in the Business Component mapplet. By modifying or removing the filter, you can extract other entries, such as those that require more research, those that are rejected, and those that are not accrued charges.
To modify the extract filter for Accounts Receivable adjustments:

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_Adjust mapplet.
   
3. Double-click the Source Qualifier to open the Edit Transformations dialog, and display the Properties tab.
   In the SQL Query field and in the User Defined Join field, modify the statement:
   

   AND AR_ADJUSTMENTS_ALL.STATUS = A
   

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