ROI Receipts Lose Quantity Decimal Precision - Quantity Rounded To 6 Decimal Places

(Doc ID 1295882.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor


Symptoms

Find Receipt quantities for imported receipts through the ROI receiving transactions interface are not processed with the same precision as manual receipts.

Imported receipts are rounded to a precision of 6 decimal places, whereas manual receipts are not.

Steps

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

1) Populate Receiving Open interface Table RCV_TRANSACTIONS_INTERFACE with quantity having a large number of decimals
     - Quantity: 0.123456789012345

2) Run RVCTP Receiving Transaction Processor

3) Navigate to Receiving Summary form to query the receipt created by ROI
    - Quantity: 0.123457
In RCV_TRANSACTIONS table Quantity digits get trimmed into 0.123457

4) Enter Similar receipt via Core Purchasing Receipts form RCVRCERC and run RVCTP
IIn RCV_TRANSACTIONS table quantity is correctly: 0.123456789012345

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