HOW SHIPPING DATES ARE CALCULATED. (文档 ID 1076040.1)

HOW SHIPPING DATES ARE CALCULATED. (文档 ID 1076040.1)

转到底部

---

In this Document Goal   Solution Applies to: Oracle Shipping Execution - Version 11.5.10.0 and later Information in this document applies to any platform. ***Checked for relevance on 24-JAN-2014*** Goal 1. How does EBS derive the Material Transaction Date? 2. What is the purpose of Initial Pick Up Date and how is it calculated? 3. What is the purpose of the Ultimate Ship To Date and how is it calculated? Solution 1) Actual Departure Date will be Material Transaction Date. Delivery's 'Initial Pickup' & 'Ultimate Dropoff Date' is calculated based on Shipping Global Parameter's setup. It can be either of following a. Earliest Ship Date, Latest Delivery Date b. Scheduled Date, Requested Date 2) Initial Pick Up 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 a. If 'Delivery Date Calculation Method' Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then Initial Pickup Date => Max(Earliest Pickup Date) b. If 'Delivery Date Calculation Method' Global Parameter is set to 'Scheduled Date, Requested Date' then Initial Pickup Date => Max(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). 3) Ultimate Dropoff Date is the date on which the items reaches the Customer's Ship-To Location. a. If 'Delivery Date Calculation Method' Global Parameter is set to 'Earliest Ship Date, Latest Delivery Date' then Ultimate Dropoff Date => NVL( Min(Latest Dropoff Date), Greatest(Min(Date Requested), Min(Date Scheduled)) ) b. If 'Delivery Date Calculation Method' Global Parameter is set to 'Scheduled Date, Requested Date' then Ultimate Dropoff Date => If ( Min(Date Requested) > Min(Date Scheduled) ) Ultimate Dropoff Date = Min(Date Requested) Else Ultimate Dropoff Date = Min(Date Scheduled) If Derived 'Ultimate Dropoff Date' happens to be less than 'Initial Pickup Date' derived then Ultimate Dropoff Date = Initial Pickup Date. While closing the pick-up stop manually or during Ship Confirm process, if 'Ultimate Dropoff Date' is less than the 'Actual Departure Date' then Ultimate Dropoff Date = Actual Departure Date. Still Have Questions? To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Shipping Execution Community.