My Oracle Support Banner

ASCP Plan Creates Unexpected Supply Planned Orders For Expired Lots (Doc ID 2062239.1)

Last updated on MAY 05, 2021

Applies to:

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


Memory Based Planner

Users run an unconstrained ASCP plan and they use Lots with Shelf Life Control (Lot Expiration or sometimes known as Lot Expiry). They state that in the plan horizon they see Expired Lots creating gross requirements at the date they are expiring. Users are not expecting this to show up as demand and believe that planned orders are being created to satisfy the Expired Lots. Example data:

Item = JMExpire
Org = TST:M1
Safety Stock = 53 (Hard INV setup)
On hand = 1392
On hand qty = 700 expires 15-FEB-2016
On hand qty = 692 expires 15-MAR-2016

Forecast and Sales order demand totals 760 out through 19-OCT-2015 and there's no further demand. This leaves PAB = 632 until 15-FEB-2016 which is where qty = 357 on hand expires. This is shown as a gross requirement and drops PAB from 632 to 275. Then on 15-MAR-2016 the balance of qty = 275 on hand expires and is shown as a gross requirement and takes PAB to 0. However since safety stock = 53, a planned order is generated here for qty = 53 which then shows PAB for this bucket = 53 to match safety stock.

1. Run ASCP plan with on hand that will expire in the future
2. Review plan out , for orders 'Expired Lot'
3. Users see Expired Lots being shown as gross requirements


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.