Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Configuring General Ledger Cost Of Goods Extract

This task is a step in the Process of Configuring Siebel 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.

Because Oracle General Ledger never deletes posted transactions, there are no prebuilt primary extract and delete mappings for COGS data. Therefore, if you decide to remove this filter and begin extracting unposted transactions, you must also create primary extract and delete mappings similar to those used for Siebel General Ledger Analytics Revenue. You can use the primary extract mapping (M_I_GL_REVENUE_PRIMARY_EXTRACT), and the delete mapping (M_I_GL_REVENUE_DELETE) as models for the extract and delete mappings you are creating in Oracle 11i.

To modify the extract filter for General Ledger COGS

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In Mapplet Designer, open MPLT_BCI_GL_COGS.
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. Validate and save your changes to the repository.