Results for “okc_k_art_var_ext_tl”

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

Overview

OKC_K_ART_VAR_EXT_TL is a translation (TL) table in the OKC (Contracts Core) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific, extended attribute content for contract article variables — the configurable tokens embedded in contract templates and clauses that are substituted at runtime with actual business data. The _TL suffix indicates that the table holds translated or locale-dependent rows keyed by a LANGUAGE column, complementing a base table that stores the language-independent definition. In the Contracts Core module, this table supports the multilanguage capabilities of contract authoring, so that variable prompts, labels, and extended descriptors can be surfaced in the session language of the user.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault modeling scheme. In other words, it does not behave as a pure hub, link, or satellite; it functions as a self-contained descriptive table anchored by its own surrogate key, with only a single documented outbound foreign key to BEN_TCS_CAT. This classification is a modeling suggestion only and should be treated as a guideline rather than a strict architectural designation.

Key Information Stored

The physical schema documented in 12.2.2 lists 52 columns. The most significant are summarized below:

• EXTENSION_ID — Surrogate identifier for the extension record; part of the composite primary key OKC_K_ART_VAR_EXT_TL_P1.
• LANGUAGE — The language or locale code for the row; the second component of the primary key and the discriminator that makes this a translation table.
• ATTR_GROUP_ID — Identifies the attribute group to which the extended attribute belongs.
• CAT_ID — Foreign key to BEN_TCS_CAT, categorizing the extension.
• VARIABLE_CODE — The business identifier of the contract variable being extended.
• SOURCE_LANG — The source language from which the translation was derived.
• DATA_LEVEL_ID — Indicates the data level associated with the extension.
• TL_EXT_ATTR1 … TL_EXT_ATTR40 — Forty generic, translated extended-attribute slots used to hold locale-specific descriptive content.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns.

The surrogate primary key is (EXTENSION_ID, LANGUAGE). A unique index, OKC_K_ART_VAR_EXT_TL_U1, also spans (EXTENSION_ID, LANGUAGE); this is documented as the business-key candidate and mirrors the primary key in this case. In practice EXTENSION_ID links each translation row back to its parent extension record, while LANGUAGE determines which localized variant of the extended attribute text is retrieved.

Common Use Cases and Queries

Typical reporting usage centers on resolving translated extended-attribute values for a given variable and language context. A representative query joins the translation row to its parent extension and filters by language:

• Retrieve localized extended attributes: SELECT t.extension_id, t.variable_code, t.tl_ext_attr1 FROM okc_k_art_var_ext_tl t WHERE t.language = USERENV('LANG') AND t.extension_id = :id;
• Compare translation coverage across languages for a variable set.
• Audit which rows were created or last updated by a given user for governance reporting.
• Feed contract print or template generation logic where variable labels must reflect the user's session language.

Because the table is a translation companion, queries should always constrain on LANGUAGE to avoid returning every locale variant of the same EXTENSION_ID.

Related Objects

• BEN_TCS_CAT — Referenced via the CAT_ID foreign key; provides category definitions for the extension.
• OKC_K_ART_VAR_EXT (base table) — The language-independent parent of this translation table, joined on EXTENSION_ID.
• OKC_K_ART_VARIABLES / OKC_K_ARTICLES — Article and variable definition tables that supply VARIABLE_CODE context.
• OKC_K_ART_VAR_EXT_TL_P1 / _U1 — The primary key and unique index enforcing uniqueness on (EXTENSION_ID, LANGUAGE).
• OKC Contract Terms and Conditions APIs — Runtime substitution logic that resolves extended attribute values using the session language.