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 APRIL 18, 2025

Applies to:

Symptoms

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
 But
 UNIT_OF_MEASURE = PRIMARY_UNIT_OF_MEASURE

In MTL_MATERIAL_TRANSACTIONS for Deliver Receipt
 TRANSACTION_QUANTITY <> PRIMARY_QUANTITY
 But
 MSI.PRIMARY_UOM_CODE = MMT.TRANSACTION_UOM


Expected Behavior
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)

Steps

1. Navigate to Material Transactions form
2. See some transactions for RMA 12345678 including
Transaction Quantity 1330
Transaction UOM EA
Primary Quantity 22086
Primary UOM

. In mtl_material_transactions table
Output of following identification sql script per Bug 16841282 returns some records

returns the related deliver transactions with

TRANSACTION_TYPE DELIVER
UNIT_OF_MEASURE = EA =  PRIMARY_UNIT_OF_MEASURE
UOM_CODE EA

But
PRIMARY_QUANTITY <=>  QUANTITY

TRANSACTION_ID 123456789
TRANSACTION_TYPE DELIVER
TRANSACTION_DATE 19-DEC-14
QUANTITY 1330
UNIT_OF_MEASURE EA
SHIPMENT_HEADER_ID 3851
SOURCE_DOCUMENT_CODE RMA
DESTINATION_TYPE_CODE INVENTORY
PRIMARY_QUANTITY 22086
PRIMARY_UNIT_OF_MEASURE EA
UOM_CODE EA
ORGANIZATION_ID 60
SUBINVENTORY SCRAP-RET
OE_ORDER_HEADER_ID 358
OE_ORDER_LINE_ID 1914
 

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
ORGANIZATION_ID 207
PROCESS_ENABLED_FLAG N  

Changes

Cause

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