Revaluation Basis As "Primary Currency" In Reporting Ledger Calculation Is Incorrect
(Doc ID 2886360.1)
Last updated on JULY 08, 2024
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.22.04.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |