Suggested Ship Date For Past Due Purchase Orders Is Not Following Supplier Shipping Calendar (Doc ID 1573250.1)

Last updated on JUNE 20, 2023

Applies to:

Symptoms

12.1.3.8 - Shipping Calendar Functionality

MSC: Use Shipping/Receiving Calendar Y

Customer is using supplier shipping calendars that usually one day only as a ship day (i.e. Fridays) with the exception of one calendar that shows two days (Tuesday or Thursday).
However, the suggested ship dates for purchase orders and planned orders does not always honor the assigned ship calendar even though the ship calendar can be displayed when querying the orders. I

The customer changed two profile options (MSO: Use Shift Definitions When Scheduling Lead Times to "Yes" and MSO: Avoid non working days for Buy/Transfer order dates to "No" based on some earlier SR information, then ran a version of the plan (all options the same). Now all suggested ship dates are honoring the calendars inside the daily aggregation horizon with the exception of those where the suggested ship date is shown as today which is the plan run date.

The uploaded spreadsheet is an extract from the Planner's Workbench with a few columns added to explain the situation.
Plan run date = 8 july 2013.
Notice that for all planned orders and purchase order in the future, the suggested ship date is following the shipping calendar.
Column E shows the shipping calendar used.
Column F shows the day of the week.
When filtering column E by 'PRD:1DAY_R', we see all the supplies with a suggested ship date on Thursday.
When we now add a filter on column F to query only '1' which stands for Monday, we see a number of records that were supposed to ship on Thursday but are actually using Monday. All these records have an 'old due date' and 'old dock date' in the past.
We would expect to see a suggested ship date of 11-JUL-13 if the plan run was 7-JUL-13, i.e. the first Thursday of that week.

One example in the spreadsheet would be
Inventory_item_id = 31960
Organization_id =162
order number = 1000031(31)(1)(1)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.