My Oracle Support Banner

E1: 34: MRP Planning of Lot Expiry Quantity is Consumed by Safety Stock not Sales Order Quantity (R3483) (Doc ID 2662331.1)

Last updated on NOVEMBER 24, 2020

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


While the +LEFF on hand quantity can be expected to be reduced by the item safety stock quantity, that lot quantity will still expire if not shipped out prior to expiry date.  When the safety stock is less than the starting lot quantity, the unshipped quantity is shown in the time series in a -LEXP row.  This is correct as the quantity reserved, as safety stock will still reach expiry, if not shipped prior.  The issue is that that same logic should apply whether or not the safety stock quantity is less than the lot quantity or is greater than the lot quantity.  The lot quantity is still subject to expiry, if not shipped out on a sales order.  

Steps to duplicate: 
1.  Create a lot process item, such as NN, and adjust in on hand quantity with lot expiry or shelf life within the planning horizon but inside the date of sales order demand in excess of on hand.
2.  Enter a SO dated within the lot effective and expiry dates, that only consumes a partial or portion of the lot quantity.  The balance of this lot quantity should expire on the expiry date.  For example have qty 8 on hand, enter a SO for qty 5, meaning that 3 will expire, showing as a -LEXP in the time series.  
3.  Run MRP R3483 and review messages and time series, confirming the -LEXP appears as expected.  Consecutively test with safety Stock (SS) of increasing quantity, such as 0, 4, 8, 12, and 24.
4.  Review the time series and messages.  Note that the -LEXP row is written to the time series for SS less than or equal to the on hand lot quantity.  The -LEXP row is not written to the time series for SS greater than the on hand lot quantity.   This is incorrect.


To view full details, 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 a vibrant support community of peers and Oracle experts.