Quantity Data With Decimals in Requisition Summary Shows Differently From the SQL Result (Doc ID 2125194.1)

Last updated on JUNE 25, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Requisitions are created through Import Purchase Requisition Concurrent.

The following phenomenon when doing a search for several Requistions in Requisition Summary form.

For example:

PO Responsibility

1. Requisitions->Requisition Summary

2. Enter the Requisition Number, then click "Find" button

3. Click "Lines" button

4. Quantity of the Requisition is displaying as:74.399999999999991.

 

But when run the following query in Database end:

SELECT * FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID = '&REQUISITION_HEADER_ID';


The output result is 74.4.

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