My Oracle Support Banner

LPN Reservation Gets Corrupted After Putaway Issue In Back To Back Orders Flow (Doc ID 2279849.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


In Oracle Warehouse Management, for Back to back flow with multiple Sales Orders for the same item, LPN reservations are getting corrupted after user performs putaway of one of the LPNs from Receiving into Inventory

The LPNs gets cross-reserved against IR's.

For Eg, Users see the following corruption on the LPN reservations

Item      Quantity   SO               IR                      First Receive LPN  Receive Seq.  LPN Drop Seq LPN after Drop
====== ====== ======== ===========   ==============   ======== ========== ===========
1288241      2      618052984   618052984            EDC00086063                1                   3         EDC00086064
1288241      2      619025999   619025999            EDC00086064                2                   2
1288241      3      607050280   607050280            EDC00086065                3                   1         EDC00086063

Each IR should reserved against the same Sales order

The issue can be reproduced at will with the following steps:
1. Created an item "MA_B2B02"
2. Created 3 sales orders one by one for warehouse W1 and ran import orders
3. System automatically created PR for each SO
4. Ran create internal order for ISO
5. ISO are created in M1 org.
6. Ship confirm goods one by one from M1.
7. Reservation are created in correct order
8. Received the goods and reservations are in correct order.
9. Tried to deliver the last received LPN into inventory, then all reservation and LPNs got changed


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.