Search Results gcs_dimension_templates




Overview
Explore in AI Chat

Overview

The GCS_DIMENSION_TEMPLATES table is a core data object within the Oracle E-Business Suite Financial Consolidation Hub (GCS) module. It serves as the repository for defining dimension templates, which are critical configuration components for managing the automated posting of retained earnings and suspense account balances during the consolidation process. These templates ensure that financial data is correctly reclassified and aggregated according to the consolidation rules and hierarchies defined for an enterprise, thereby maintaining the integrity of the consolidated financial statements.

Key Information Stored

The table stores the master definition for each dimension template, linking it to a specific consolidation hierarchy. The primary columns, which also constitute the table's primary key, are HIERARCHY_ID and TEMPLATE_CODE. The HIERARCHY_ID is a foreign key that associates the template with a specific consolidation hierarchy defined in the GCS_HIERARCHIES_B table. The TEMPLATE_CODE is a unique identifier for the template within that hierarchy. While the provided metadata does not list all columns, typical data in such a table would include descriptive fields (like TEMPLATE_NAME), configuration flags to control template behavior (e.g., for retained earnings or suspense account handling), and who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

The primary use case is the setup and maintenance of automated balance transfers during period-end consolidation. Administrators use these templates to define how balances from income statement accounts are closed into retained earnings, or how out-of-balance transactions are posted to a suspense account. A common reporting query would join this table to the hierarchy table to list all configured templates for a given consolidation entity. For example:

  • SELECT ht.HIERARCHY_NAME, dt.TEMPLATE_CODE FROM GCS_DIMENSION_TEMPLATES dt, GCS_HIERARCHIES_B ht WHERE dt.HIERARCHY_ID = ht.HIERARCHY_ID;

Another critical use case is during the consolidation engine's runtime, where the system references the rules defined via these templates to generate the appropriate accounting entries, ensuring the trial balance is correctly restated for the consolidated view.

Related Objects

The table has a direct and essential relationship with the GCS_HIERARCHIES_B table, which stores the master definition of consolidation hierarchies. The documented foreign key constraint enforces that every TEMPLATE_CODE in GCS_DIMENSION_TEMPLATES must be associated with a valid HIERARCHY_ID in GCS_HIERARCHIES_B. This relationship is fundamental, as a dimension template is meaningless without being tied to a specific consolidation hierarchy. While not listed in the provided metadata, it is highly probable that this table is referenced by child tables (such as those storing template lines or rules) which define the specific account mappings and conditions for the retained earnings and suspense postings configured in this master table.