1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Handling Financial Consolidation Data Inaccuracies
  4. Check Known Consolidation Issues

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.