Search Results gcs_hierarchies_tl




Overview
Explore in AI Chat

Overview

The GCS_HIERARCHIES_TL table is a core data object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the Financial Consolidation Hub (GCS) module. It functions as a translation table, storing the user-facing names and descriptions for consolidation hierarchy headers in multiple languages. This table is essential for supporting the global deployment of the consolidation application, enabling multinational organizations to view and manage their financial consolidation structures in their local languages. Its role is to provide the translatable attributes that correspond to the base technical and structural data stored in its parent table, GCS_HIERARCHIES_B.

Key Information Stored

The table's primary purpose is to hold language-specific textual data. Its structure is defined by a composite primary key consisting of HIERARCHY_ID and LANGUAGE. The HIERARCHY_ID column links each row to a specific consolidation hierarchy defined in GCS_HIERARCHIES_B. The LANGUAGE column identifies the language code (e.g., 'US', 'FR', 'DE') for the translated text, with valid values constrained by the FND_LANGUAGES table. A critical column is SOURCE_LANG, which records the original language in which the data was entered, facilitating efficient translation synchronization. The core content columns typically include HIERARCHY_NAME and DESCRIPTION, which store the translated display name and explanatory text for the hierarchy, respectively. Additional standard Translation Table columns like CREATED_BY and LAST_UPDATE_DATE are also present for auditing.

Common Use Cases and Queries

The primary use case is retrieving a hierarchy's name in a user's session language for UI display, reports, and data entry screens. A common SQL pattern joins this table with its base table and filters by the desired language. For example, to list all active hierarchies with their English names:

  • SELECT b.HIERARCHY_CODE, tl.HIERARCHY_NAME, tl.DESCRIPTION FROM GCS_HIERARCHIES_B b, GCS_HIERARCHIES_TL tl WHERE b.HIERARCHY_ID = tl.HIERARCHY_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical scenario is during the implementation of new languages, where translation scripts populate this table with translated values for existing hierarchies, using SOURCE_LANG to track the origin. Data migration and hierarchy reporting also frequently query this table to present user-friendly information.

Related Objects

GCS_HIERARCHIES_TL has defined foreign key relationships with several key application objects, as documented in the ETRM metadata:

  • GCS_HIERARCHIES_B: This is the primary relationship. The HIERARCHY_ID column in GCS_HIERARCHIES_TL references the HIERARCHY_ID in GCS_HIERARCHIES_B. Every translation record must correspond to a valid base hierarchy record.
  • FND_LANGUAGES (via LANGUAGE column): The LANGUAGE column in GCS_HIERARCHIES_TL references the LANGUAGE_CODE in FND_LANGUAGES. This ensures that only installed and active application languages are used for translations.
  • FND_LANGUAGES (via SOURCE_LANG column): Similarly, the SOURCE_LANG column also references FND_LANGUAGES.LANGUAGE_CODE, validating the code for the original source language of the data.

This table is typically accessed indirectly through consolidation application screens and public APIs rather than directly in custom code, ensuring integrity with the translation architecture.