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 Order Types for Backlog Calculations


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

The BACKLOG_FLAG in the IA_SALES_ORDLNS table is also used to identify which sales orders are eligible for backlog calculations. By default, all sales order types have their Backlog flag set to Y. As a result, all sales orders are included in backlog calculations.

However, if you wish to process only certain types of sales orders, you must insert a conditional statement for the Backlog flag. Valid values for the Backlog Flag are Y and N.

To edit the Backlog flag

  1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
  2. Open the MPLT_SAI_SALES_ORDLNS mapplet.
  3. Open the Expression transformation EXP_SALES_ORDLNS to edit the Backlog Flag port.
  4. Modify the statement in the BACKLOG_FLAG port to include or exclude sales orders from backlog calculations.
  5. Validate the expression, and save your changes to the repository.
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide