My Oracle Support Banner

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

Last updated on JUNE 10, 2019

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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