My Oracle Support Banner

Secondary Quantity Mismatch Between RCV_LOT_TRANSACTIONS and RCV_TRANSACTIONS (Doc ID 2546693.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Receiving Functions

ACTUAL BEHAVIOR
---------------
Secondary Quantities Mismatch between
- RCV_LOT_TRANSACTIONS and RCV_TRANSACTIONS
- MTL_MATERIAL_TRANSACTIONS and MTL_TRANSACTION_LOT_NUMBERS 

EXPECTED BEHAVIOR
-----------------------
Secondary Quantities should match between RCV_LOT_TRANSACTIONS and RCV_TRANSACTIONS
Secondary Quantities should match between MTL_TRANSACTION_LOT_NUMBERS and MTL_MATERIAL_TRANSACTIONS

STEPS
-----------------------
The issue can be verified at will with the following steps:
1. Check existing Receipt transactions (RMA Receipt/ Intransit Receipt/ PO Receipt/Int Req Intr Rcpt) for dual UOM items
2. Found different secondary quantity on transaction and its corresponding lot
3. Check existing Receiving Transactions
4. Found different secondary quantity on transaction and its corresponding lot



Cause

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
Symptoms
Cause
Solution
References


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