Optimizing the Performance of Configurable Consolidation Rules
Note:
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:
-
On the Home page, click Application and then click Configuration.
-
Click Create System Accounts.
-
From the Create System Accounts screen, click Launch.
-
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.