My Oracle Support Banner

HowTo Find Where Lot Used Via SQL? (Doc ID 1374969.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
Form:INVTDILT.FMB - Update Item Lot Information


Accidentally created a lot and want to know where the lot was used.
What tables should be reviewed?

1. Navigate to Inventory > Onhand > Lot
2. Create a lot (but no onhand).

Note: Creating a lot requires Item Number and Lot. Sometimes users enter wrong item number for the lot.


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.