My Oracle Support Banner

Lot Expiration Date / Timestamp Different on Lots form (INVIDILT) Compared to Material Workbench (INVMWBIV) (Doc ID 2315975.1)

Last updated on FEBRUARY 01, 2023

Applies to:

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


The Onhand form shows lot expiration on the next day. Users concerned with data corruption and this does not impact all lots...

The lot expiration time is something like 7PM.
When users update the time to earlier like 1PM on the Lot form to earlier in the day, the date On Hand form reflects the earlier day.

Example Dates:

Why does this happen ? 

Screen shot examples

Example of data in the database

Example of data in the onhand material workbench:

Example of data in the lot transaction form (and similar date shows in the lot form):


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
 Screen shot examples
 Community Idea

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