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 JUNE 30, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.