Rounding Difference On Quantity Received, Due To iProcurement Requisition Distribution Not Truncating Quantity To 15 Decimal Spaces. (Doc ID 1111134.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle iProcurement - Version: 11.5.10.2 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.

Symptoms

On 11.5.10, when attempting to create requisition in iProcurement , the following error occurs.

Error:
In PO : quantity received does not equal quantity billed

Steps To Reproduce:
1. Create requisition in iProcurement with below quantity distributions for a line :

0.00809027038535235
0.117947626144347
0.409623163721524
0.363104109005748
0.00894187779433681
0.00457738982329146
0.08771556312540038

As we see the values is having more than 15 decimals.

The PO created for the above requisition shows the distributions which are rounded till 15 decimal spaces :
0.008090270385352
0.117947626144347
0.409623163721524
0.363104109005748
0.008941877794337
0.004577389823291
0.0877155631254

This is then creating the issue with PO distribution totaling to 0.999999999999 instead of 1

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