The Lot Expiration Control Flag Cannot Be Updated For Item Without Stock (Doc ID 866906.1)

Last updated on JUNE 10, 2013

Applies to:

Oracle Inventory Management - Version 12.0.6 to 12.1.2 [Release 12 to 12.1]
Information in this document applies to any platform.
FORM:INVIDITM.FMB - Define Item Information


Goal

 

Please note that this Article applied only to Items which are assigned to
Process-Enabled Inventory Organizations.

In Discrete Inventory, control of the Shelf-Life Item Attributes is reckoned
to be slightly less critical than in Process Manufacturing, so in Discrete you
are allowed to update these columns if there is no Onhand and no Pending
Transactions



The documentation (on-line help and User Guide) suggests that if
you have zero onhand quantity of an Item then you should be able
to change the Lot Expiration / Shelf Life Control attribute of
that Item.

See the Oracle Inventory Rel 12 User's Guide (Part No. B31547-04)
Page 6-21.

In the paragraph on "Lot Expiration (Shelf Life) Control" the only
proviso about updating this screen field is:

Important: You cannot change lot expiration control when on-hand
quantity of the item exists. If Lot Expiration is controlled at the Master
level, the check for on-hand quantity is against the sum of on hand
quantities in all child organizations.



In reality, it seems that if any Lot Number exists for the Item -
even if that Lot is completely played out and has zero onhand
quantity and no pending transactions - then the change is not allowed.

Error message displayed is 'INV_LOT_QOH_CANNOT_UPDATE':

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

Solution

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