1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Diagnosing Consolidation Failures and Performance Issues in Financial Consolidation and Close
  4. Address Functional Issues

Address Functional Issues

Functional issues, such as the following, are not addressed by the preceding steps:

  • The application displays Essbase Data Cache Full error and terminates consolidation.
  • The application displays The following value is not valid for the runtime prompt <ENTITY_NAME> error when users select an entity for consolidation.

Journals posted to FX members

The consolidation process clears the journals posted to FCCS_Mvmts_FX_Movement member. You should not manually enter or post data or journals to the FX members in the Movement dimension.

Resolving Essbase Data Cache Full Error

Generally, the Financial Consolidation and Close application displays the Essbase Data Cache Full error because a shared member appears ahead of the primary member in the metadata hierarchy.

Corrective Actions

  1. Use Oracle Smart View for Office or the Dimension Editor to view the hierarchy and locate the shared member that appears ahead of the primary member in the hierarchy.
    Switching members to resolve Essbase Cache Full error

  2. Move the primary member ahead of the shared member in the hierarchy.
  3. Refresh the database.
  4. Run the consolidation rule that failed.

Resolving the Unable to select an entity for consolidation Error

You cannot launch consolidations for an entity that cannot be calculated correctly. In the illustration, us_Ops cannot be selected because it does not have a check mark for POV selector.
Unselectable entity for consolidation

Additionally, typing in the name of an unselectable entity into the Consolidate screen displays the The following value is not valid for the rentime prompt: us_Ops error.
Error that is displayed if you type in the name of an unselectable entity

To resolve the Unable to select an entity for consolidation error:

  1. Sign in to Financial Consolidation and Close as a Service Administrator.
  2. On the Home page, click Application and then Valid Intersections.
  3. Disable the valid intersection rule for the entity that cannot be selected for consolidation.
    Turn off valid intersection rule for an entity

Understanding Consolidation Effects on Journals

Consolidation clears manually entered journal input, parent input, and parent currency data that journals post against the FCCS_Mvmts_FX_Movement member.

You cannot manually enter or post data or journals to the FX members in the Movement dimension. Because FCCS_Mvmts_FX_Movement members are calculated members, Financial Consolidation and Close clears manually entered data during the consolidation process.