My Oracle Support Banner

Incorrect Exchange Rate Used For Doc. Base Amount Calculation on the PO When Change Order Is created (Doc ID 2211078.1)

Last updated on NOVEMBER 29, 2019

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.


Issue:- PO due date is used for obtaining the exchange rate for Doc. Base amount calculation instead of PO date when Change Order is created for PO


Steps to Reproduce the Issue:
1. Search for a Dispatched PO with PO Date and Due Date on different Month. PO Date is on earlier month.
PO Date = Jan – 12 – 2015
Due Date = Feb – 19 – 2015

2. Navigate to Setup Financials->Common Definitions->Market Rates-Market Rates.Check Market Rate/Exchange Rate for PO Date and Due Date.
January – 2016 Exchange Rate = 1.51580679
February – 2016 Exchange Rate = 1.63859849

3.Check Line Details to check if Base Amt is correct as per the January – 2016 Exchange Rate.
1.51580679 * 3000 = 4547.42037 - CORRECT

4. Raise a change order to change Ship To from US001 to US003

5. Save the page

6. Observe Base Amt in Line Details. The price is now multiplied by the Feb Exchange Rate which is based on the Due Date.
1.63859849 * 3000 – 4915.79547 -INCORRECT


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

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