Is Expiration Date Is Calculated For New Planned Orders When Using Forecast and Shelf Life Days / MRSL Functionality?
Last updated on MARCH 01, 2018
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.
Min Order Quantity - 20 000
Max Order Quantity - 40 000
Recipie (both rules are valid at the same time):
Validity Rule, priority 1: 40 000
Validity Rule, priority 2: 20 000
ts. 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.
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