Lot Expiration Cannot Be Updated When There Is No Onhand or Apparent Pending Transactions

(Doc ID 1535506.1)

Last updated on JULY 25, 2016

Applies to:

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

Symptoms

When attempting to change lot expiration value for item with no on-hand quantity and no pending transactions the following error occur

ERROR
-----------------------
You cannot update this field when

1) there is on-hand quantity
OR
2) transaction exists
OR
3) lots exists
 
STEPS
----------
Navigation path: Inventory-Items-Organization Items
Lot expiration  - control field cannot be updated.
The problem does not occur for all items.

Cause

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