Getting 'Error: Missing Expiration Date' While Receiving ISO Internal Sales Order with Lot Item (Doc ID 1577792.1)

Last updated on MAY 12, 2016

Applies to:

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

Symptoms

When attempting to enter an expired lot in the Lot Entry form when accessed via either the Miscellaneous Receipt form or the core Receiving form there is no Expiration date shown for the lot.  

In the Misc Receipts Lot Entry form, the expiration date field is null, in the core receiving Lot Entry form the expiration date is also null, but it errors out that the expiration date is missing when the transaction is saved.

When the item diagnostics "Oracle Item Data Collection" Diagnostic (Note 463602.1) is collected for both Source and Receiving orgs, the following is observed:

* The lot is showing an expiration date in the shipping (source) org, for example:

Lot Number      Lot Number Status (Id)  Expiration Date
12SA521SCO            OK (96)                   03-NOV-39 08:45  

* But the item is showing in both source and receiving orgs as NOT shelf lot expiration

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