Search Results okc_k_articles_tlh




Overview
Explore in AI Chat

Overview

The table OKC_K_ARTICLES_TLH resides in the OKC schema, which forms the foundation of the Contracts Core module within Oracle E-Business Suite 12.1.1 and 12.2.2. The object is documented as the history table for OKC_K_ARTICLES_TL, capturing prior or superseded versions of article definitions maintained in the multilingual contracts article repository. Its documented purpose is historical version retention rather than transactional processing, and it is explicitly flagged as an obsolete table, obsoleted at release 11.5.10. As a result, on any 12.1.1 or 12.2.2 instance the table physically exists in the OKC schema with all 17 documented columns intact, but it is not populated by current application logic and should not be treated as an active source of contract article content.

The heuristic Data Vault classification mined from the foreign key structure is standalone, with no hub, link, or satellite relationship inferred from the mined relationships. In modeling terms, this absence of dependent FK relationships is consistent with a legacy version-retention store whose parent relationships were not preserved through declarative constraints in the shipped schema.

Key Information Stored

The physical structure is anchored by a composite surrogate primary key, OKC_K_ARTICLES_TLH_PK, defined over ID, LANGUAGE, and MAJOR_VERSION. A unique index, OKC_K_ARTICLES_TLH_U1, mirrors the same three columns (ID, LANGUAGE, MAJOR_VERSION), meaning the surrogate key and the business-key candidate are functionally identical in this table. Because both the multilingual dimension (LANGUAGE) and the version dimension (MAJOR_VERSION) participate in the key, each historical row is uniquely identified by the combination of article identity, language, and version level.

  • ID — Surrogate identifier of the contract article; the leading column of both the primary key and the unique index.
  • LANGUAGE — Language code of the translated article text; the second key column.
  • MAJOR_VERSION — Version level of the retained article record; the third key column that distinguishes historical iterations.
  • SOURCE_LANG — The source language from which the translated row was derived.
  • SFWT_FLAG — Flag indicating whether the source language and translation text are identical.
  • NAME — Article name or title as presented on the contract document.
  • TEXT — The article body text stored in the supported language.
  • COMMENTS — Descriptive or annotative text associated with the article.
  • VARIATION_DESCRIPTION — Description of the variation or alternate form of the article.
  • OBJECT_VERSION_NUMBER — Optimistic locking counter used by the applications framework.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking insert and last modification context.
  • SECURITY_GROUP_ID — Security grouping used for access partitioning; the only documented foreign key, referencing FND_SECURITY_GROUPS.
  • SAV_SAV_RELEASE — Release-level marker retained from the historical record.

Common Use Cases and Queries

Because the table is obsolete, its practical use is confined to historical auditing, upgrade forensics, and data retention analysis. A typical investigative query retrieves all retained versions of a given article across languages:

  • SELECT id, language, major_version, name, source_lang, last_update_date FROM okc.okc_k_articles_tlh WHERE id = :article_id ORDER BY major_version DESC;
  • Comparing historical text against the live OKC_K_ARTICLES_TL row set to determine which translations were superseded and when.
  • Auditing creation and update metadata during post-upgrade reconciliation of contract article definitions.
  • Verifying security partitioning by joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS when reconstructing historic access scopes.
  • Assessing purge eligibility, since obsolete tables frequently become candidates for archival under data retirement policies.

Related Objects

  • OKC_K_ARTICLES_TL — The current multilingual base table for which this object serves as the history/version store; joined on ID, LANGUAGE, and MAJOR_VERSION.
  • OKC_K_ARTICLES_B — The base (non-translated) article definition table, forming the identity anchor for article IDs.
  • FND_SECURITY_GROUPS — Referenced by the SECURITY_GROUP_ID foreign key.
  • OKC_K_ARTICLES_TLH_PK — The primary key constraint enforcing uniqueness across ID, LANGUAGE, and MAJOR_VERSION.
  • OKC_K_ARTICLES_TLH_U1 — The unique index duplicating the key column set as the business-key candidate.
  • OKC_K_ARTICLE_REVISIONS — Related Contracts Core revision structures used where active article versioning is maintained.