10 Sept 2014

How Shipping Dates are calculated in Oracle R12

Delivery's 'Initial Pickup' and 'Ultimate Ship to Date' are calculated based on ‘Delivery Date Calculation Method’ provided in Shipping Global Parameter's setup. It can be either of following
  • Earliest Ship Date, Latest Delivery Date
  • Scheduled Date, Requested Date
Navigation:
Oracle Order Management > Shipping > Setup > Global Parameters

Initial Pickup Date:
‘Initial Pickup Date’ is the date on which the items will be shipped out of the warehouse. While creating delivery or assigning delivery line to a delivery, Initial Pick up date is calculated.
If 'Delivery Date Calculation Method' in Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then Initial Pickup Date will be Max of (Earliest Pickup Date)
If 'Delivery Date Calculation Method' in Global Parameter is set to 'Scheduled Date, Requested Date' then Initial Pickup Date will be Max of (Date Scheduled)
While closing the pick-up stop manually or during Ship Confirm process, 'Initial Pickup Date' will always be updated with 'Actual Departure Date' (Initial Pickup Date = Actual Departure Date).


Ultimate Ship to Date:
If 'Delivery Date Calculation Method' in Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then Ultimate Ship to date will be NVL(Min(Latest Dropoff date), Greatest[Min(Date Requested), Min(Date Scheduled)])
(i.e) Ultimate Ship to date will be Min of (Latest Dropoff date). If Latest Dropoff date field value is null then whichever date is greater in between Min (Date Requested) and Min (Date Scheduled) will be taken as Ultimate Ship to date.
If 'Delivery Date Calculation Method' in Global Parameter is set to 'Scheduled Date, Requested Date' then Ultimate Ship to date will be Min (Date Requested) if it less than Min (Date Scheduled) else Ultimate Ship to date will be Min (Date Scheduled).
If derived ‘Ultimate Ship to Date’ happens to be less than 'Initial Pickup Date' derived then Ultimate Ship to Date = Initial Pickup Date.
While closing the pick-up stop manually or during Ship Confirm process, if 'Ultimate Ship to Date' is less than the 'Actual Departure Date' then Ultimate Ship to Date = Actual Departure Date.

Note:
'Delivery Date Calculation Method' in Global Parameter field can be left null also. If left null, the Initial Pickup Date and Ultimate Ship to Date will be Max of (System Date)

---X---

No comments:

Copyright © 2015 an ORACLE APPS blog. All Rights Reserved.