Revaluation Basis As "Primary Currency" In Reporting Ledger Calculation Is Incorrect (Doc ID 2886360.1)

Last updated on JULY 08, 2024

Applies to:

Symptoms

On : 11.13.22.04.0 version, Period Close Setup & Processing

ACTUAL BEHAVIOR
---------------
Functionality of Revaluation Basis as "Primary Currency" in Reporting Ledger is not functioning as described as per note Doc ID 2673020.1. Currently after running revaluation the Period Activity for the RC ledger does not show the expected value making the end balance incorrect. The account used is a CTA account.

EXPECTED BEHAVIOR
-----------------------
If the Revaluation Basis as "Primary Currency" the expected calculation is: (Original Primary Ledger accounted amounts * New conversion rates - Original Reporting Ledger accounted amount)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have a RC setup as below
Primary Ledger Name: ABC SGD PL
Reporting Ledger Name: ABC SGD RL(USD)
Conversion Level: Subledger
Currency ZZ-USD
Revaluation Basis: Primary Ledger Currency
Enable Journal Approval
Default Conversion Rate: Corporate
Retain Transaction Rate Type: Yes
Missing Conversion Rate: Report error

2. Have in the PL the balances below

Members:
ABC SGD PL
SGD
May-22
Total
Actual

00119-000-0000-000-11190-00000-0000-0000
Beginning Balance  28,602,856.60  End Balance 28,602,856.60   No Period Activity


3. Run Revaluation

4. The RC shows the balances below
 Members:
ABC SGD RL(USD)
ZZ-USD
May-22
Total
Actual
00119-000-0000-000-11190-00000-0000-0000

Beginning Balance 20,725,737.77
Period Activity 741,032.93
End Balance 21,466.770.70

Expected Calculation End Balance RC 21,452,142.45 =  (28,602,856.60 * 0.75 (new rate))

Current Calculation Ending RC Balance : 21,466.770.70

Difference: -14,628.28

Cause

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