My Oracle Support Banner

Estimated Order Expenses In Non-Primary Currency Not Updated When Exchange Rate Changed (Doc ID 2920273.1)

Last updated on JANUARY 11, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


On a PO that has expenses that are in a non-primary currency (e.g. Ocean Freight 40USD/each in a GBP environment), in the ordloc_exp table, the est_exp_value for the expense cost component holds the estimated expense value in the expense currency and the est_exp_value for the total expense component 'TEXP' holds the estimated expense value converted to GBP using the exchange rate applicable at the time of order creation.
If a user subsequently changes the exchange rate for the expense to reflect real-world exchange rate changes, the expected result is that the TEXP estimated expense value should be updated automatically to reflect the different exchange rate.

The actual result is that the TEXP estimated expense value is not being updated. This is the case if the change is made on screen, whether or not the user clicks the 'Recalculate' icon. It is also the case if expense exchange rate changes are uploaded using PO induction. It is also the case regardless of whether the change is made when the PO is initially created or if it is made after the order has been approved and placed back into worksheet status.

Steps to replicate the issue:

1. Create a PO for an item.
2. Add an expense to the order with a non-primary currency.
3. Note the default expense exchange rate and estimated expense values for the cost component and for the TEXP component.
4. On the Order Expenses screen, edit the exchange rate for the expense.
5. Note that the TEXP estimated value does not change as a result of the exchange rate change, even if the Recalculate button is clicked.

The impact is that the values displayed on the Order Expenses, Order Details and Order Header screens are incorrect for non-primary currency expenses whose exchange rate has changed.


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.