Results for “tl_ext_attr20”

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

Overview

HZ_CREDIT_RATINGS_EXT_TL is a translation (TL) table in the Oracle E-Business Suite Receivables (AR) schema. It exists to provide multilingual support for extensible credit rating attributes defined against credit rating records in the Oracle Trading Community Architecture (TCA) model. In Release 12.1.1 and 12.2.2 the table carries a documented column count of thirty and is classified as VALID in the ETRM repository, confirming it is a supported, dictionary-managed object rather than a deprecated or orphaned artifact.

The table operates strictly as the language-dependent shadow of HZ_CREDIT_RATINGS. Every row is keyed by an EXTENSION_ID and a LANGUAGE code, and it stores translated or localized values for the extensible attribute group attached to a credit rating. Because it references FND_LANGUAGES, the table participates directly in the standard Oracle EBS multilingual framework, including the SOURCE_LANG / LANGUAGE pairing that governs which seed language a translation was derived from.

Under the heuristic Data Vault classification mined from its foreign key topology, HZ_CREDIT_RATINGS_EXT_TL is modelled as a link table. This is a suggested modelling interpretation rather than a physical EBS designation: it associates an underlying credit rating entity with a specific language context, and its composite unique index behaves as a business key rather than a synthetic hub identifier. Treating it as a link is appropriate when building a dimensional or Data Vault layer over TCA, since it carries no independent descriptive identity of its own.

Key Information Stored

The most significant columns in this object are those that establish identity, language context, and the extensible attribute payload:

• EXTENSION_ID — Part of the primary key HZ_CREDIT_RATINGS_EXT_TL_PK; identifies the extensible attribute instance being translated.
• LANGUAGE — The second primary key column and the FK to FND_LANGUAGES; determines which session language retrieves the row.
• CREDIT_RATING_ID — Foreign key to HZ_CREDIT_RATINGS, tying the translation back to the base credit rating record.
• ATTR_GROUP_ID — Identifies the attribute group to which the extensible attributes belong.
• SOURCE_LANG — The language in which the source values were originally entered; used by the translation framework to determine whether a row requires translation maintenance.
• TL_EXT_ATTR1 through TL_EXT_ATTR20 — The twenty translatable extensible attribute columns that hold the localized text payload. These are the descriptive values that differ by language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS WHO columns providing audit lineage and concurrency context.

The surrogate primary key is HZ_CREDIT_RATINGS_EXT_TL_PK, composed of EXTENSION_ID and LANGUAGE. The unique index HZ_CREDIT_RATINGS_EXT_TL_U1 is documented on the same column pair, making EXTENSION_ID plus LANGUAGE the effective business-key candidate. Because EXTENSION_ID and LANGUAGE appear in both the PK and the unique index, the distinction is largely structural in EBS, but it remains important when reasoning about merge and upsert logic.

Common Use Cases and Queries

The dominant use case is language-aware reporting and extraction of credit rating extensible attributes. Standard EBS reports and custom extracts must join the translation table to the base table and filter on the session or requested language to avoid returning multiple language rows for a single extension.

A typical query pattern joins the base and translation tables on the shared key columns:

• SELECT ext.credit_rating_id, ext.attr_group_id, tl.tl_ext_attr1, tl.tl_ext_attr2 FROM hz_credit_ratings_ext_b ext, hz_credit_ratings_ext_tl tl WHERE ext.extension_id = tl.extension_id AND tl.language = USERENV('LANG')

Note that the base (non-TL) entity table supplies the language-independent columns, while HZ_CREDIT_RATINGS_EXT_TL supplies the translatable text. Reporting against the TL table alone is only meaningful when a specific LANGUAGE filter is applied.

Additional practical scenarios include detecting untranslated rows where LANGUAGE equals SOURCE_LANG, identifying extension records with no translation for a target language, and building data warehouse extracts that flatten the twenty TL_EXT_ATTR columns into a localized dimension. The WHO columns support change-data-capture extracts based on LAST_UPDATE_DATE.

Related Objects

The following objects are the most significant dependencies and counterparts for this table:

• HZ_CREDIT_RATINGS — Joined on CREDIT_RATING_ID; the parent credit rating record to which all extension translations belong.
• FND_LANGUAGES — Joined on LANGUAGE; the language repository that defines which language codes are valid.
• HZ_CREDIT_RATINGS_EXT_B — The language-independent base table for the same extensible attribute structure; joined on EXTENSION_ID.
• HZ_CREDIT_RATINGS_EXT_TL's unique index HZ_CREDIT_RATINGS_EXT_TL_U1 — enforces the EXTENSION_ID and LANGUAGE business key.
• TCA / HZ APIs — the Trading Community Architecture APIs that insert, update, and translate credit rating extension records and, in doing so, write to this table.

When joining across these objects, always drive from the base entity through EXTENSION_ID and CREDIT_RATING_ID, and resolve language through FND_LANGUAGES to ensure the correct translation row is selected.