Incorrect Calculation Of Total Order Cost When Order Exchange Rate Was Modified (Doc ID 2812091.1)

Last updated on OCTOBER 05, 2021

Applies to:

Symptoms

While modifying the Exchange rate by changing the local currency form foreign currency in purchase order(PO)

The Total Order Cost of Import Order is using the Default currency Exchange Rate instead of the modified Order Exchange Rate value.

Steps to Recreate:

1.  Create an Import PO.
2.  Change the PO currency to a foreign currency.
3.  Change the PO exchange rate so that it differs from the default rate.
4.  Finish setting up the PO and add Items/Location.
5.  Approve PO.
6.  Go back to the Approved PO and hover mouse at the Total Order Cost .
7.  System is displaying Total Order Cost based on system default exchange rate in materialized view (MV) and not based on PO exchange rate.
8. Expected that the Total Order Cost of Import Order should be recalculated of the modified Order Exchange Rate value.

Cause

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