Lot Quantity in Lot Transactions Window Is Lower than Quantity in Material Transactions Window (INVTVTXN)
Last updated on DECEMBER 19, 2017
Applies to:Oracle Warehouse Management - Version 12.1.1 and later
Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.
Form: INVTVTXN.fmb - View Material Transactions
On release 12.1.1:
Find material transactions in View Material Transactions form (INVTVTXN) for a lot controlled item where the lot entry quantity shown in Lot Transactions window is lower than the quantity stamped on the transaction.
Why is this happening?
The issue can be reproduced at will with the following steps:
1. Go to Inventory: (N) Transactions : Material Transactions
2. Query on the problematic item and item lot
3. See multiple transactions with the following in Lot Transactions window:
In header block:
Transacted UOM=Primary UOM
Transacted Quantity=Primary Quantity
In detail (lot entries) block:
Only one lot entry is shown with the following:
Transaction Quantity=Primary Quantity but these quantities do not match to the quantities in the header block
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms