My Oracle Support Banner

Lot Quantity in Lot Transactions Window Is Lower than Quantity in Material Transactions Window (INVTVTXN) (Doc ID 2038366.1)

Last updated on FEBRUARY 15, 2019

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


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.