ECC Constrained Plan Not honoring Intransit Carrier Calendar nor Supplier Capacity Calendar - Sugg Start Date, Sugg Dock Date Incorrect
(Doc ID 1601178.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version, Constrained planning
Users are on 12.1.3 and have applied VCP 22.214.171.124 Patch 14247039 - using 64 Sun MBP MSONWS64.exe 120.14.12010000.79.1201010.2 via one off patch 14840426. They're running ECC Classic Constrained plan 180 days/52 weeks/18 periods - plan is about 3 years - 6 orgs. They use Shipping/Receiving/Supplier Capacity/Intransit Carrier Calendars
Profile MSC: Buy Order Processing Lead Time Calendar set to = Supplier Capacity Calendar
Profile: MSC: Use Shipping/Receiving Calendar = Yes
What they're finding is the dates suggested by the planned order do not appear to be following the calendar setups in some cases. Example:
Org = TST:M1
Preprocessing = 1
Processing = 20 (As per ASL Setup - item attributes it's set to 99)
Post Processing = 3
Intransit time from supplier = 5
Planned order trans id = 6306136 and confirmed in MSLD_Supplies.dat
There's a planned order for this buy item with the following due dates:
Sugg Due Date = 30-DEC-2013 - this is okay
Sugg Dock Date = 25-DEC-2013 - this is okay since it backed off 3 working days from the Org Mfg calendar which is 5 on 2 off. In this calendar 25-DEC is valid workday
Sugg Ship Date = 20-DEC-2013 - this is NOT okay since it used 24x7 calendar for intransit carrier calendar. The carrier calendar is 5 on 2 off. Expected this to be 18-DEC-2013 to honor 5 day intransit/carrier calendar for the supplier
Sugg Start Date = 29-NOV-2013 - this is NOT okay since if you use the supplier capacity calendar which is 5 on 2 off and back up 20 working days, this was expected to be 27-NOV-2013
Sugg Order Date = 28-NOV-2013 - while this did back up 1 day from 29-NOV-2013 above, this is still NOT okay because we expected the Sugg Start Date = 27-NOV-2013 so here we expected to see 26-NOV-2013 here instead
1. Start Date is not getting derived by offsetting the Processing Lead time from Dock Date .
2. While deriving Ship Date from Dock date, system uses the transit time, but it is not honouring Carrier Calendar – it is using 24/7 calendar.
For the Point 1:
It seems system is first offsetting Transit Time (5 days) from the deriving the ‘ship date’ (using 24/7 calendar as point-2), then using [Processing Lead time(20) – Transit Time(5)] = 15 days to offset from ‘ship date’ using supplier capacity calendar to derive the ‘Start Date’
We did try setting MSO: Lead Time Control from Violate minimum processing lead times TO Do not violate minimum processing lead times but this did not help
Expected the dates of the planned order to honor the specific calendars involved
The issue can be reproduced at will with the following steps:
1. Run ECC Constrained Plan
2. Review workbench output for planned orders
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document