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

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.