Configure Oracle Profitability Analytics Transaction Extracts

There are two separate transaction extracts for Oracle General Ledger and Profitability Analytics—General Ledger Revenue and General Ledger COGS. By default, the Oracle General Ledger Analytics application extracts only Completed revenue and COGS that have been posted to the general ledger. Completed revenue transactions are those where the RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG = Y. If you want to extract incomplete revenue transactions, you can remove the filter in the Business Component.
To modify the extract filter for Oracle Profitability Analytics Revenue:

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

   AND RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG = Y
   

4. Validate and save your changes to the repository.