Results for “gcs_elim_rules_tl”

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

Overview

GCS_ELIM_RULES_TL is the translation (language) table for GCS_ELIM_RULES_B, the base table that stores elimination rule definitions used by the Oracle Financial Consolidation Hub (GCS) module. In Oracle EBS 12.1.1 and 12.2.2, GCS provided consolidation, translation, and elimination processing for multi-entity ledgers; elimination rules define how intercompany and intra-entity balances are identified and removed during consolidation. Because these rules carry user-facing text such as rule names and descriptions, they are modeled in the conventional EBS multilingual pattern: a single _B table holding language-independent attributes, paired with a _TL table holding one row per translatable attribute per installed language.

From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as a link. This is a suggestion rather than a physical design statement: the table resolves the many-to-many association between a business entity (the elimination rule in GCS_ELIM_RULES_B) and a language reference (FND_LANGUAGES), carrying descriptive payload (RULE_NAME, DESCRIPTION) alongside the relationship. It is worth noting the ETRM documentation marks GCS as Obsolete and states the table is not implemented in the reference database, so it may appear in older instances and in metadata repositories but not in current installations.

Key Information Stored

The table contains ten documented columns. Two form the composite surrogate primary key, GCS_ELIM_RULES_TL_PK:

• RULE_ID — Identifier of the parent elimination rule; also the foreign key to GCS_ELIM_RULES_B.
• LANGUAGE — The language of the translated row, validated against FND_LANGUAGES; the second component of the primary key.
• SOURCE_LANG — The language from which the translated text was derived, also validated against FND_LANGUAGES; used to determine whether a row requires re-translation.
• RULE_NAME — The user-visible name of the elimination rule in the given language. This is a business-key candidate, appearing in unique index GCS_ELIM_RULES_TL_U2 (LANGUAGE, RULE_NAME).
• DESCRIPTION — Free-text description of the rule's purpose for the given language.

The remaining columns are standard EBS WHO (Who Columns) audit attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. Two unique indexes are documented: GCS_ELIM_RULES_TL_U1 (RULE_ID, LANGUAGE), which mirrors the primary key as the business key of the translation set, and GCS_ELIM_RULES_TL_U2 (LANGUAGE, RULE_NAME), which enforces that rule names are unique within a language.

Common Use Cases and Queries

The primary use case is multilingual reporting and user-interface display of elimination rules. Consolidation administrators, auditors, and report authors join the base table to the translation table filtered on the session language. A typical pattern retrieves the rule name and description for a given language:

• SELECT b.rule_id, t.rule_name, t.description FROM gcs_elim_rules_b b, gcs_elim_rules_tl t WHERE b.rule_id = t.rule_id AND t.language = USERENV('LANG') AND b.rule_id = :rule_id;
• Listing all available translations for a rule: SELECT language, rule_name FROM gcs_elim_rules_tl WHERE rule_id = :rule_id ORDER BY language;
• Detecting untranslated or stale rows by comparing SOURCE_LANG against a target LANGUAGE.
• Diagnostic queries identifying duplicate rule names within a language, or rules lacking a translation row for an installed language.

Because the module is obsolete, these queries are most relevant for historical data extracts, migration checks, and audit enquiries into legacy consolidation configurations.

Related Objects

• GCS_ELIM_RULES_B — Base table; joined via RULE_ID. Parent of the RULE_ID foreign key.
• FND_LANGUAGES — Reference table for installed languages; referenced twice, via LANGUAGE and SOURCE_LANG.
• GCS_ELIM_RULES_TL_PK — Composite primary key constraint on RULE_ID and LANGUAGE.
• GCS_ELIM_RULES_TL_U1 / _U2 — Unique indexes supporting the translation and name-uniqueness keys.
• GCS_ELIM_RULES_TL._TL — The translation pattern implies companion GCS elimination, consolidation, and mapping tables (elimination sets, rule lines, and GCS consolidation workbench objects) that reference rules by RULE_ID.
• FND_LANGUAGE session context (USERENV) — Supplied by the application to filter display languages at runtime.