My Oracle Support Banner

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

Last updated on AUGUST 19, 2019

Applies to:

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


On : version, Memory Based Planner in UAT:

Users are on 12.1.3 and have applied VCP 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

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

Expect forecast dates to remain on Sunday dates

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


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

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