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

Goal

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

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

Solution

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