End Item Substitution - Constrained Without Detailed Scheduling - Forecasts Are Created For Older Item Version Instead Of Latest Item Version

(Doc ID 2395102.1)

Last updated on MAY 04, 2018

Applies to:

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

Symptoms

On : 12.2.4 version, Constrained planning in PROD

Users are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 19549533 - They are using 64 bit Linux for MBP and Snapshot. They are using the following file versions from one off patch 27137192

MSONWL64.ppc 120.15.12020000.58.1220402.6
MSCNPL64.ppc 120.11.12020000.11.1202040.34

They also have a beta exe MSONWL64.exe from MBP from
SCO bug 27098466
MBP Bug 27370598
SCO bug 27463504

Users are running EDD Constrained without detailed scheduling plan. They are running into an end item substitution issue on several items where the lower level item is still being forecasted instead of the successor. Also the demand created for the former item has no supply generated and creates negative PAB for the entire plan horizon. Example data

successor relationship 47726-03-->47726-04 effective 01-MAR-2018 and up.

Item/Org data
=========
item = 47726-03 - item id = 177021
item = 47726-04 - item id = 265056
Org = MAS:DE1 - org id = 8908
Org = MAS:HW3 - org id = 21735

Org = MAS:DE1 - Buy item (get from HW3 below)
Item = 47726-03
Pre Proc LT = 7
FDS = 28
On hand = 0
PTF date = 06-MAR-2018

Horizontal plan in this Org shows Forecast in 05-MAR-2018 qty = 3 and in periods 01-MAY and 01-JUN we see qty = 25 and 225 respectively. However there's no planned orders for supply to cover the demand and PAB goes to -253 which is the total forecast demand and then stays negative out through plan horizon. When checking supply pegging it says: Pegging information has not been calculated for 47726-03 in this plan. Why are they even forecasted here instead of for the -04 which is effective 01-MAR-2018 and up???

Org = MAS:DE1
item = 47726-04 - Buy item effective 01-MAR-2018
Pre Proc LT = 7
FDS = 28
On hand = 497
PTF date = 06-MAR-2018

Horizontal plan in this Orgs shows Forecast on 05-MAR-2018 qty = 497 and again in 01-AUG, 01-SEPm 01-JAN-2019 and 01-FEB-2019 which would be expected based on its effective date of 01-MAR-2018 and up

Org = MAS:HW3 - Make item
Item = 47726-03
Pre Proc LT = 7
FLM = 50
Sh Life = 1080
PTF date = 28-MAy-2018

There's dependent demand in this Org but it's at the end of the plan horizon and there's no supply generated to satisfy the demand

Org = MAS:HW3 - Make item
item = 47726-04
Pre Proc LT = 7
FLM = 50
Sh Life = 1080
Fix LT = 12.1175
Var LT = 0.000042
PTF date = 28-MAy-2018

There is supply demand to cover some of the forecast demands for Org = DE1 as expected
 
EXPECTED BEHAVIOR
-----------------------
Expected forecast demand for item = 47726-03 to be transferred to -04 since it's effective 01-MAR-2018 and up

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Successor item relationships
2. Run EDD Constrained without detailed scheduling plan
3. See several items where forecast is still being planned against an older item which is no longer effective

Changes

 

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