Search Results okc_std_art_versions_tl




Overview
Explore in AI Chat

Overview

OKC_STD_ART_VERSIONS_TL is the multilingual (MLS) translation table for the Oracle Contracts Core module (OKC) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-dependent, user-facing text associated with standard contract article (clause) versions. The base, language-independent attributes of each article version reside in the companion table OKC_STD_ART_VERSIONS_B, while the translatable description and body text are held here, keyed by language. This separation follows Oracle's standard MLS (Multi-Lingual Support) architecture, which allows a single article version record to present different text content to users operating in different language environments.

From a data-modeling perspective, the object carries a heuristic Data Vault classification of standalone. This should be treated as a modeling suggestion rather than a definitive designation: because the table is a translation satellite hanging off its base table, it is most naturally modeled as a satellite keyed to the business key formed by the article version identifier and release.

Key Information Stored

The table uses a composite surrogate primary key, OKC_STD_ART_VERSIONS_TL_PK, defined over SAE_ID, SAV_RELEASE, and LANGUAGE. These same three columns also form a unique index (OKC_STD_ART_VERSIONS_TL_U1), making them the effective business-key candidates for joining back to the base table.

  • SAE_ID — Identifier of the standard article (clause) to which the version belongs; part of the primary key.
  • SAV_RELEASE — The article version release identifier; part of the primary key and the linkage to a specific version of the article.
  • LANGUAGE — The language code of the translated row; part of the primary key. Together with the two identifiers above it uniquely identifies each translated record.
  • SOURCE_LANG — The language from which the row was originally derived, supporting MLS translation workflows.
  • SHORT_DESCRIPTION — The short, user-facing title or summary for the article version in the given language.
  • TEXT — The full translatable body text of the standard article version.
  • OBJECT_VERSION_NUMBER — Optimistic locking counter used by the OAF/BC4J framework for concurrency control.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording creation and modification metadata.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant / operating-unit security filtering.

Common Use Cases and Queries

The dominant use case is retrieving the human-readable text for a standard article version in a specified language. Reports and integrations typically join OKC_STD_ART_VERSIONS_B to this TL table on the base key columns and constrain by LANGUAGE.

  • Fetching translated clause text for contract generation and printing.
  • Building language-specific clause libraries and term repositories.
  • Auditing translation coverage — identifying article versions lacking a row for a required language.

A typical query pattern is:

SELECT b.sae_id, b.sav_release, tl.short_description, tl.text FROM okc.okc_std_art_versions_b b, okc.okc_std_art_versions_tl tl WHERE b.sae_id = tl.sae_id AND b.sav_release = tl.sav_release AND tl.language = 'US';

Coverage reporting reverses the join with an outer join on the TL table filtered by language, counting rows where no translation exists.

Related Objects

The following objects are significant to working with this table, drawn from the documented relationship data and Contracts Core structure.

  • OKC_STD_ART_VERSIONS_B — The base table holding language-independent article version attributes; joined on SAE_ID and SAV_RELEASE.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for multi-tenant security filtering.
  • OKC_STD_ARTICLES_B / _TL — Parent standard article definitions referenced by SAE_ID.
  • OKC_STD_ART_VERSIONS_TL_PK / _U1 — Primary key and unique index enforcing uniqueness on SAE_ID, SAV_RELEASE, LANGUAGE.
  • OKC_TERMS_* tables — Contract terms structures that consume standard article version text.
  • FND_LANGUAGES — Reference table validating the LANGUAGE and SOURCE_LANG values.