My Oracle Support Banner

Update Material Transaction API Fails With Transaction Qty Must Be Less Than Or Equal To Available Qty (Doc ID 2070536.1)

Last updated on JANUARY 15, 2020

Applies to:

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


Product Version: 12.1.3

When attempting to update the batch transaction for WIP Completion through the standard API gme_api_pub.update_material_txn, the following error occurs.

TrnsID:xxx LnTyp:B Transaction Date Update API Failed.
Transaction quantity must be less than or equal to available quantity;
Unable to update inventory transactions for batch abc to 27-AUG-2015 13:00:00

The issue can be reproduced at will with the following steps:
1. Run the gme_api_pub.create_material_txn
2. See error in Update Batch Status


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.