My Oracle Support Banner

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.

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

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
Changes
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.