Results for “okc_article_versions_u2”

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

Overview

OKC_ARTICLE_VERSIONS is a core table in the Oracle Contracts (OKC) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores every version of both standard clauses and non-standard clauses that are created on a business document. Standard clauses can accumulate multiple versions over their lifecycle, whereas non-standard clauses are typically created with a single version. This table is the successor to an earlier clause storage structure and serves as the authoritative repository for clause text, translation, publishing status, and adoption metadata within the Contracts authoring framework.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is hub. OKC_ARTICLE_VERSIONS therefore functions as a central entity whose identity is keyed by a single surrogate identifier, with surrounding tables acting as links and satellites that carry descriptive history and relationships.

Key Information Stored

The table contains 57 documented columns. The most significant are:

• ARTICLE_VERSION_ID — surrogate primary key (OKC_ARTICLE_VERSIONS_PK1) uniquely identifying a clause version.
• ARTICLE_ID — foreign key to OKC_ARTICLES_ALL, linking the version to its parent article (clause).
• ARTICLE_VERSION_NUMBER — sequence number of the version within the parent article.
• ARTICLE_TEXT — the actual clause body text for the version.
• STD_ARTICLE_VERSION_ID — self-referencing FK identifying the standard version from which a non-standard version was derived.
• ARTICLE_STATUS and TRANSLATED_YN — workflow and language state indicators.
• GLOBAL_YN and ADOPTION_TYPE — govern whether the clause is global and how it is adopted into documents.
• ARTICLE_LANGUAGE, DISPLAY_NAME, and ARTICLE_DESCRIPTION — presentation metadata.
• START_DATE/END_DATE, DATE_APPROVED, DATE_PUBLISHED — effective-dating and lifecycle timestamps.
• ARTICLE_TEXT_IN_WORD and EDITED_IN_WORD — support the Microsoft Word integration for clause editing.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER — provide standard EBS concurrency and audit control.

Two unique indexes act as business-key candidates: OKC_ARTICLE_VERSIONS_U1 (ARTICLE_VERSION_ID) and OKC_ARTICLE_VERSIONS_U2 (ARTICLE_ID, ARTICLE_VERSION_NUMBER). The latter enforces that version numbers are unique within a given article.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the latest published clause text, tracing derived non-standard clauses back to their standard source, and auditing clause version history for a contract template. A representative query joining the hub to its parent article and its latest version is:

SELECT av.article_version_number, av.article_text, av.article_status
FROM   okc_article_versions av
WHERE  av.article_id = :article_id
AND    av.article_status = 'ACTIVE'
ORDER BY av.article_version_number DESC;

Another common pattern identifies versions derived from a given standard clause:

SELECT article_version_id, article_id, adoption_type
FROM   okc_article_versions
WHERE  std_article_version_id = :std_version_id;

Contract administrators also query the translated and published flags to report localization coverage across clause libraries.

Related Objects

OKC_ARTICLE_VERSIONS participates in an extensive FK network. The most significant related objects are:

• OKC_ARTICLES_ALL — parent article definition, joined on ARTICLE_ID.
• OKC_ARTICLE_VERSIONS — self-reference via STD_ARTICLE_VERSION_ID for clause derivation.
• OKC_ARTICLE_ADOPTIONS — records adoption of standard or local versions via GLOBAL_ARTICLE_VERSION_ID and LOCAL_ARTICLE_VERSION_ID.
• OKC_K_ARTICLES_B and OKC_K_ARTICLES_BH — bind clause versions to contract documents via ARTICLE_VERSION_ID and REF_ARTICLE_VERSION_ID.
• OKC_ARTICLE_VARIABLES — stores substitutable variables linked by ARTICLE_VERSION_ID.
• OKC_TMPL_DRAFT_CLAUSES — template drafting workspace referencing clause versions.
• OKC_ART_VAR_SECTIONS and OKC_REVIEW_UPLD_TERMS — supporting structures for variable sections and reviewed uploaded terms.