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

Configuring Sales Invoice Lines Data Storage

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

Sales invoice lines are payments for items ordered by a customer. This information is stored in the IA_SALES_IVCLNS table. This topic describes how to modify the type of information stored in this table.

Configuring the Sales Invoice Extract

By default, the Siebel Enterprise Sales Analytics application is configured to extract completed sales invoices when performing the Sales Invoice data extract. Oracle 11i uses a flag to indicate whether a sales invoice is complete. In particular, completed sales invoices are those where the RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG = Y in Oracle 11i.

To extract incomplete sales invoices, as well as complete invoices, remove the extract filter statement.

To remove the extract filter for sales invoices

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Open a Sales Invoice Lines Business Component mapplet. Modify both the regular extract mapplet (MPLT_BCI_SALES_IVCLNS) and the primary extract mapplet (MPLT_BCI_SALES_IVCLNS_PRIMARY).
3. Open the Source Qualifier to edit the SQL statement in the SQL Query and User Defined Join fields.
4. In the User Defined Join field and in the SQL Query field, remove the statement:

   AND RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG(+) = Y

5. Validate and save your changes to the repository.