Configurable Calculation Rules
You manage configurable calculation rules from the Consolidation Process page.
MultiCurrency Applications
If you have a multicurrency application, the Consolidation Process page displays three tabs: Local Currency, Translated, and Consolidated.
The tabs depict the consolidation flow that Financial Consolidation and Close follows. It first performs calculations for baselevel members in their local currency, then performs the translation to parent currency, and finally performs the consolidation.
Single Currency Applications
If you have a single currency application, the Consolidation Process page displays two tabs: Local Currency and Consolidated.
Calculation Rows
Each of the tabs on the Consolidation Process page displays multiple rows that depict in order, the flow of calculations that are performed. Each row is marked by one of these icons:
 — System. Represents that this calculation is done by Financial Consolidation and Close.
 — Insertion point for userdefined rule. Represents the point in the process where you can insert your calculations from Calculation Manager.
When you select any of the rules in the list, the system displays a Properties panel on the right with information such as the rule name, the consolidation members for which the rule would be processed, and any override specifications, if applicable.
When you click on a row where you can insert a userdefined calculation, Calculation Manager opens in a separate tab in the browser.
Example:

From the Local Currency tab, click on either After Opening Balance Carry Forward or Final Calculations.
The system opens Calculation Manager.

Expand the "Planning" folder on the left side until you see the FCCS Consol seeded rules in Calculation Manager, for example:

FCCS_10_After Opening Balance Carry Forward_LocalCurrency

FCCS_20_Final Calculations_LocalCurrency


The Calculation Manager rules correspond to the Configurable Calculation rows. For example:

The Calculation Manager rule: FCCS_10_After Opening Balance Carry Forward_LocalCurrency
corresponds to the: After Opening Balance Carry Forward row, where you can add your own calculations. These are calculations to be performed after the Opening Balance Carry Forward calculations, but before balancing the Balance Sheet.

The Calculation Manager rule: FCCS_20_Final Calculations_LocalCurrency
corresponds to the Final Calculations row, where you can add your own additional calculations to be performed after the Balance Sheet is balanced.

The following table lists the Financial Consolidation and Close rows for each tab and the corresponding Calculation Manager rules.
Summary of Configurable Calculation Rules
Table 193 MultiCurrency Calculations
FCCS Tab  FCCS Row  Rule in Calculation Manager 

Local Currency  After Balance Carry Forward  FCCS_10_After Opening Balance Carry Forward 
Local Currency  Final Calculations  FCCS_20_Final_Calculations 
Local Currency insertion rules are restricted to: Entity Currency / Entity Input / Entity Elimination Adj / Entity Consolidation. In addition to Entity Input for the Consolidation dimension, you can also specify FCCS_Amount Override or FCCS_Rate Override as a valid Consolidation member. Note: If you want to use FCCS_Amount Override or FCCS_Rate Override, you must first set the following substitution variable for the Consol cube to enable it. CONFCALC_ENABLE_RATE_AMOUNT_OVERRIDE =
True See Creating and Assigning Values to Substitution Variables. 

Translated  Before Foreign Exchange (FX) Calculations  FCCS_25_Before FX_Calcs 
Translated  After Opening Balance Carry Forward  FCCS_30_After Opening Balance Carry Forward 
Translated  Final Calculations  FCCS_40_Final_Calculations 
Translated insertion rules are restricted to: Parent Currency / Entity Input / Entity Elimination Adj / Entity Consolidation 

Consolidated  After Opening Balance Carry Forward  FCCS_50_After Opening Balance Carry Forward 
Consolidated  Final Calculations  FCCS_60_Final_Calculations 
Consolidated insertion rules are restricted to: Parent Currency / Elimination. 
Table 194 Single Currency Calculations
FCCS Tab  FCCS Row  Rule in Calculation Manager 

Local Currency  After Balance Carry Forward  FCCS_110_After Opening Balance Carry Forward 
Local Currency  Final Calculations  FCCS_120_Final_Calculations 
Consolidated  After Balance Carry Forward  FCCS_130_After Opening Balance Carry Forward 
Consolidated  Final Calculations  FCCS_140_Final_Calculations 
Disabling CALC DIM Logic
When you create configurable calculation scripts for an insertion point, Financial Consolidation and Close automatically generates data at parent levels so that these parent members are available in the next insertion point. The system adds CALC DIM logic to roll up the data that you populate. Processing this added CALC DIM logic is a timeconsuming process depending upon the complexity of your hierarchy. If you do not need to refer to recalculated parent members in later insertion points, you may speed up the overall consolidation process by disabling the CALC DIM logic that the system adds for insertion points.
If you want the system to not generate CALC DIM logic for Multicurrency applications, you should create the following Substitution Variables and set the values to True:
CONFCALC_FCCS10_DISABLECALCDIM
CONFCALC_FCCS20_DISABLECALCDIM
CONFCALC_FCCS25_DISABLECALCDIM
CONFCALC_FCCS30_DISABLECALCDIM
CONFCALC_FCCS40_DISABLECALCDIM
CONFCALC_FCCS50_DISABLECALCDIM
CONFCALC_FCCS60_DISABLECALCDIM
CONFCALC_FCCS70_DISABLECALCDIM
For example, if you have written custom logic in the FCCS_10 and FCCS_20 configurable
calculation rules. If you want to disable CALC DIM logic for FCCS_20, but not for
FCCS_10, you should create a Substitution Variable named
CONFCALC_FCCS20_DISABLECALCDIM
and set the value to True.
If you want the system to not generate CALC DIM logic for a singlecurrency application, you should create the following Substitution Variables and set the values to True:
CONFCALC_FCCS110_DISABLECALCDIM
CONFCALC_FCCS120_DISABLECALCDIM
CONFCALC_FCCS130_DISABLECALCDIM
CONFCALC_FCCS140_DISABLECALCDIM
CONFCALC_FCCS150_DISABLECALCDIM
Be aware that since disabling CALC DIM logic affects the consolidation script generation, you should carefully check your consolidation results.