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 Order Lines Data Storage

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

Sales order lines are the itemized lines that make up a sales order. This information is stored in the W_SALES_ORDER_LINE_F table. This topic describes how to modify the type of information stored in this table.

About the Handling of Booked and Nonbooked Orders in the Order Lines and Bookings Table

By default, only booked orders are extracted from the Oracle 11i source system as shown in Figure 30. Therefore, all orders loaded into the Sales Order Lines and Bookings tables are booked.

However, if you want to load nonbooked orders into the Sales Order Lines table, you have to configure the extract so that it does not filter out nonbooked orders. In Oracle 11i, the OE_ORDER_LINES_ALL.BOOKED_FLAG = Y condition indicates that an order is booked; therefore, this statement is used to filter out nonbooked orders. To load all orders, including nonbooked orders, remove the filter condition from the WHERE clause in the SDE_ORA_SalesOrderLinesFact and SDE_ORA_SalesOrderLinesFact_Primary mappings.

By default, only booked orders are loaded into the Sales Order Lines (W_SALES_ORDER_LINES_F) and Sales Booking Lines (W_SALES_BOOKING_LINE_F) tables. However, you can also load non-booked orders in Sales Order Lines (W_SALES_ORDERS_LINES_F).

To include nonbooked orders in the Sales Order Lines tables

1. In PowerCenter Designer, open the SDE_ORA115<ver>_Adaptor folder.
2. Open the mplt_BC_ORA_SalesOrderFact mapplet in the Mapplet Designer.
3. Double-click the SQ_BCI_SALES_ORDLNS source qualifier to open the Edit Transformations box.
4. Display the Properties tab.
   
5. For both the Sql Query Transformation Attribute and the User Defined Join Transformation Attribute, do the following:
   1. Select the down arrow in the Value field to display the SQL Editor box.
      
   2. In the SQL box, remove the line 'AND OE_ORDER_LINES_ALL.BOOKED_FLAG='Y''.
   3. Select OK to save the changes.
6. Validate and save your changes to the repository.
7. Repeat steps 3 - 5 for the SDE_ORAC_SalesOrderLinesFact_Primary mapping.