Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Order Management and Fulfillment Analytics Option > Process of Configuring Oracle Order Management and Fulfillment Analytics Option for Oracle 11i >

Configuring Sales Invoice Lines Data Storage

This task is a step in the Process of Configuring Oracle Order Management and Fulfillment Analytics Option for Oracle 11i.

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

Configuring the Sales Invoice Extract

By default, the Oracle Order Management and Fulfillment Analytics Option 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 SDE_ORA115<ver>_Adaptor folder.
2. Open the mplt_BC_ORA_SalesInvoiceLinesFact mapplet in the Mapplet Designer.
3. Double-click the SQ_BCI_SALES_IVCLNS source qualifier to open the Edit Transformations box.
4. Display the Properties tab.
5. For the SQL Query Transformation Attribute, select the down arrow in the Value field to display the SQL Editor box.
6. In the SQL box, remove the line 'AND RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG='Y''.
7. Validate and save your changes to the repository.
8. Repeat steps 2 - 7 for the mplt_BC_ORA_SalesInvoiceLinesFact_Primary mapplet.