My Oracle Support Banner

Direct Ship:Two different Sales Order lines LPNs merged into a single Parent LPN - Reservation Quantity is updated incorrectly. (Doc ID 2708459.1)

Last updated on SEPTEMBER 20, 2020

Applies to:

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


On : 12.2.7 version, LPN Management

When a Sales Order with two Order Lines, say for example :Line No: 1.1 and 1.2 - 4 Quantity each.
Now, create four LPNS with item from order and each has to 2 Qty
Create reservation for each LPN, in this case say for example: LPN1 and LPN2 are reserved for Line 1.1 and LPN3 and LPN4 are reserved for Line 1.2.
And two LPNs related to Lines: 1.1 and 1.2 are merged into one Parent LPN
Similarly, remaining two LPNs related to Lines: 1.1 and 1.2 are merged into another Parent LPN

Now proceed to Ship,
In Direct Ship: When 1st LPN is given, entire LPN is consumed. Now, user continued and enter 2nd LPN, at this time in Reservation window Quantity is flipped to 4 for the last LPN.

No, such issue observed when 2 LPNs of same line is merged into one LPN. Issue is observed only in case of 2 different line LPNs are merged into Single LPN.

When two different Line's LPNs are merged into single LPN and Quantities are loaded to dock. Under reservation no quantity flipping should happen.

The issue can be reproduced at will with the following steps:
1. Create an Order, with a line with qty as 8 and book it.
2. Now, split the line to two lines 4 each.
3. Now, created four LPNS with item from order and each has to 2 Qty.
Create reservation for each LPN. Summary you should have 4 lpns each 2Qty
Say, line 50.10 has LPNs: LPN1 and LPN2 are Reserved
And line 50.11 has LPNs: LPN3 and LPN4 are Reserved
4. Now, Merge LPN1 and LPN3 into one Parent LPN1
  And Merge LPN2 and LPN4 into one Parent LPN2
5. Now proceed to Direct Ship in WMS, Load Parent LPN1 to dock and it gives the message as Entire LPN is consumed.
  And continue and enter Parent LPN2.
6. Now, Reservation quantity in LPN4 is updated to 4 instead of 2.




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.