Forecasts Moving From Sunday To Previous Friday As Per Shipping Calendar Instead Of Expected Manufacturing Calendar (Doc ID 2106833.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3.9 version, Memory Based Planner in UAT:

Users are on 12.1.3 and have applied VCP 12.1.3.9.1 Patch 17350769 - using 64 bit AIX MSONWA64.ppc 120.16.12010000.105.1201060.8 and 64 bit AIX Snapshot MSCNPA64.ppc 120.3.12010000.39.1201030.5 both from one off patch 20823232. Customer states prior to applying this patch, they did not run into this issue.

The Organization Manufacturing calendar is 7 day on/0 off so 24x7. Forecasts are collected from MRP in source instance. These forecasts are all due on Sunday. View Collected data shows these demands being due on Sunday. However after running a EDD Classic Constrained plan, the forecasts seem to be using the shipping calendar now instead of the manufacturing calendar and are being pulled back to the previous Friday date. Example data:

Calendar code = 331WORKDAY is 7 on 0 off and starts on Sunday 02-NOV-2013 with horizon Saturday 05-JAN-2047 - this have 1 shift time with Start = 00:00:00 and Stop = 23:59:50

Calendar Code = 331SHIP is 0 on and 1 off (Sunday), 5 on 0 off (Mon-Fri) and 0 on 1 off (Saturday) - so shipping Mon - Fri only

Org code = 331WORKDAY is the Org Mfg Calendar
Profile MSC: Use Shipping/Receiving Calendar = Yes
Profile MSC: Forecast Spreading Calendar = Organization Manufacturing Calendar

Item = 0032242
Org = 331

Shows forecast qty = 444 due on 29-JAN-2016 (Friday) and also on the following Friday dates:
Qty = 333 due 05-FEBG-2016
Qty = 111 due 12-FEB-2016
Qty = 259 due 19-FEB-2016

However, the collected data shows the above due on Sunday
07-FEB-2016
14-DEB-2016
21-FEB-2016

Things we tried
===========
1. Set profile MSC: Calendar Reference for Bucketing from Null to 24x7 calendar - did not work
2. Checked the Plan owning Org calendar and confirmed it's also 24x7

EXPECTED BEHAVIOR
-----------------------
Expect forecast dates to remain on Sunday dates

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply one off patch 20823232
2. After running plans post patch they started seeing Sunday forecast pulled back to the previous Friday

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