Adding Dates to the Order Cycle Time Table for Post-Load Processing

To add more dates, you need to understand how the Order Cycle Times table is populated. Therefore, if you want to change the dates loaded into the Order Cycle Time table (W_SALES_CYCLE_LINE_F), then you have to modify the interfaces for both a full load and an incremental load that take the dates from the W_* tables and load them into the Cycle Time table.

To add dates to the Cycle Time table load:

1. In ODI Designer Navigator, expand Models - Oracle BI Applications - Oracle BI Applications - Fact.
2. Find W_SALES_CYCLE_LINE_F and add a column to store this date you want to add.

   For example, if you are loading the Validated on Date in the W_SALES_CYCLE_LINE_F table, then you need to create a new column, VALIDATED_ON_DT, and modify the target definition of the W_SALES_CYCLE_LINE_F table.

3. Save the changes.
4. Open Projects - BI Apps Project - Mappings - PLP folders.
5. Find PLP_SalesCycleLinesFact_Load folder and modify interfaces under the folder to select the new column from any of the following source tables, and load it to the W_SALES_CYCLE_LINE_F target table:

   • W_SALES_ORDER_LINE_F

   • W_SALES_INVOICE_LINE_F

   • W_SALES_PICK_LINE_F

   • W_SALES_SCHEDULE_LINE_F

6. Modify the temp interfaces and the main interfaces for both a full load and an incremental load.