Consolidation and Translation Rules

Oracle Tax Reporting Cloud provides pre-built calculation scripts to handle consolidation and translation. In addition, the system provides pre-built scripts and member formulas for some of the standard calculation processes. For example, these rules are provided by default:

Table 17-1 Consolidation and Translation Rules

Rule Description

Consolidate

Executes Financial Consolidation for a given Scenario, Year, Period and Entity. Intelligently performs consolidation based on Entity's consolidation status.

Consolidate_CbCR

Executes Financial Consolidation for a given Scenario, Year, Period and Entity. Intelligently performs consolidation based on Entity's consolidation status.

ForceConsolidate

Executes the Consolidation by ignoring the internal processing flags. This operation is targeted towards Administration user to recover from a bad state.

Translate

Translates the consolidated data for a given Scenario, Year, Period, Entity and its descendants to the selected Reporting currency. If the entity is not consolidated, it is first consolidated as per the status, and then translated to the reporting currency.

Translate_CbCR

Translates the consolidated data for a given Scenario, Year, Period, Entity and its descendants to the selected Reporting currency. If the entity is not consolidated, it is first consolidated as per the status, and then translated to the reporting currency.

ForceTranslate

Executes the Translation by ignoring the internal processing flags. This operation is targeted towards the Administration user to recover the system from a bad state.

ForceTranslate_CbCR

Executes the Translation by ignoring the internal processing flags. This operation is targeted towards the Administration user to recover the system from a bad state.

DataLoad_PreProcess_Consol

Rule executed as part of pre processing operation for Data Load. This rule is not for standalone execution.

DataLoad_PostProcess_Consol

Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.

MetadataLoad_PostProcess_Consol

Rule executed as part of post processing operation for any metadata changes. This rule is not for standalone execution.

TrcsFormStatusProcessor

Rule executed as part of post processing operation for Data Form save. This rule is not for standalone execution.

RefreshDataBase_PostProcess_Consol

Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.

RefreshDataBase_DelegatePostProcess_Consol

This rule delegates database post processing call to Task Manager and Supplemental Data Manager modules to sync the metadata.

CopyTaxAutomationRule

This rule is used in Rollover process to copy the Tax Automation rule mapping. It copies mapping to target period from prior period.

ImpactStatusEntitiesWithData

This rule is used internally by system to update the data status of entities based on mapping defined by user in Tax Automation form. This rule is not for standalone execution.

CopyTaxRateRule

This rule is used in Rollover process to copy the Tax Rate. It copies data to target period from prior period.

Form_PreProcess_Consol

Rule executed as part of pre processing operation for Data Form save. This rule is not for standalone execution.

ComputeRates

Computes Average and Ending rates for a given Scenario, Period and Year based on direct rates entered in the system against given From and To currencies. Performs triangulation based on Application currency, in case direct rates are not entered.

CopyFXRatesRule

This rule is used in Rollover process to copy the FX Rate data. It copies data to target period from prior period.

RefreshDataBase_PostProcess_Rates

Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.

DataLoad_PostProcess_Rates

Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.

RefreshSDMCurrencyRates

Rule executed as part of post processing operation for Refresh Database, Data Load, Form Save. This rule is not for standalone execution.

DataLoad_PostProcess_CbCR

Rule executed as part of post processing operation for Data Load. This rule is not for standalone execution.

ImpactStatusEntitiesWithData_CbCR

This rule is used internally by system to update the data status of entities based on mapping defined by user in Tax Automation form. This rule is not for standalone execution.

MetadataLoad_PostProcess_CbCR

Rule executed as part of post processing operation for any metadata changes. This rule is not for standalone execution.

RefreshDataBase_DelegatePostProcess

This rule delegates database post processing call to Task Manager and Supplemental Data Manager modules to sync the metadata.

RefreshDataBase_PostProcess_CbCR

Rule executed as part of post processing operation for Refresh Database. This rule is not for standalone execution.

TrcsFormStatusProcessor_CbCR

Rule executed as part of post processing operation for Data Form save. This rule is not for standalone execution.