Search Results cat_type




Overview
Explore in AI Chat

Overview

APPS.OKL_K_ARTICLES_UV is a reporting and integration view within the Oracle E-Business Suite ETRM (Enterprise Tracking and Reporting Management) module, used primarily in the context of Oracle Contracts (OKC) and lease/fulfillment management. It consolidates contract article records from the OKC_K_ARTICLES_V and OKC_STD_ARTICLES_V views, presenting a unified projection of articles associated with contracts, standard articles, and related clauses. The "UV" suffix denotes a user view, indicating it is intended for query and reporting consumption rather than direct DML maintenance.

The view plays a specific filtering role: it restricts the underlying article data to two distinct CAT_TYPE values — 'NSD' (structured/narrative standard document articles retrieved directly from OKC_K_ARTICLES_V) and 'STA' (standard articles retrieved by joining OKC_K_ARTICLES_V to OKC_STD_ARTICLES_V on SAV_SAE_ID = ID). This union-based construction is the defining characteristic of the view and explains its relevance to the search term "cat_type," since the article category type is the principal discriminator governing which source row contributes to each output row.

Underlying Base Objects

The documented base objects referenced by OKL_K_ARTICLES_UV are:

  • OKC_K_ARTICLES_V (VIEW) — supplies the 'NSD' branch as a standalone selection and serves as the driving source for the 'STA' branch.
  • OKC_STD_ARTICLES_V (VIEW) — joined in the 'STA' branch via CAT.SAV_SAE_ID = SAE.ID, contributing the NAME attribute from the standard article definition.
  • MO_GLOBAL (PACKAGE) — the Multi-Org / operating unit access control package that enforces organizational security at runtime, ensuring that only articles belonging to accessible operating units are exposed.

The relation across branches is a UNION (not UNION ALL), meaning duplicate rows across the two selections are eliminated. Both branches project an identical column list, ensuring structural consistency for downstream consumers.

Key Columns

  • ID — Primary identifier of the article record.
  • CHR_ID — Contract header identifier; links the article to its parent contract.
  • CLE_ID — Contract line/clause element identifier.
  • CAT_ID — Article identifier within the category context.
  • CAT_TYPE — The category type discriminator; restricted to 'NSD' and 'STA' in this view.
  • NAME — Article name; for 'STA' rows this is sourced from OKC_STD_ARTICLES_V.
  • SFWT_FLAG — Software flag indicator associated with the article.
  • SAV_SAE_ID / SAV_SAV_RELEASE — Standard article version and release references.
  • SBT_CODE — Sub-type or source code attribute.
  • DNZ_CHR_ID — Denormalized contract header reference used for performance.
  • COMMENTS, FULLTEXT_YN, VARIATION_DESCRIPTION — Descriptive and full-text attributes.
  • OBJECT_VERSION_NUMBER — Optimistic locking version token.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes reporting on contract articles by category type, extracting standard article content for document generation, and reconciling clause/article structures across contracts.

  • List all standard-type articles for a contract: 
    SELECT ID, NAME, CAT_TYPE
FROM APPS.OKL_K_ARTICLES_UV
WHERE CAT_TYPE = 'STA'
AND CHR_ID = :contract_id;
  • Count articles grouped by category type: 
    SELECT CAT_TYPE, COUNT(*)
FROM APPS.OKL_K_ARTICLES_UV
GROUP BY CAT_TYPE;
  • Retrieve narrative/structured document articles: 
    SELECT ID, CHR_ID, NAME, VARIATION_DESCRIPTION
FROM APPS.OKL_K_ARTICLES_UV
WHERE CAT_TYPE = 'NSD';

Because MO_GLOBAL enforces multi-org filtering, callers should initialize the operating unit context (e.g., via MO_GLOBAL.SET_POLICY_CONTEXT) before querying, particularly in concurrent programs and reports, to ensure correct row visibility under Oracle EBS 12.1.1 and 12.2.2.