Automated Approach to Resolve Performance Issues

Note:

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

This approach to resolving performance issues is implemented as a part of consolidation and involves these steps:

• Executing the Create System Accounts configuration task
• Setting 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 accounts under FCCS_System Accounts.

• FCCS_ConsolAccount1
• FCCS_ConsolAccount2

These temporary accounts are used internally as a part of consolidation. 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.

Financial Consolidation and Close handles six account types that fall into two buckets:

• Bucket 1: Asset, Expense
• Bucket 2: Revenue, Liability, Equity, Saved Assumption

Data values must be reversed if source and target selections belong to different buckets. For instance, if the source selection of a configuration rule has multiple accounts from Bucket 1 and Bucket 2, you must check the account type of target selection and use either FCCS_ConsolAccount1 or FCCS_ConsolAccount2 as the source temporary account.

Setting optimizeConfigConsol Substitution Variable

Set the value of the substitution variable optimizeConfigConsol to true to enable the automated approach to resolving performance issues.