My Oracle Support Banner

WMS - Pick Release of Sales Orders Is Allocating Already Allocated Stock (Doc ID 2023084.1)

Last updated on FEBRUARY 13, 2019

Applies to:

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


Pick Release process is allocating more quantity than available which may lead to negative Available To Transact (ATT) and negative Available To Transact (ATR) quantities.

It is allocating material that is packed into an LPN whereas there is already a suggestion (allocation) for the same for another sales order.
The problem does not occur if the first sales order is pick confirmed before pick releasing the second order.

Also there is no issue when scheduling sales order lines through the Sales Orders form to create organization level reservations. If there is not enough available quantity, then no reservation gets created as expected.

The problem occurs in WMS organizations. It does not occur in non WMS organizations.

Expect not getting negative ATR and ATT.
Expect the system to look for another locator / LPN instead.

The issue can be replicated per the following steps:
1. For a plain item, get the following on hand quantities:
a) quantity 48 in locator SUB_1 / LOC_1
b) quantity 48 in locator SUB_1 / LOC_2
** This stock in LOC_2 is packed into an LPN and it is already reserved and allocated for a sales order line.
c) more on hand in other locators of same subinventory SUB_1 and in other subinventories
2. Pick release another sales order with ordered quantity 120
3. See three allocations got created as below:
quantity 48 on locator SUB_1 / LOC_1
quantity 48 on locator SUB_1 / LOC_2 ** here is the issue
quantity 24 on locator SUB_2 / LOC_3
** Available quantity in LOC_2 is now negative. (-48)


The problem would surface after patching.


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.