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:

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:

• Lot Expiration Date On Hand Form (INVMWBIV) - January 1, 2029
• Lot Expiration Date Lot Form (INVIDILT) - December 31, 2028 at 19:00

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

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