Results for “threshold_currency”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GCS_HIERARCHIES_B is the base (non-translated) header table that stores hierarchy definitions for Oracle Financial Consolidation Hub (FCH), a component of the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. A "hierarchy" in FCH represents the top-level consolidation structure: it binds together a top entity, a consolidation calendar, a dimension group, and balancing or reporting rules that determine how consolidation, translation, and intercompany elimination processes behave for a given group of legal entities. Each row in this table corresponds to one active or historical hierarchy definition, identified by the surrogate primary key HIERARCHY_ID and constrained by the unique index GCS_HIERARCHIES_B_U1.

Because the table carries descriptive control attributes rather than transactional detail, and because it sits at the center of a large fan-out of dependent tables, the Data Vault classification heuristic in the metadata labels it a hub-leaning object. In a Data Vault model, this would be modeled as the hub representing the Hierarchy business concept, with its descriptive columns and audit attributes supplied by a companion satellite, and the numerous child tables treated as links or satellites that reference the hub key.

Key Information Stored

The table holds 24 documented columns. The most significant of these are:

• HIERARCHY_ID — The surrogate primary key (GCS_HIERARCHIES_B_PK) and sole business-key candidate via the unique index GCS_HIERARCHIES_B_U1.
• TOP_ENTITY_ID — Identifies the top-level consolidation entity from which the hierarchy is organized.
• START_DATE and CALENDAR_ID — Define when the hierarchy becomes effective and which consolidation calendar governs its periods.
• DIMENSION_GROUP_ID — Associates the hierarchy with the dimension group used to build the consolidation dimension structure.
• FEM_LEDGER_ID — Reference to the associated Financial Management ledger.
• ENABLED_FLAG — Controls whether the hierarchy is active for processing.
• IE_BY_ORG_CODE and BALANCE_BY_ORG_FLAG — Govern intercompany-elimination-by-organization and balance-by-organization behavior.
• THRESHOLD_AMOUNT and THRESHOLD_CURRENCY — Set materiality thresholds; THRESHOLD_CURRENCY references FND_CURRENCIES.
• LOB_REPORTING_ENABLED_FLAG, LOB_HIERARCHY_OBJ_ID, and LOB_DIM_COLUMN_NAME — Support line-of-business reporting dimensions.
• SECURITY_ENABLED_FLAG, CERTIFICATION_FLAG, and HIERARCHY_GRP_FLAG — Govern security enforcement, certification/sign-off, and hierarchy grouping behavior.

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) are also present. Translated names and descriptions reside in GCS_HIERARCHIES_TL.

Common Use Cases and Queries

Typical usage includes resolving a hierarchy definition before submitting consolidation or translation runs, reporting on enabled hierarchies and their effective dates, and joining header attributes to child detail. A representative query lists active hierarchies with their top entity and calendar:

• SELECT h.hierarchy_id, h.top_entity_id, h.calendar_id, h.start_date
• FROM gcs_hierarchies_b h
• WHERE h.enabled_flag = 'Y'
• AND SYSDATE >= h.start_date;

To obtain translated names, join to GCS_HIERARCHIES_TL on HIERARCHY_ID. To audit threshold configuration, join THRESHOLD_CURRENCY to FND_CURRENCIES. To trace consolidation output, join downstream tables such as GCS_ENTRY_HEADERS, GCS_TRANSLATION_STATUSES, and GCS_CONS_RELATIONSHIPS on HIERARCHY_ID.

Related Objects

GCS_HIERARCHIES_B is referenced by a substantial set of dependent tables through the HIERARCHY_ID foreign key:

• GCS_HIERARCHIES_TL — Translated name and description details.
• GCS_CONS_RELATIONSHIPS — Consolidation relationships among entities in the hierarchy.
• GCS_DIMENSION_TEMPLATES — Dimension templates applied to the hierarchy.
• GCS_ENTITY_CONS_ATTRS — Entity-level consolidation attributes.
• GCS_ENTRY_HEADERS — Consolidation journal entry headers.
• GCS_HISTORICAL_RATES — Historical translation rate assignments.
• GCS_INTERCO_ELM_TRX — Intercompany elimination transactions.
• GCS_ROLE_HIER_RELNS — Role-to-hierarchy security relationships.
• GCS_TRANSLATION_STATUSES and GCS_TRANSLATION_TRACK_H — Translation run status and tracking.
• GCS_DATASET_CODES — Dataset code assignments per hierarchy.

The single outbound foreign key, THRESHOLD_CURRENCY, references FND_CURRENCIES. Together these relationships establish GCS_HIERARCHIES_B as the central header object of the Financial Consolidation Hub data model.