SPP Not Considering On Hand Of Old Item In A Supersession Chain Setup (Doc ID 2521498.1)

Last updated on AUGUST 19, 2019

Applies to:

Symptoms

On : 12.2.7 version, Memory Based Planner in Test

Users are on 12.2.7 and have applied VCP patch 27190568 - 12.2.7.1 - Mandatory Cum Patch for 12.2.7 / R12.SCP_PF.C.Delta.8 - They have applied 12.2.7.1 cum #3 patch 28797421 - latest is cum #6 patch 29288384 - using 64 bit Linux MBP and snapshot with MBP version MSONWL64.ppc 120.15.12020000.99 and snapshot version MSCNPL64.ppc 120.11.12020000.40

Users are running an SPP plan and they generate inline forecast during the plan run. They have a supercession rule setup. What they're seeing is they have on hand qty = 30 of the primary item, however the inline forecast is generated for the supersession item instead so the primary on hand is not being used

Original primary item = N6450-60001 item id = 381247
on hand = 30
They have usage returns history

Supercession item = N2756-60001 item id = 381248 - effective from 01-FEB-2019 and it is NOT reciprocal
on hand = 4
The inline forecast for this item is generated for this item not the primary item

Service plan - Overwrite = All - Overwrite Manual Forecast = All - DTF, PTF and ESSR enabled - 60 days/4 weeks/5 periods - no enforce constraints - several orgs - no optimization - enabling launch parameter Generate Inline Forecast

EXPECTED BEHAVIOR
-----------------------
Expected the primary on hand to be used

If they make the supersession reciprocal it then uses the primary on hand. Support attempted to duplicate but inline forecast is not being generated for some reason

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load usage history for primary item
2. Setup primary to supersession item
3. collect data
4. Run SPP plan and generated inline forecast
5. Plan is not using primary on hand, only supersession item

Changes

Cause

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