Optimizing the Performance of Configurable Consolidation Rules


This approach to resolving performance issues is not applicable to Dense Storage Option (DSO) applications.

For Dense Storage Option applications, you can use a manual approach to resolve performance issues. See "Manual Approach to Resolve Performance Issues" in Oracle Enterprise Performance Management Cloud Operations Guide.

When you run configurable consolidation rules, you can use an automated approach to optimize performance. This approach is implemented as a part of consolidation and involves these steps:

  • Executing the Create System Accounts configuration task

  • Setting the optimizeConfigConsol substitution variable

Executing the Create System Accounts Configuration Task

As a part of executing the Create System Accounts configuration task, Financial Consolidation and Close creates these temporary system Account members under FCCS_System Accounts.

  • FCCS_ConsolAccount1
  • FCCS_ConsolAccount2

These temporary accounts are used internally as a part of the consolidation process. The data storage type of these accounts should be set to Never Share. For FCCS_ConsolAccount1, the account type should be Asset while for FCCS_ConsolAccount2 the account type should be Revenue.

The configuration task also automatically executes the Refresh Database process.

This can be useful when you have many source members, as it can restrict the scope of calculations and increase performance.

To optimize performance for configurable consolidation rules:

  1. On the Home page, click Application and then click Configuration.

  2. Click Create System Accounts.

  3. From the Create System Accounts screen, click Launch.

  4. The task is launched as a job and can take a long time based on the amount of data. You can view the status in the Jobs console.

Setting the optimizeConfigConsol Substitution Variable

To enable the automated approach to resolving performance issues, create a substitution variable named optimizeConfigConsol and set the value to True. See Creating and Assigning Values to Substitution Variables.