Incorrect decimal quantity when the distribution lines are not expanded
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 10.7 and later
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
Find that when receiving a Purchase Order and NOT using the '+' icon to expand the distribution lines, the quantity received of the last distribution line is automatically rounded off to a decimal quantity
of 0.857999999999999, while through the PO Distribution form a quantity of 0.858 was entered.
When using the '+' icon to expand the distribution lines the quantity received of the last distribution line is NOT rounded off but is 0.858.
Expect the quantity received against the last distribution line to be 0.858 also when not using the '+'icon.
The issue can be reproduced at will with the following steps:
a. Purchase Orders > Purchase Order
Create a PO line with one shipment line where the quantity is 6
Enter 7 separate distribution lines each with quantity 0.857 and one with qty 0.858
Receipt routing = Direct
b. Receiving > Receipts: Receive the Purchase Order
When entering the receipt details do NOT expand the distribution lines and
receive a quantity of 6 in total.
c. Receiving > Receiving Transactions: Deliver the Purchase Order
Now expand the distribution lines and you will notice that the quantity of the
last distribution is rounded off to 0,856999999999999 while this should be
The issue has the following business impact:
Due to this issue there always remains a small fractional quantity to be received and the Purchase Order will still be included on the 'Receiving Value Report by Destination Account'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms