My Oracle Support Banner

Non-Reservable Lots Are Not Displayed In Select Available Inventory Screen When Called from Batch Material Transactions, Even Though Their Status Allows WIP Issue (Doc ID 1623781.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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


On : 12.1.3 version,

We have an onhand material status defined as REWK. All transactions are allowed other than Sales Order Issue. It is marked as not reservable because we don't want it allocated to a sales order.

We can use REWK (rework) status lots in a batch if we directly entry them on the Material Transactions screen. If we use Select Available Inventory, they do not show up. They are not showing up because the status REWK is marked as reservations not allowed. The inventory should show up in the Select Available Inventory screen here because it is being accessed from batch Material Transactions, not Reservations, and the status allows WIP Issue.

When Select Available Inventory is accessed in Transactions mode, it should not consider whether a status allows reservations, only whether it allows the type of transaction it is being used to create.

The issue can be reproduced at will with the following steps:
1. Create and release batch with manual consumption ingredient
2. Have onhand inventory with an onhand status that allows WIP Issue but does not allow reservations.
3. From batch Material Details, click Transact Material, click into the bottom section, then click Select Available Inventory.

The issue has the following business impact:
Due to this issue, users cannot see onhand inventory that should be available.


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.