Search Results okc_k_articles_v




Overview
Explore in AI Chat

Overview

OKC_K_ARTICLES_V is an APPS-owned, VALID database view in the Oracle E-Business Suite Contracts Core (OKC) module. It is defined in both Release 12.1.1 and 12.2.2 under the same name and serves as the principal read-only presentation layer over the contract article entity. The view consolidates the physical article row, its version-specific content, and the standard (boilerplate) article definition into a single denormalized result set, exposing contract clause and article text alongside descriptive and audit attributes.

In the Contracts Core data model, an article is stored in OKC_K_ARTICLES_B, its textual content and variation descriptions are held in OKC_ARTICLE_VERSIONS, and the governing standard article metadata is held in OKC_ARTICLES_ALL. Because these are distributed across three tables, direct reporting on contract clauses requires multi-table joins. OKC_K_ARTICLES_V removes that requirement, making it the recommended object for BI Publisher reports, Oracle Discoverer worksheets, custom concurrent program queries, and integration extracts that must publish contract clause content. The view also normalizes the "SAV" (standard article version) reference and derives a CAT_TYPE classification, abstracting legacy OKE upgrade artifacts from the caller.

Underlying Base Objects

The view is defined over three referenced objects, all accessed through APPS synonyms: OKC_K_ARTICLES_B, OKC_ARTICLES_ALL, and OKC_ARTICLE_VERSIONS. The driving table is OKC_K_ARTICLES_B, aliased CATB, and every returned row corresponds to one CONTRACT ARTICLE base record. The join conditions are:

  • CATB.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID — links the article to its specific version row in OKC_ARTICLE_VERSIONS.
  • CATB.SAV_SAE_ID = ART.ARTICLE_ID — links the article to its standard article definition in OKC_ARTICLES_ALL.
  • STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID — an outer join retrieving the standard version row from a second instance of OKC_ARTICLE_VERSIONS.

The outer join on the standard version ensures articles without a resolved standard version are still returned. The view text also maps CATB.ROWID to ROW_ID and projects a literal NULL for SFWT_FLAG, preserving a stable column contract for legacy consumers.

Key Columns

  • ROW_ID, ID — Row identifier (ROWID) and the primary key of the underlying OKC_K_ARTICLES_B record.
  • CHR_ID, CLE_ID, DNZ_CHR_ID — Foreign keys to the contract header and line entities that own the article; DNZ_CHR_ID references the associated contract document.
  • CAT_ID — Contract article identifier linking the article catalog entry.
  • SAV_SAE_ID, SAV_SAV_RELEASE — The standard article identifier and its release, derived via DECODE on ART.STANDARD_YN. When the article is standard, the base-table SAV values are returned; otherwise the standard article row values are substituted.
  • SBT_CODE — The article type code (ART.ARTICLE_TYPE), classifying the clause or section.
  • NAME, TEXT, COMMENTS, VARIATION_DESCRIPTION — Display name (version display name, falling back to article title), full article text, article description, and variation narrative.
  • CAT_TYPE — Derived classification: 'STA' for standard articles and OKE-sourced rows, 'NSD' for non-standard articles.
  • ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield columns for extensible contract clause attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical usage includes extracting clause text for a specific contract, auditing which articles are standard versus non-standard, and feeding contract terms into downstream document generation. Because the view hides the version/standard resolution logic, it is also useful for reconciliation between contract lines and their articles.

Retrieve all articles for a given contract header:

  • SELECT id, name, sbt_code, cat_type, text FROM okc_k_articles_v WHERE chr_id = :p_chr_id ORDER BY id;

List non-standard clauses only:

  • SELECT id, chr_id, name, sav_sav_release FROM okc_k_articles_v WHERE cat_type = 'NSD';

Report article text with audit information for a contract line:

  • SELECT v.id, v.name, v.comments, v.last_updated_by, v.last_update_date FROM okc_k_articles_v v WHERE v.cle_id = :p_cle_id;

Because the view is read-only and built on base tables, all queries should filter on indexed keys such as CHR_ID, CLE_ID, or ID to avoid full scans of OKC_K_ARTICLES_B within large contract repositories.