My Oracle Support Banner

Running A Wave Allocates The FULL LPN Unit With Later Date And Not The LPN Unit With Eariler Date Ignoring FEFO (Doc ID 2793380.1)

Last updated on JULY 21, 2021

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 21.2 and later
Information in this document applies to any platform.


On IBLPN UI users makes modification to batch and expiry date of a lpn then runs a wave(FEFO -First Expiry First Out) notices Allocation Method ignores the modification performed on IBLPN for expiration date and allocates the wrong FULL LPN unit.

Steps to Reproduce
The steps are:

1. Create an Order
2. Create two LPNs for the same item, quantity, lot, and expiration date.
3. Locate the LPNs in different locations.
4. Update the lot/expiration date for one LPN. The new expiration date must be more recent than the previous expiration date. This step is executed directly on the UI screen "IBLPN".
5. Run the wave template "Wave name" for the order.
6. Review the wave result which is wrong, the wave seems to ignore the last update of the expiration date(Step 4).
 if we execute the step 4 via the RF transaction "Modify LPN Batch/Expiry", it works and the assignment is correct.
1. Order OR003.
2. We create the LPNs XXXX00001531 and XXXX00001532.
with the lot "7734 05072021" and the expiration date "20/12/2021" (dd/mm/yyyy).
3. We locate the LPNs in the locations: R_RES020702 and R_RES020703.
4. Update the LPN XXXX00001532 using as the new lot: "lotetest1" and the expiration date: "01/12/2021" (dd/mm/yyyy).
5. Run the wave template "Wave template name" from the "Wave Template" screen. Previously we update the wave search template "General " to update the order number. The wave run nbr XXXX0000956 was generated.
6. The LPN XXXX00001531 was allocated, which is incorrect because the expiration date is prior to the expiration date from XXXX00001531 and the allocation method is FEFO for the template.


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.