My Oracle Support Banner

Is Expiration Date Is Calculated For New Planned Orders When Using Forecast and Shelf Life Days / MRSL Functionality? (Doc ID 2167481.1)

Last updated on JUNE 18, 2021

Applies to:

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


We know that, during creation of new lot, system is calculating expiration date which is verified in ASCP module (for on-hand).

HOWEVER, we need to understand if the expiration date is calculated and taken into account for new Planned Orders in ASCP.

Item Master:
Min Order Quantity - 20 000
Max Order Quantity - 40 000

Recipe (both rules are valid at the same time):
Validity Rule, priority 1: 40 000
Validity Rule, priority 2: 20 000

Please verify the similar case like before:
- production series is normally 40 000 so priority 1 is 40k
- in August we get smaller demand than usual (for 20 000)
- another one in December lets say for 20 000 again
- expiration time for this item is 3 months

In such case we should use e.g. alternate recipe with smaller validity rule (20 000), but we do not know that at the stage of recommendation (Planned Order).  ASCP will pegged all quantity (40 000) for the future demands (in August and December) and we do not get information about any excess - and lot created in August would expire in November and cannot be used for December demand.

As I understand, at the stage of Work Order (recommendation was converted) we still do not get such information because Shelf Time would not be verified and ASCP would still pegged this quantity to both demands.

In August at the moment of lot creation (Work Order was finished) Shelf Time would be taken into account and expiration date will be calculated.

Then, it turns out, that 20 000 from this lot would be pegged for demand in August and remaining 20 000 for excess (lack of demand until the expiry). ASCP will recommend releasing of new Planned Order (40 000) which would be pegged to December's demand.
BUT - this would not happen until we have completed the batch and put the supply into inventory.


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.