Excess Planned Order For An Item Pegging To Excess When Using Fixed Lot Multiplier (Doc ID 1524335.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Memory Based Planner

Users are on 12.1.3 and have applied VCP 12.1.3.3 Patch 10389190. They are using 32 bit MSONEW.

They run ECC Constrained plan and see excess planned order created that is unnecessary. Example

Org = PLN:M1
Item = PK13501
Fixed Lot Multiplier = 30000
On hand = 4500
SS = 216 - this Non transient
There's only planned order demand qty = -19,416

2 planned orders qty = 30000 each one due 14-NOV-2012, the other due 29-NOV-2012

1st planned order shows pegging qty = 216 pegged qty = 0 14-NOV to Safety Stock - just below that it shows all qty = 30000 pegged to excess

2nd planned order shows pegging qty = 1656 to planned order demand and another 13260 pegged to planned order demand so this one covered all the planned order demand. Balance of 15084 pegs to excess

2nd tab is Horizontal plan - we can see Hard SS = 216. This throws PAB way high with first planned order at 34,500 - it's just not needed at all
Planned order demand qty = -19416 due 29-NOV-2012. That's it. Looks like one planned order qty = 30000 is not needed at all

Things we tried:

Set profile MSC: Use FIFO Pegging from No to Yes. This fixed the problem but leads to a different problem which is why they set the profile to No. What hapens when the profile = Yes is that on hand pegs to future demands and near term demands peg to planned orders

This looks similar to 12.1.1 Bug 10038901 but I can't tell where the fix was incorporated in 12.1.3 for certain

EXPECTED BEHAVIOR
-----------------------
Expect excess planned order not to be generated at all

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ECC constrained plan
2. Review workbench data
3. Find planned order pegged to excess


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