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 JULY 30, 2018

Applies to:

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

Goal

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

Workaround
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):

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.