Mismatch Between RCV Quantities And INV Quantities MMT.Primary_Quantity Truncated to 5 Decimals (Doc ID 2058164.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Symptoms

Find after applying upgrading to latest versions of rvtvq.lpc and also in RCVTXERT.pld  per  
<Note 1477233.1> - PRIMARY_QUANTITY is Rounded Off to Six (6) Decimals For Inspect \ Deliver in Rcv_Transactions
and <Note 1233833.1> The Quantity Is Rounded Off To Five Decimal Places After PO Inspection

there is  still quantity of receiving deliver transactions  truncated in Inventory to 5 decimals.
It is expected quantity be not truncated.


Steps
The issue can be reproduced at will with the following steps:

. Navigate to Receiving Receipt Transaction Summary RCVRCVRC form
See Purchase Order  Receive / Deliver transactions for .4956441

. Navigate to Inventory Material Transactions INVTTMTX form
For the same item see
Quantity = .49564

. Output of Receiving Data Collection script (Note 402245.1) shows for the purchase order

RCV_TRANSACTIONS
RECEIVE and DELIVER transactions with  
Rcv_Transaction_Id         52782        52783
Quantity                        0.4956441
Unit_Of_Measure             Each         
Primary_Quantity             0.4956441       <-- 7 decimals
Primary_Unit_Of_Measure    Each  

MTL_MATERIAL_TRANSACTIONS
Transaction_Id               24464605
Inventory_Item_Id         378956
Transaction_Type_Id      18  -- PO Receipt
Transaction_Quantity      0.49564
Transaction_Uom            Ea
Primary_Quantity            0.49564       <-- truncated to 5 decimals
Rcv_Transaction_Id         52783

Cause

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