|
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 Early and Late Tolerances for Shipments
This task is a step in the Process of Configuring Oracle Order Management and Fulfillment Analytics Option for Oracle 11i. You configure the definition of early and late shipments by editing the EXP_SALES_PCKLNS expression in the mplt_SA_ORA_SalesPickLinesFact mapplet. The mplt_SA_ORA_SalesPickLinesFact mapplet is used by the SDE_ORASalesPickLinesFact mapping. This mapplet compares the pick date and ship date with the scheduled ship date to determine whether or not orders are late. To configure early and late tolerances for shipments
- In PowerCenter Designer, open the SDE_ORA115<ver>_Adaptor folder.
- Open the
mplt_SA_ORA_SalesPickLinesFact mapplet in the Mapplet Designer.
- Double-click the
EXP_SALES_PCKLNS expression to open the Edit Transformation box.
- Display the Ports tab.
- Edit the Expression for the ports that you want to modify.
For example:
- If you want to allow two days after the scheduled pick date before you flag the pick as late, set the Expression value for the
VAR_PICK_LATE_TIME_TOL port to 2.
- To set the number of days before a pick is flagged as early, set the Expression value the
VAR_PICK_EARLY_TIME_TOL port.
- To set the number of days before a pick is flagged as late, set the Expression value for the VAR_PICK_LATE_TIME_TOL port.
- If you want to change the shipping tolerances, set the Expression values for the shipping ports (for example, VAR_SHIP_LATE_TIME_TOL, VAR_SHIP_EARLY_TIME_TOL).
- Validate and save your changes to the repository.
|
