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

Configuring Oracle General Ledger and Profitability Analytics Transaction Extracts

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

There are two separate transaction extracts for Oracle General Ledger and Profitability Analytics—General Ledger Revenue and General Ledger COGS. By default, the Siebel 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 General Ledger and Profitability Analytics Revenue

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