Search Results sys_il0000329404c00017

Overview

The table OKC.OKC_K_ART_VARIABLES_H is a contract clause variable table within the Oracle E-Business Suite Contracts (OKC) schema. It stores the clause variables used in a document through a contract term, capturing the resolved value of article-level variables for a specific contract clause and version. In Oracle EBS 12.1.1 and 12.2.2, this object supports the Contracts Core module's authoring and template framework, where clauses (articles) can contain merge-style variables that are populated at runtime from contract data, attribute value sets, or externally supplied values.

The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10 and is validated (VALID) in the ETRM catalog. The metadata classifies this object heuristically as standalone from a Data Vault modeling perspective. As a modeling suggestion, the absence of significant inbound FK dependencies indicates the object can be treated as an independent hub-like entity keyed by its natural business key, with change-tracking behavior implying satellite characteristics for the value-bearing columns.

Key Information Stored

The table contains 17 documented columns. The most significant are the business-key and value columns:

• CAT_ID — Contract clause ID; part of the unique business key and a foreign key to OKC.OKC_K_ART_VARIABLES_H.CAT_ID → BEN_TCS_CAT.
• MAJOR_VERSION — Major version number, completing the versioned business key.
• VARIABLE_CODE — The article variable code (VARCHAR2(30)); together with CAT_ID and MAJOR_VERSION forms the unique index OKC_K_ART_VARIABLES_H_U1.
• VARIABLE_TYPE — Classification of the article variable.
• EXTERNAL_YN — Indicator of whether the variable originates externally.
• ATTRIBUTE_VALUE_SET_ID — References the attribute value set used to resolve the variable.
• VARIABLE_VALUE_ID — Identifier (VARCHAR2(40)) of the resolved value.
• VARIABLE_VALUE — The resolved variable value (VARCHAR2(2000)).
• OVERRIDE_GLOBAL_YN — Shows whether a global value is overridden.
• MR_VARIABLE_HTML and MR_VARIABLE_XML — CLOB columns holding HTML and XML representations of the variable.
• OBJECT_VERSION_NUMBER — Optimistic locking value set to 1 on insert and incremented on update, used by APIs.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Two LOB indexes, SYS_IL0000329404C00016$$ and SYS_IL0000329404C00017$$ (the latter the user searched for), support the CLOB columns. A non-unique index OKC_K_ART_VARIABLES_H_N1 exists on VARIABLE_CODE for lookup performance.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving resolved variable values for a contract clause version, auditing override behavior, and extracting HTML/XML renderings for document generation.

• Query resolved variables for a given clause and version:
  SELECT VARIABLE_CODE, VARIABLE_VALUE FROM OKC_K_ART_VARIABLES_H WHERE CAT_ID = :cat_id AND MAJOR_VERSION = :ver;
• Identify overridden globals: WHERE OVERRIDE_GLOBAL_YN = 'Y'.
• Find externally sourced variables: WHERE EXTERNAL_YN = 'Y'.
• Locate by variable code using the non-unique index: WHERE VARIABLE_CODE = :code.

Related Objects

The primary documented relationship is the FK from CAT_ID to BEN_TCS_CAT, linking clause variable records to contract clause definitions. Related Contracts Core objects include clause/article definition tables (OKC_K_ARTICLES, OKC_K_ARTICLE_VERSIONS), the contract header/version structures (OKC_K_HEADERS, OKC_K_LINES), and supporting value-set entities referenced by ATTRIBUTE_VALUE_SET_ID. APIs such as the Contracts Core article/variable APIs and concurrent document generation programs read and write this table during contract authoring and merging.