My Oracle Support Banner

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 NOVEMBER 20, 2019

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 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 Item A--> Item B effective 01-MAR-2018 and up.

Item/Org data
=========
item = Item A - item id = 000001
item = Item B - item id = 000002
Org = A1 - org id = 0001
Org = A2 - org id = 0002

Org = A1 - Buy item (get from A2 below)
Item = Item A
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 Item B which is effective 01-MAR-2018 and up???

Org = A1
item = Item B - 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 = A2 - Make item
Item = Item A
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 = A2 - Make item
item = Item B
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 = A1 as expected
 
EXPECTED BEHAVIOR
-----------------------
Expected forecast demand for item = Item A to be transferred to Item B 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

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
Symptoms
Changes
Cause
Solution
References


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