Mismatch Between RCV Quantities And INV Quantities MMT.Primary_Quantity Truncated to 5 Decimals
(Doc ID 2058164.1)
Last updated on APRIL 04, 2019
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.
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.
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
RECEIVE and DELIVER transactions with
Rcv_Transaction_Id 52782 52783
Primary_Quantity 0.4956441 <-- 7 decimals
Transaction_Type_Id 18 -- PO Receipt
Primary_Quantity 0.49564 <-- truncated to 5 decimals
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