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

Configuring General Ledger Cost Of Goods Extract

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

By default, the Siebel General Ledger Analytics application extracts only COGS transactions that have been posted to the general ledger. All COGS transactions that have been transferred satisfy the following condition—MTL_TRANSACTION_ACCOUNTS.GL_BATCH_ID <> -1. If you want to extract all transactions, you can remove the filter in the Business Component mapplet. You need to modify the Business Component mapplet for both the regular extract mapplet as well as the primary extract mapplet.

To modify the extract filter for General Ledger COGS

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 mplt_BC_ORA_GLCOGSFact.
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 MTL_TRANSACTION_ACCOUNTS.GL_BATCH_ID <> -1

4. In Mapplet Designer, open mplt_BC_ORA_GLCOGSFact_PRIMARY.
5. 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 MTL_TRANSACTION_ACCOUNTS.GL_BATCH_ID <> -1

6. Validate and save your changes to the repository.