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

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

Sales order lines are the itemized lines that make up a sales order. This information is stored in the IA_SALES_ORDLNS 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 55. Therefore, all orders loaded into the Sales Order Lines and Bookings tables are flagged as booked (EXT_BOOKING_FLAG = 'Y').

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_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 S_M_I_SALES_ORDLNS_EXTRACT and S_M_I_SALES_ORDLNS_PRIMARY_EXTRACT sessions.

Figure 55. Oracle 11i: Default Configuration for Loading Booked Orders

To include nonbooked orders in the Sales Order Lines table

1. In PowerCenter Workflow Manager, open the Configuration for Oracle Applications v11i folder.
2. Expand the Oracle 11i Enterprise Sales Application workflow.
3. Expand the O_FACTS_EXTRACT worklet and the O_FACT_EXTRACT_SALES worklet.
4. Double-click the S_M_I_SALES_ORDLNS_SCHLNS_EXTRACT session to open the Edit Tasks box.
5. In the Transformations tab, edit the MPLT_BCI_SALES_ORDLNS SQL statement.

   Remove the OE_ORDER_LINES_ALL.BOOKED_FLAG='Y' filter in the SQL statement to include nonbooked orders in the Sales Order lines table.

6. Validate and save your changes to the repository.