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 AUGUST 16, 2018

Applies to:

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

Symptoms

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."



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. 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.
Save
See error




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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.