Update Material Transaction API Errors With "Quantity Must Be Less Than or Equal to Available to Transact"

(Doc ID 2298093.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, API Issues

When attempting to apply a correction to the original yielded quantity of a product line on a batch, the API errors. Users are sending first transaction with original yield quantity that gets applied successfully and product gets yielded correctly. Later, users send corrections to the yield quantity with quantity higher or lower using the update API but every transaction fails. Can successfully apply corrections to the original yield quantity through the front end application. Delete_transaction and update_transaction apis but both were unsuccessful. The following error occurs in the API:

ERROR
-----------------------
Quantity must be less than or equal to Available to transact


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run update or delete material transaction API


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