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 JULY 12, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, Receiving Functions

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

. Navigate to Material Transactions  form
See some transactions for RMA 10029341 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 9015964
TRANSACTION_TYPE DELIVER
TRANSACTION_DATE 19-DEC-14
QUANTITY 1330
UNIT_OF_MEASURE EA
SHIPMENT_HEADER_ID 3856511
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 3584121
OE_ORDER_LINE_ID 19149723
 

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 60
PROCESS_ENABLED_FLAG N  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms