Subinventory Transfer Fails When Organization Level Onhand Quantity is Negative and When the Profile 'INV:Override Neg for Backflush' is Yes.

(Doc ID 2238264.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

Subinventory transfer fails with the below error when the transaction is done from subinventory transfer form of desktop.

"The transaction has failed. Another process has consumed the required material. Please delete this transaction record, close and re-open the form in order to re-enter the transaction"

However the same transaction succeeds when done from mobile.

Conditions to reproduce the issue :
1. The org level on-hand is negative.
2. 'Allow Negative Balances' is not enabled at Organization level.
3. The on-hand qty is positive in the 'From Subinventory' from where the subinventory transfer transaction is initiated.
4. The profile 'INV:Override Neg for Backflush' set to Yes.

The reason why org level on-hand quantity is negative is because there is a WIP backflush transaction that has happened which made the on-hand qty in one of the organization subinventories to go negative
due to the profile 'INV:Override Neg for Backflush' setting of Yes.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms