My Oracle Support Banner

Mismatch Between Onhand Quantity And Material Transactions Due To Missing LOT Data In MTL_TRANSACTION_LOT_NUMBERS (Doc ID 2919429.1)

Last updated on JULY 24, 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

  1. Navigate to Inventory ->  On-Hand, Availability -> On-Hand Quantity
  2. Search for the LOT 
  3. On-hand not available
  4. Now Navigate to Inventory -> Transactions -> Material Transactions
  5. Enter LOT and click on Find
  6. 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

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