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 MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.8 version, Constrained planning

Users are on 12.1.3 and have applied VCP 12.1.3.8 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
Item =JMBuy
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 BEHAVIOR
-----------------------
Expected the dates of the planned order to honor the specific calendars involved

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ECC Constrained Plan
2. Review workbench output for planned orders

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms