Mismatch Between Onhand Quantity And Material Transactions Due To Missing LOT Data In MTL_TRANSACTION_LOT_NUMBERS
(Doc ID 2919429.1)
Last updated on JANUARY 11, 2023
Applies to:Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.
There is discrepancy between on-hand quantity and sum of Material transactions quantity for one particular lot due to missing data in mtl_transaction_lot_numbers table for some transactions.
The issue can be identified from application using below steps
- Navigate to Inventory -> On-Hand, Availability -> On-Hand Quantity
- Search for the LOT
- On-hand not available
- Now Navigate to Inventory -> Transactions -> Material Transactions
- Enter LOT and click on Find
- The sum of material transactions Quantity is not Zero and Lot/Serial button is disabled for some transactions
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