Check Known Consolidation Issues
This section lists solutions for common consolidation issues such as retained earnings not rolling over for a period, Cumulative Translation Adjustment (CTA) not being calculated, opening balance and foreign exchange calculation inaccuracies, and custom member formulas being defined under Total Balance Sheet hierarchy.
Before contacting Oracle for help, verify that these issues are not causing you to see unexpected consolidated numbers.
Issue 1: Retained Earnings not Rolling Over for Period 1
FCCS_REC_OBFXCTA
is a system member that stores the Opening Balance and FX calculation for Net Income/Owners Income
members. The Net Income/Owners Income
parent member is referred in Opening Balance and FX calculations. The Net Income/Owners Income
hierarchy must always be within the Retained Earnings
hierarchy.
Ensure that the Net Income/Owners Income
hierarchy is within the Retained Earnings
hierarchy
Similar Issues: Other seeded system members that should not be moved from their original position include the following:
- Account:
- FCCS_Total Balance Sheet XXX (Balance sheet top member), FCCS_Balance (valid only if balance calculation is valid)
- FCCS_Total Assets, FCCS_Total Liabilities, FCCS_Total Equity (for balance calculation only)
- FCCS_Retained Earnings, FCCS_Retained Earnings Prior, FCCS_Net Income, FCCS_Owners Income, FCCS_REC OBFXCTA
- FCCS_CTA (valid only when Balance Sheet under CTA is enabled)
- FCCS_CICTA, FCCS_Total Other Comprehensive Income, FCCS_OR OBFXCICTA
- Movement:
- FCCS_ClosingBalance, FCCS_Mvmts_Subtotal, and members under FCCS_Mvmts_FX_Total
- FCCS_Total OpeningBalance, FCCS_OpeningBalance
- FCCS_Mvmts_Subtotal
- Members under FCCS_Mvmts_FX_Total
Issue 2: CTA is not Calculated (Multicurrency Applications)
CTA is calculated as sum of foreign exchange to CTA values for historical accounts under balance Sheet top member (FCCS_Total Balance Sheet - Traditional Approach, FCCS_Total Balance Sheet Net Asset Approach). Historical accounts outside top balance sheet members are ignored for CTA calculation.
-
Check if historical accounts (accounts with Exchange Rate Type property set to Historical, Historical Rate Override, Historical Amount Override) have FX to CTA movement member data in
FCCS_Mvmts_FX_to_CTA
. -
If data is not present in
FCCS_Mvmts_FX_to_CTA
for historical accounts, check if historical accounts are outside balance sheet top member hierarchy. -
Verify that all the historical accounts are within the balance sheet top member hierarchy.
Issue 3: OB and FX for Revenue and Expense Accounts Outside FCCS_Net Income, FCCS_Owners Income, and FCCS_Total Other Comprehensive Income Hierarchy
Revenue and expense accounts outside FCCS_Net Income, FCCS_Owners Income, and FCCS_Total Other Comprehensive Income hierarchy are not considered for opening Balance or FX calculations and leads to out of balance issues. This is a known issue; which Oracle is working on fixing.
Workaround: Move revenue and expense accounts under FCCS_Net Income, FCCS_Owners Income, or FCCS_Total Other Comprehensive Income hierarchy.
Issue 4: OB and FX for Equity, Liability, and Asset Accounts Under FCCS_Net Income or FCCS_Owners Income
OB and FX should not be calculated for equity, liability, and asset accounts under FCCS_Net Income or FCCS_Owners Income. However, if OB and FX for equity, liability, and asset accounts are in FCCS_Net Income or FCCS_Owners Income hierarchy, OB and FX are currently calculated for these accounts, leading to out of balance issues. This is a known issue, which Oracle is working on fixing.
Workaround: Move equity, liability, and asset accounts outside the FCCS_Net Income or FCCS_Owners Income hierarchy.
Issue 5: OB and FX for Accounts Outside FCCS_Balance Sheet Hierarchy
Although Financial Consolidation and Close should calculate OB and FX also for all financial accounts outside FCCS_Balance sheet, it does so only for accounts under FCCS_Balance Sheet, which results in customers not getting the expected results. This is a known issue, which Oracle is working on fixing.
Workaround: Move all the financial accounts under the FCCS_Balance Sheet hierarchy.
Issue 6: Member Formula Defined Under Total Balance Sheet Hierarchy for Custom Accounts
For custom accounts, member formulas defined under Total Balance Sheet hierarchy causes unexpected results or calculations.
Corrective Actions:- Remove formulas defined under Total Balance Sheet hierarchy
- Refresh the database
- Run consolidation or translation for the impacted period or year
- Verify that the issue is resolved
Issue 7: Shared Members Created in Alternate Hierarchy in Period Dimension
Shared members created in alternate hierarchy in Period dimension cause unexpected results or calculations.
Corrective Actions:- Remove Shared members created in alternate hierarchy in Period dimension
- Refresh the database
- Run consolidation or translation for the impacted period or year
- Verify that the issue is resolved
Issue 8: Parents of Shared Members Created in Alternate Hierarchy of Period Dimension Cannot be Removed
Parents of shared members created in alternate hierarchy of Period dimension cannot be removed. This may cause performance issues during spreadsheet retrievals when referencing Dynamic Calc To Date View members.
Corrective Actions:- Avoid creating alternate hierarchy in Period dimension
- If shared members are present in alternate hierarchy of Period dimension, recreate the application while avoiding alternate hierarchy in Period dimension. This is the only solution to resolve retrieval performance issues in such a situation.