Transaction Quantity not equal to Primary Quantity in RT and MMT when PRIMARY UOM same as Transaction UOM
(Doc ID 1986652.1)
Last updated on FEBRUARY 08, 2019
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Find for one RMA received one qty but the primary changed to a higher number
In RCV_TRANSACTIONS for RMA Deliver Inventory Receipt
QUANTITY <> PRIMARY_QUANTITY
UNIT_OF_MEASURE = PRIMARY_UNIT_OF_MEASURE
In MTL_MATERIAL_TRANSACTIONS for Deliver Receipt
TRANSACTION_QUANTITY <> PRIMARY_QUANTITY
MSI.PRIMARY_UOM_CODE = MMT.TRANSACTION_UOM
Expect if UNIT_OF_MEASURE = PRIMARY_UNIT_OF_MEASURE then PRIMARY_QUANTITY = QUANTITY in RCV_TRANSACTIONS and thus
Expect correct data in MTL_MATERIAL_TRANSACTIONS table ( if the TRANSACTION_UOM = primary uom for the item, then PRIMARY_QUANTITY = TRANSACTION_QUANTITY)
1. Navigate to Material Transactions form
2. See some transactions for RMA 12345678 including
Transaction Quantity 1330
Transaction UOM EA
Primary Quantity 22086
. In mtl_material_transactions table
Output of following identification sql script per Bug 16841282 returns some records
returns the related deliver transactions with
UNIT_OF_MEASURE = EA = PRIMARY_UNIT_OF_MEASURE
PRIMARY_QUANTITY <=> QUANTITY
What has been checked
This issue is NOT reproducible at will on standard/vanilla Oracle code.
It did not start occurring after any recent patch application, upgrade or anything else.
Customer is NOT using OPM so this is not issue described in <Note 1464677.1>
In MTL_PARAMETERS table
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