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

最新推荐文章于 2022-09-20 20:59:37 发布

kikiwhq

最新推荐文章于 2022-09-20 20:59:37 发布

阅读量1k

点赞数

分类专栏： SHIP DATE 文章标签： SHIP DATE

SHIP DATE 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了EBS系统中如何计算物料交易日期和配送日期，包括初始取货日期和最终交货日期的计算逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.