My Oracle Support Banner

Reporting Currency Ledger's Revaluation Journal is Created With CTA Account and Not Accounts Being Revalued (Doc ID 2807294.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

Oracle General Ledger - Version and later
Information in this document applies to any platform.


The primary ledger has a Reporting Currency (RC) Ledger assigned to it using Subledger Conversion.
The RC Ledger has a journal conversion rule to replicate revaluation journals from the primary ledger to the RC Ledger.

When revaluation is run in the primary ledger a revaluation journal is created correctly and includes all accounts that need to be revalued
and offset to the defined gain/loss account of the revaluation rule definition.

When the revaluation journal is posted, it correctly posts the primary ledger journal and creates the RC ledger revaluation journal as expected based on the
replication rule that is defined.

The expectation is that the two journals would contain the same accounts being revalued, what is generated in the RC Ledger is not this but
a two line journal. One journal line is the Accounting Setup Manager defined Cumulative Translation Adjustment Account (CTA) which is offset by the proper Gain/Loss account
as seen in the primary journal ledger.

Steps to Replicate the issue:
1) In the primary ledger define a revaluation rule. 
   a. Using a General Ledger responsibility, Navigate to Currency -> Revaluation.
   b. Define a Revaluation rule that will be used to revalue the required range of accounts. Save.
2) Enter daily rates as needed for the revaluation program.
   Using General Ledger responsibility, Navigate to Setup -> Currencies -> Rates -> Daily
3) After foreign currency journals are entered that need to be revalued, run the defined revaluation as needed.
   a. Using General Ledger responsibility, Navigate to Reports -> Request -> Standard
   b. Query program - Program - Revalue Balances, enter the needed parameters and submit. This can also be done via the Revaluation definition form (Navigate to Currency -> Revaluation)
4) Once the Revaluation program is complete, view the created journal entry.
   Using a General Ledger responsibility, Navigate to Journals -> Enter, query the created journal.

   Note that the Revalued Accounts are the accounts with activity that are defined in the Revaluation rule, the offset to this is the Gain/Loss account that is defined in the Revaluation Rule.

5) Post this journal using the Post button on the journal form.
6) Once posting is completed, the RC ledger revaluation journal is created (this is done by the posting program).
7) Review the RC ledger revaluation journal that is created:
    Using a General Ledger responsibility, Navigate to Journals -> Enter, query the created journal.

Note that the journal created is not using the same accounts as the journal created in the primary ledger. This journal has one account found to be the defined CTA account with offset to the Gain/Loss account(s)
of the Revaluation rule definition.


 New Reporting Currency ledger, doing this for the first time.


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.