My Oracle Support Banner

Select Available Inventory Does Not Show Some Available Lots When Accessed from Material Transactions Form, but it Does When Accessed from Reservations (Doc ID 2113566.1)

Last updated on JANUARY 24, 2020

Applies to:

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


On : 12.1.3 version, Select Available Inventory from Batch Material Transactions

Customer had 2 LTR available of one lot (with other lots also available).
They do a WIP Issue in a batch for 1 LTR of this lot.
They then reserve 0.5 LTR of this lot to the ingredient line.
Material workbench shows 1 LTR onhand and 0.5 LTR available to reserve and available to transact, as expected.
From Reservations Window in the batch, they go to Select Available Inventory, and it also shows 1 LTR onhand and 0.5 LTR available.
However, if they go to Material Transactions in the batch and then to Select Available Inventory, it does not show this lot at all.
The material status does allow WIP Issue, and the lot is not expired.

Expect Select Available Inventory to show the lot as available when accessed from Material Transactions as it is when accessed from Item Reservations.


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.