LPN Reservation Gets Corrupted After Putaway Issue In Back To Back Orders Flow

(Doc ID 2279849.1)

Last updated on JUNE 23, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
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


EXPECTED BEHAVIOR
-----------------------
Each IR should reserved against the same Sales order

STEPS
-----------------------
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



Cause

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