R12/XTR: Revaluation Completes With Warning: No Rate For Currency G/L (Doc ID 791308.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version 12.0.0 to 12.2.5 [Release 12 to 12.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When you run REVALUATION this completes with warning ERROR for some deals:

 No Rate for Currency General Ledger (G/L)

As per Treasury UG: Foreign exchange cross rates are automatically calculated for each currency combination using the spot rates you enter for currencies against the USD. However, When customer define cross rates in GL: Daily Rate table then the revaluation works correct.

2. But if you simply define the Rates in Treasury against USD then it fails to calculate the cross rate. Even when:
CHF TO USD
AUD TO USD
Also when you DEFINE the Cross Rate Between: AUD CHF in Treasury Even then It is failing to get cross rates during Revaluation.

3. Your questions are:
1). How and where Rates to be defined?
2). Why Cross rates are not calculated automatically as per the UG.?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms