My Oracle Support Banner

GME_API_PUB.update_material_txn Errors On Date Correction for Lot Indivisible Items - "Transaction quantity must be less than or equal to available quantity" (Doc ID 1505271.1)

Last updated on JANUARY 23, 2020

Applies to:

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


On : 12.1.3 version, Inventory Convergence

item is setup to be indivisible. When trying to correct the product yield transaction in the form receive the message below.
When using API gme_api_pub.update_material_txn API to perform date corrections against OPM WIP Completions if the related item is set to be lot indivisible.
The message we are getting is: "This item is defined as being lot indivisible. For this reason the entire lot quantity must be used. The system does not permit indivisible lots to be divided."

Transaction quantity must be less than or equal to available quantity

The issue can be reproduced at will with the following steps:
1. Production supervisor > batches
Yield a lot for an indivisible item
In another batch consume this lot
In original yield batch, go to correct material transactions, change only the transaction date.
See error


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.