My Oracle Support Banner

Issues with Batch Picking and Move Order Allocation With Regards to Supply Subinventory (Doc ID 2443732.1)

Last updated on JANUARY 23, 2020

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Batches

Original Issue:

Set up picking rules with the following criteria:
Subinventory Asc 2
Locator Asc 3

Set the picking order on the subinventory that will be the supply subinventory, call it Subinv A, to a lower number (higher priority) than another subinventory, call it Subinv B.
Create onhand inventory in Subinv B.
Use the item as an ingredient in a batch, setting the supply subinventory to Subinv A.
Run Picking
A move order is created to move the required qty, 245, from where there is onhand, Subinv B, to Subinv A.
In Transact Move Orders, edit the qty and lot qty to 200 and transact.
200 is moved to Subinv A and automatically reserved to the batch.

Now run picking on the batch again.
A new move order is created for the remaining required qty of 45.
The move order should be created to again move the material from Subinv B, where there is more available inventory, to Subinv A.
However, the move order actually is created to move 45 from Subinv A to Subinv A, even though there is only 200 in Subinv A and it is already reserved to the batch.
Checking the Material Workbench now, the onhand in Subinv A is 200, but the Available to Reserve and Available to Transact are now -45.

The second move order should have also been from Subinv B to Subinv A. Although Subinv A has priority in picking order, the inventory in that subinventory is already reserved to the batch. An additional 45 is needed, so it should have been allocated from Subinv B.

This first issue was resolved by applying <patch 27890763:R12.WMS.C>. This patch introduced a change to Picking and the allocation of move orders created through Picking so that material in the Supply Subinventory will no longer be allocated. This is to stop the odd behavior of the system creating a move order to move material from Subinventory A to Subinventory A. A problem remains, however, if the inventory is in a different locator within the subinventory. If the Supply Subinventory/Locator is Subinventory A, Locator 1, and there is available inventory in Subinventory A, Locator 2 which meets the picking rule criteria (for example, it is the first to expire), this is still not being allocated.


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.