Quantity Data With Decimals in Requisition Summary Shows Differently From the SQL Result
(Doc ID 2125194.1)
Last updated on AUGUST 06, 2020
Applies to:
Oracle Purchasing - Version 12.1.3 and laterInformation 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 |