My Oracle Support Banner

Unable to Change Lot Contol on an Existing Item (Doc ID 1266533.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Form:INVIDITM.FMB - Define Item Information
Form:RCVRCERC.FMB - Enter Receipts GUI
Form:RCVTXERT.FMB - Enter Receiving Transactions GUI


Symptoms

When attempting to enable child lot control of an existing item, the following error occurs.


ERROR
-----------------------
You cannot update this field when
1) there is on-hand quantity
OR
2) transactions exit
OR
3) lots exist.



The issue can be reproduced at will with the following steps:
1. Goto Inventory > Items > Master Items
2. Query the related item.
3. Open Organization attributes for the same item.
4. Try to enable child lot control.

Run the select statement below to determine if there is data in MTL_SUPPLY for this item:
SELECT * FROM MTL_SUPPLY
where inventory_item_id = &item_id;
or
Run rcv11i from <Note: 423279.1>


Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.