Information in this document applies to any platform.<br* ***
GOAL
- How does E-Business Suite (EBS) derive the Material Transaction Date?
- What is the purpose of the Initial Pick Up Date on the delivery and how is it calculated?
- What is the purpose of the Ultimate Ship To Date on the delivery and how is it calculated?
SOLUTION
1) The Actual Departure Date will be the Material Transaction Date. Delivery's 'Initial Pickup Date' & 'Ultimate Drop Off Date is calculated based on the Shipping Global Parameter's setup.
It can be either of the following:
a. Earliest Ship Date, Latest Delivery Date
b. Scheduled Date, Requested Date
NOTE!!: The Actual Shipment Date signifies the date on which material is actually shipped(trip is firmed) out of staging status.
The Actual_Shipment_Date column in the OE_ORDER_LINES_ALL table is populated based on the Actual_Departure_Date from the WSH_TRIP_STOP table.
As per design, the transaction date in inventory transactions interface is passed from Shipping as the Actual_Departure_Date of the trip stop as part of the Inventory Interface of the Interface Trip Stop.
Same is also passed to the Actual Shipment Date for the order line as part of the OM Interface of the Interface Trip Stop.
It can be either of the following:
a. Earliest Ship Date, Latest Delivery Date
b. Scheduled Date, Requested Date
NOTE!!: The Actual Shipment Date signifies the date on which material is actually shipped(trip is firmed) out of staging status.
The Actual_Shipment_Date column in the OE_ORDER_LINES_ALL table is populated based on the Actual_Departure_Date from the WSH_TRIP_STOP table.
As per design, the transaction date in inventory transactions interface is passed from Shipping as the Actual_Departure_Date of the trip stop as part of the Inventory Interface of the Interface Trip Stop.
Same is also passed to the Actual Shipment Date for the order line as part of the OM Interface of the Interface Trip Stop.
2) The Initial Pick Up Date is the date on which the items will be shipped out of the warehouse.
While creating a delivery or assigning a delivery detail line to a delivery, the Initial Pick up date is calculated as follows:
a. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then the Initial Pickup Date => Max(Earliest Pickup Date).
b. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to the 'Scheduled Date, Requested Date' then the Initial Pickup Date => Max(Date Scheduled).
While closing the pick-up stop manually or during the Ship Confirm process, the 'Initial Pickup Date' will always be updated with the 'Actual Departure Date' (Initial Pickup Date = Actual Departure Date).
While creating a delivery or assigning a delivery detail line to a delivery, the Initial Pick up date is calculated as follows:
a. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then the Initial Pickup Date => Max(Earliest Pickup Date).
b. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to the 'Scheduled Date, Requested Date' then the Initial Pickup Date => Max(Date Scheduled).
While closing the pick-up stop manually or during the Ship Confirm process, the 'Initial Pickup Date' will always be updated with the 'Actual Departure Date' (Initial Pickup Date = Actual Departure Date).
3) The Ultimate Drop Off Date is the date on which the items reach the Customer's Ship-To Location.
a. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then the Ultimate Drop Off Date => NVL( Min(Latest Drop Off Date), Greatest(Min(Date Requested), Min(Date Scheduled))).
b. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Scheduled Date, Requested Date' then the Ultimate Drop Off Date => If ( Min(Date Requested) > Min(Date Scheduled) ) Ultimate Drop Off Date = Min(Date Requested)
Else Ultimate Drop Off Date = Min(Date Scheduled).
If Derived 'Ultimate Drop Off Date' happens to be less than 'Initial Pickup Date' derived then Ultimate Drop Off Date = Initial Pickup Date.
While closing the pick-up stop manually or during the Ship Confirm process, if the 'Ultimate Drop Off Date' is less than the 'Actual Departure Date' then Ultimate Drop Off Date = Actual Departure Date.
a. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then the Ultimate Drop Off Date => NVL( Min(Latest Drop Off Date), Greatest(Min(Date Requested), Min(Date Scheduled))).
b. If 'Delivery Date Calculation Method' Shipping Global Parameter is set to 'Scheduled Date, Requested Date' then the Ultimate Drop Off Date => If ( Min(Date Requested) > Min(Date Scheduled) ) Ultimate Drop Off Date = Min(Date Requested)
Else Ultimate Drop Off Date = Min(Date Scheduled).
If Derived 'Ultimate Drop Off Date' happens to be less than 'Initial Pickup Date' derived then Ultimate Drop Off Date = Initial Pickup Date.
While closing the pick-up stop manually or during the Ship Confirm process, if the 'Ultimate Drop Off Date' is less than the 'Actual Departure Date' then Ultimate Drop Off Date = Actual Departure Date.