My Oracle Support Banner

Incorrect Pegging for Items with Safety Stock and Expiring Lots (Doc ID 981946.1)

Last updated on FEBRUARY 08, 2022

Applies to:

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


On in Dev with Engine/UI RUP #35:

All of the demand is covered by on-hand quantity and the planned order that is created in the last bucket should just be used to fulfill safety stock after the on-hand expires.

Beginning Onhand balance = 71
Gross Requirements from Forecast = 26
Safety Stock = 10
Expired Lots = 71-26 = 45

The horizontal plan looks correct but the PWB is showing two lines of 10 pegged to Safety Stock. There should be only one line. Moreover, when looking at the remaining quantity (45) which is pegged to an expired lot, the net remaining quantity is actually 45 which shows that the duplicate line that was pegged to excess is only counted once.

1) Expect to see one line for safety stock in the pegging tree
2) Forecast records should be pegged to on-hand and this planned order should be pegged to Safety stock

The issue can be reproduced at will with the following steps:
Create an item with safety stock, current demand, and an on-hand quantity that has a lot expiration out in the future. The current on-hand quantity should be enough to satisfy the current demand + safety stock requirements.

Run a collection and an unconstrained plan.

Expected Results: The current on-hand supply is used to fulfill the current demand and safety stock. A small planned order is created out in the future to replenish safety stock once the on-hand has expired.

Actual results: The current on-hand is pegged to the expired lot in the future and to safety stock. A large planned order is created in the future to fulfill the entire expired lot, not just the safety stock. The current demand is pegged to the future planned order.


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.