My Oracle Support Banner

"Transaction quantity must be less than or equal to available quantity" when 'Revert to WIP' a Batch for which the Product produced has On-hand quantity now as 'zero'. (Doc ID 1564959.1)

Last updated on JANUARY 29, 2024

Applies to:

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

Symptoms

On : 12.1.3 version, Batches

When attempting to set the status of a 'Completed' Batch to 'Pending' after issuing out all the On-hand quantity of the Product,
the following error occurs.

This issue happens for both Lot Controlled and non-Lot Controlled Items.

The Organization is set to 'Allow Negative Inventory' in the Organization Parameters screen.


ERROR
-----------------------
  "Transaction quantity must be less than or equal to available quantity"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a Batch
2. Complete Product qty, Batch Status = Completed.
3. Misc Issue out the Product qty.
4. Attempt to change the Batch Status from 'WIP to 'Pending'.


BUSINESS IMPACT
------------------------------
The issue has the following business impact:
Due to this issue, users cannot set the Batch Status back to 'Pending'.


Cause

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
Symptoms
Cause
Solution
References


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