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 >

Process of Configuring the Order Lines Execution Plan and OTB ETL

The Backlogs and Cycle Lines (OTB ETL) component assumes that the Oracle Order Line Tables have been updated with shipping and invoicing information (for example, using Oracle programs). If the Oracle Order Line Tables have not been updated with shipping and invoicing information, you need to update the OTB ETL and Execution Plan as follows:

To configure the Order Lines Execution Plan and OTB ETL

1. In PowerCenter Designer, open the PLP folder.
2. Open the PLP_SalesCycleLinesFact mapplet in the Mapplet Designer.
3. Double-click the SQ_W_SALES_ORDER_LINE_F 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, replace the SQL text 'X.TOTAL_SHIPPED_QTY' with 'PICKLINE.TOTAL_SHIPPED_QTY'.
7. In the SQL box, replace the SQL text 'X.TOTAL_INVOICED_QTY' with 'IVCLINE.TOTAL_INVOICE_QTY'.
8. Validate and save your changes to the repository.
9. Log into the DAC (for more information, see To log in to the DAC).
10. In the Design tab, expand the Configuration Points node, and select the Sales PLP Optional Tasks.
11. Activate the appropriate Subject Areas.