PRC:PO:Purchase Order Total Price Is Not Calculating Consistent On Purchase Oder Pages And Documents (Doc ID 2762220.1)

Last updated on AUGUST 12, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Purchase Order Total Price is not Calculating Consistent on Purchase Oder Pages and Documents

Purchase Order Total Price is not Calculating Consistent on Purchase Oder Pages and Documents when Unit Price goes beyond 2 Decimal Places due to Rounding

Manage Currencies > USD
Precision=2, Extended precision = 5

PO Total Amount: 3.01 USD
PO Status: Incomplete
PO Line1 Price: 1.004 USD
PO Line1 Ordered 1.00 USD
PO Line2 Price: 1.004 USD
PO Line2 Ordered 1.00 USD
PO Line3 Price: 1.004 USD
PO Line4 Ordered 1.00 USD
PO PDF: Total: 3.01 USD, PO Lines 1.00 USD each

Submit for approval

Approval Notification
PO Total Amount: 3.01 USD
PO Status: Pending Approval
PO Line1 Price: 1.004 USD
PO Line1 Ordered 1.00 USD
PO Line2 Price: 1.004 USD
PO Line2 Ordered 1.00 USD
PO Line3 Price: 1.004 USD
PO Line4 Ordered 1.00 USD
PO PDF: Total: 3.01 USD, PO Lines 1.00 USD each

PO approved

PO Total Amount: 3.00 USD (difference)
PO Status: Open
PO Line1 Price: 1.004 USD
PO Line1 Ordered 1.00 USD
PO Line2 Price: 1.004 USD
PO Line2 Ordered 1.00 USD
PO Line3 Price: 1.004 USD
PO Line4 Ordered 1.00 USDx
PO PDF: Total: 3.00 USD, PO Lines 1.00 USD each (Difference)

EXPECTED BEHAVIOR
-----------------------
As PO draft was 3.01 USD and the approval notification was for 3.01 USD the PO total amount once approved should remain at 3.01 USD so it's consistent, should not be changed to 3.00 USD as actual behaviour

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a new PO with 3 lines, each line qty=1 and price 1.004 USD
2. Observe Total amount of the PO is 3.01 USD
3. Observe Total amount PO PDF DRAFT is 3.01 USD
4. Submit PO for approval
5. Observe Total amount PO Approval notification is 3.01 USD
6. Approve PO
7. Go to Procurement > Manage Orders, search PO
8. Observe PO Total amount is changed to 3.00 USD

Changes

 None

Cause

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