Results for “gcs_elim_rule_steps_tl”

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

Overview

GCS_ELIM_RULE_STEPS_TL is the translation table for GCS_ELIM_RULE_STEPS_B within the Oracle E-Business Suite GCS — Financial Consolidation Hub module. In Oracle EBS, the "_TL" suffix denotes a language-dependent translation table that stores the same business rows as its base ("_B") counterpart, but with one row per installed language for each translatable attribute. This table carries the human-readable, language-specific content of elimination rule steps executed during the financial consolidation and intercompany elimination process. The product is documented as obsolete in current releases, and the ETRM metadata explicitly records that the object is "Not implemented in this database," meaning it may exist in legacy schemas but is not actively populated in the reference installation. The heuristic Data Vault classification mined from the foreign key structure is link, which can be treated as a modeling suggestion: the table associates elimination rule steps with language contexts rather than holding descriptive attributes for a single hub.

Key Information Stored

The table contains nine documented columns, of which the most operationally significant are the following. LANGUAGE holds the language code of the translation row and is also the join key to FND_LANGUAGES. SOURCE_LANG records the language from which the translation was derived, forming a second independent reference to FND_LANGUAGES. STEP_NAME stores the translated, display-facing name of the elimination rule step — the principal business-visible payload of the row. RULE_STEP_ID is the identifier linking each translation back to the rule step in the base and translation-set tables. The surrogate primary key is defined by GCS_ELIM_RULE_STEPS_TL_PK over (LANGUAGE, RULE_STEP_ID). The unique index GCS_ELIM_RULE_STEPS_TL_U1 over (LANGUAGE, RULE_STEP_ID) is the business-key candidate that enforces one translated record per rule step per language. Standard EBS audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — complete the row, enabling change tracking and DBA lineaging of who created or modified each translation.

Common Use Cases and Queries

Because the table is language-aware, its primary use is multilingual reporting of consolidation elimination definitions, particularly where users operate in different FND_LANGUAGES locales. A typical query joins the translation table to the base table on RULE_STEP_ID and filters to the session language:

• SELECT tl.step_name, tl.language, tl.source_lang FROM gcs_elim_rule_steps_tl tl WHERE tl.language = USERENV('LANG') AND tl.rule_step_id = :rule_step_id;
• Auditing which rule steps have been translated versus which still hold the source language, using SOURCE_LANG to identify untranslated content.
• Joining to FND_LANGUAGES twice — once on LANGUAGE and once on SOURCE_LANG — to decode both language codes into descriptive names for reporting.
• Extracting published step names for consolidation documentation or external reporting on eliminated intercompany balances.

Given the obsolete status, queries should be validated against the active schema before being embedded in production reports.

Related Objects

The following objects are most significant to this table, grounded in the documented foreign key and primary key relationships:

• GCS_ELIM_RULE_STEPS_B — the base table that this translation table serves; joined on RULE_STEP_ID.
• FND_LANGUAGES — referenced twice: GCS_ELIM_RULE_STEPS_TL.LANGUAGE → FND_LANGUAGES and GCS_ELIM_RULE_STEPS_TL.SOURCE_LANG → FND_LANGUAGES.
• GCS_ELIM_RULE_STEPS_TL_PK — the primary key constraint over (LANGUAGE, RULE_STEP_ID).
• GCS_ELIM_RULE_STEPS_TL_U1 — the unique index over (LANGUAGE, RULE_STEP_ID), enforcing translation uniqueness.
• GCS_ELIM_RULES and associated elimination rule definition tables — the logical parents governing rule steps within Financial Consolidation Hub.
• FND_LANGUAGE_TL / FND_LANGUAGES_TL — language description sources for joining display names to LANGUAGE and SOURCE_LANG codes.

Oracle Proprietary, Confidential Information — Legal Notices apply.