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
When attempting to enable child lot control of an existing item, the following error occurs.
You cannot update this field when
1) there is on-hand quantity
2) transactions exit
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;
Run rcv11i from <Note: 423279.1>
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