Available Consolidation Settings

Before you use the Consolidation Settings module for the first time, you must run a migration configuration task to migrate the available user-created substitution variables to Consolidation Settings. See Migrating Substitution Variables to Consolidation Settings.

These consolidation settings are available for Financial Consolidation and Close.

Table 6-4 Consolidation/Translation Settings

Category	Label	Application Type Support	Default Value	Description
Consolidation Process	Yearly Consolidation	DSO only	Disabled	Optimize performance for multi-period consolidations This setting is applicable if the application meets the following conditions: You have two or more impacted periods and two or more hierarchy levels. The impacted entities are identical across periods. Equity Pickup is not enabled. This setting is migrated from the corresponding substitution variable: Enableyearlyconsol
Consolidation Process	Optimize Custom Dimension Consolidation	DSO only	Disabled	Improve the performance of consolidation calculations for Custom dimensions. This setting is migrated from the corresponding substitution variable: Parallelcustomdimdso
Translation Process	Optimize Custom Dimension Translation	DSO only	Disabled	Improve the performance of translation calculations for Custom dimensions. This setting is migrated from the corresponding substitution variable: Parallelcustomdimtranslation
YTD Calculations	YTD FX Calculation	Applicable only for multi-currency applications. DSO and non-DSO	Disabled	Calculate Foreign Exchange (FX) variances on a Year-to-Date (YTD) basis Enable this setting when the default Translation Method for Flow accounts is Year-to-Date. This setting is migrated from the corresponding substitution variable: YTDFXCalculation
YTD Calculations	YTD FX Revised	Applicable only for multi-currency applications. DSO and non-DSO	Disabled	YTD FX Calculation Logic for Historical Accounts If this setting is enabled, new calculated values will be generated for YTD FX Calculation Logic for Historical Accounts. This setting is migrated from the corresponding substitution variable: YTDFXRevised
Translation Process	Skip Translation Rules if Entity Currency Equals Parent Currency	DSO and non-DSO	Disabled	Skip Translation Rules if Entity Currency Equals Parent Currency
Consolidation Process	Optimize Consolidation Job	DSO and non-DSO	Disabled	Enable this setting if a network error is detected during the consolidation process. When consolidation is performed on a larger scope or when numerous jobs are done concurrently, a network error may arise due to limited computing resources. This setting ensures the best possible utilization of memory under these circumstances.
Ownership Data During Consolidation	Auto Recompute Job	DSO and non-DSO	Disabled	Enable to automatically recompute ownership data during consolidation. When enabled, this setting triggers the auto recompute process during consolidation. This setting is migrated from the corresponding substitution variable: Auto Recompute
Consolidation Process	Consolidation Job Analytics	DSO or non-DSO	Disabled	Enable this setting if you want to generate a Gen AI-based summary of time spent at various stages throughout the consolidation process.
Consolidation Process	Enable Simple Aggregation	Non-DSO only	Enabled	Optimizes the aggregation operations during the consolidation process This setting is migrated from the corresponding substitution variable: Enablesimpleaggregation
YTD Calculations	Optimize YTD	Non-DSO only	Enabled	Optimize the YTD Calculation performance. This setting is migrated from the corresponding substitution variable: Optimizeytdcalculation
Consolidation Process	Optimize Concurrency	Non-DSO only	Disabled	Enable this setting to take advantage of higher concurrency during consolidations. If this setting is enabled, the Opening Balance Carry Forward calculation is performed on all levels. This setting is migrated from the corresponding substitution variable: Optimizeconcurrency

Table 6-5 Data Load

Category	Label	Existing Variable in Use	Default Value	Description
Data Load Clearing Data	Enable Consolidation Member	DSO and non-DSO	Disabled	Allows clearing of Consolidation member data during Data Load. This setting is migrated from the corresponding substitution variable: Dataloadconsolmember
Data Load Prevention of Account Reversal	Roll-Forward account / CTA Reversal	DSO and non-DSO	Disabled	Prevents reversal of Roll Forward and CTA accounts for a Closing Balance Input (CBI) data load. By default, when a CBI data load is executed, the prior period Closing Balance of all accounts is reversed and the loaded data is entered as a Year-To-Date (YTD) value. When this setting is enabled, the system Roll-Forward and CTA accounts (which cannot be loaded) are not reversed. Roll Forward accounts FCCS_Retained Earnings FCCS_REC_OBFXCTA FCCS_OCI_OBFXCICTA CTA accounts: FCCS_CTA FCCS_CICTA Application-specific CTA account This setting is migrated from the corresponding substitution variable: Donotreverserfaccountsforcbiload
Data Load Closing Balance	YTD Reversal - Closing Balance Input	DSO and non-DSO	Disabled	If this setting is enabled, the Closing Balance YTD load is allowed. This setting is migrated from the corresponding substitution variable: NewLoadYTDClosingBalanceInput

Table 6-6 Other Settings

	Label	Existing Variable in Use	Default Value	Description
Security	Disable Seeded Security	DSO and non-DSO	Disabled	Disable the default seeding of security groups. This setting is migrated from the corresponding substitution variable: Disableseededsecurity
Number Format for Excel	Enable Excel Number Format	DSO and non-DSO	Disabled	Export report numeric data to Excel as numbers instead of cell text. This setting is migrated from the corresponding substitution variable: Enableexcelnumberformat
Journal Decimal Places	Journal Precision	DSO and non-DSO	10	Number of Decimal places to be used for Journals Debit/Credit. When this setting is enabled, Financial Consolidation and Close will use scaling during the validation process if a currency scaling value is specified for the journal.

Table 6-7 Legacy

Data Load and Clear Performance	Optimize Data Clear	DSO and non-DSO	Enabled	Improves the data load pre-process Replace mode performance