Search Results sys_il0000085485c00013

Overview

The OKC.OKC_STD_ART_VERSIONS_TL table is the translation (MLS) companion to OKC_STD_ART_VERSIONS_B within the Oracle Contracts (OKC) module. It stores the language-specific, translatable attributes of standard article versions, allowing the same standard article version to exist in multiple installed languages. In Oracle EBS 12.1.1 and 12.2.2, this table is maintained automatically by the Multi-Lingual Support (MLS) framework whenever a base-row value is translated or a new language row is created.

The object's documented status is VALID and its FND Design Data reference is OKC.OKC_STD_ART_VERSIONS_TL. Under the heuristic Data Vault classification supplied in the metadata, this object is assessed as standalone; from a dimensional-modeling perspective it can be treated as a satellite of the base table OKC_STD_ART_VERSIONS_B, carrying descriptive and language-dependent attributes keyed to the parent article version. This classification is a modeling suggestion, not a physical constraint declared in EBS.

Because the table stores CLOB content (the TEXT column) and MLS metadata, it participates in translation workflows for contract terms and standard articles reused across agreements, templates, and clauses.

Key Information Stored

The table contains 14 documented columns. The most significant are the composite key columns and the descriptive translatable attributes:

• SAE_ID (NUMBER) – Identifier of the standard article. Part of the primary key.
• SAV_RELEASE (VARCHAR2 150) – Version of the article. Part of the primary key.
• LANGUAGE (VARCHAR2 12) – Standard MLS language column. Part of the primary key.
• SOURCE_LANG (VARCHAR2 12) – Standard MLS column identifying the source language of the translation.
• SFWT_FLAG (VARCHAR2) – Indicates a value was changed in another language; flagged as not fully implemented in 11i.
• SHORT_DESCRIPTION (VARCHAR2 600) – User-entered abbreviated description of the article version.
• TEXT (CLOB) – The article text as authored in the contract element; the primary translatable payload.
• OBJECT_VERSION_NUMBER (NUMBER) – Optimistic-locking counter used by APIs; set to 1 on insert, incremented on update.
• SECURITY_GROUP_ID (NUMBER) – Used in hosted environments.
• Standard Who columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The primary key is documented as OKC_STD_ART_VERSIONS_TL_PK (SAE_ID, SAV_RELEASE, LANGUAGE). The unique index OKC_STD_ART_VERSIONS_TL_U1 (SAE_ID, SAV_RELEASE, LANGUAGE) mirrors the primary key and is the documented business-key candidate. A LOB index (SYS_IL0000085485C00013$$) supports the TEXT CLOB column.

Common Use Cases and Queries

Typical usage centers on retrieving or reporting standard article version text in a specific language, verifying translation completeness, and extracting content for contract generation. Because the table is keyed by SAE_ID, SAV_RELEASE, and LANGUAGE, queries should bind all three or join back to the base table.

• Retrieve the text and description for one article version in a target language:

  SELECT SAE_ID, SAV_RELEASE, LANGUAGE, SHORT_DESCRIPTION, TEXT
  FROM   OKC.OKC_STD_ART_VERSIONS_TL
  WHERE  SAE_ID = :sae_id
  AND    SAV_RELEASE = :sav_release
  AND    LANGUAGE = USERENV('LANG');

• List all available translations for an article:

  SELECT LANGUAGE, SOURCE_LANG, SHORT_DESCRIPTION
  FROM   OKC.OKC_STD_ART_VERSIONS_TL
  WHERE  SAE_ID = :sae_id
  AND    SAV_RELEASE = :sav_release;

• Detect untranslated or stale rows by comparing SOURCE_LANG against the installed base language.
• Feed clause and template reporting (e.g., BR100/business-report extracts), where translated article text must appear per user language.

Reporting should be cautious with the TEXT CLOB, which may require DBMS_LOB or SUBSTR for aggregation.

Related Objects

• OKC.OKC_STD_ART_VERSIONS_B – Base MLS table; joins on SAE_ID and SAV_RELEASE. The TL table holds its translatable columns.
• OKC.OKC_STD_ART_VERSIONS_TL_PK – Primary key constraint index.
• OKC.OKC_STD_ART_VERSIONS_TL_U1 – Unique business-key index (SAE_ID, SAV_RELEASE, LANGUAGE).
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID in hosted environments.
• OKC standard article / terms APIs and the OKC schema views – DML is typically performed through the Okc API layer rather than direct SQL, ensuring OBJECT_VERSION_NUMBER and MLS integrity are preserved.

Direct DML is discouraged; use supported APIs or ML translations screens so that SOURCE_LANG and SFWT_FLAG remain consistent.