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 MARCH 08, 2017

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


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