My Oracle Support Banner

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

Last updated on AUGUST 15, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.