Results for “article_language”

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

Overview

OKC_ARTICLES_ALL is the core clause repository table within the Oracle EBS Contracts Core (OKC) module. It stores every clause (also called an "article" in the data model) available to an operating unit, spanning both standard clauses maintained in the enterprise clause library and non-standard, ad hoc clauses authored for a specific contract document or template. The table replaces the earlier OKC_ARTICLES object and is the authoritative source from which contract terms are assembled, versioned, and rendered. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the OKC schema, is fully valid, and exposes 38 documented columns.

From a Data Vault modeling perspective, the foreign-key topology suggests OKC_ARTICLES_ALL is hub-leaning: ARTICLE_ID is a durable, non-repeating business key, while descriptive and contextual attributes (titles, languages, status flags) behave satellite-like. Practitioners designing downstream marts should treat it as a hub with associated satellites and links rather than as a transactional fact.

Key Information Stored

The surrogate primary key is ARTICLE_ID, enforced by OKC_ARTICLES_ALL_PK1 and mirrored by the unique index OKC_ARTICLES_ALL_U1, making it the strongest business-key candidate. Column-level highlights include:

• ARTICLE_ID — surrogate primary key; the join key to nearly every dependent clause table.
• ARTICLE_NUMBER — user-visible clause reference number, often used in reporting and clause library search.
• ARTICLE_TITLE — short descriptive name of the clause.
• ARTICLE_LANGUAGE — foreign key to FND_LANGUAGES; supports multilingual clause libraries.
• ORG_ID — foreign key to HR_ALL_ORGANIZATION_UNITS; enforces multi-org (operating unit) data segregation.
• STANDARD_YN — distinguishes standard library clauses from non-standard clauses.
• ARTICLE_TYPE — classifies the clause by type or category.
• ARTICLE_INTENT — indicates the intended usage or intent of the clause within contract drafting.
• ORIG_SYSTEM_REFERENCE_CODE / ID1 / ID2 — supports integration with external authoring or source systems.
• CZ_TRANSFER_STATUS_FLAG — tracks transfer or migration status of the clause record.
• OBJECT_VERSION_NUMBER — optimistic locking column for concurrent modification control.
• WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_ID, PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID, REQUEST_ID) — audit trail and concurrent-program provenance.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive-flexfield extension columns.

Common Use Cases and Queries

Typical reporting needs include listing all standard clauses for an operating unit, locating clauses by language or title, and auditing recently modified clause library content.

• Operating-unit clause inventory: SELECT article_id, article_number, article_title FROM okc_articles_all WHERE org_id = :p_org_id AND standard_yn = 'Y';
• Multilingual clause lookup joining FND_LANGUAGES on ARTICLE_LANGUAGE.
• Audit reporting using CREATION_DATE / LAST_UPDATE_DATE ranges and CREATED_BY / LAST_UPDATED_BY.
• Dependency discovery — joining to OKC_K_ARTICLES_B or OKC_ARTICLE_VERSIONS on ARTICLE_ID to trace where a clause is consumed.

Because ORG_ID is enforced, queries should always be filtered by operating unit in multi-org environments, and standard_yn combined with org_id is the primary filter pair used by the clause library UI.

Related Objects

• FND_LANGUAGES — joined via OKC_ARTICLES_ALL.ARTICLE_LANGUAGE to resolve the clause language.
• HR_ALL_ORGANIZATION_UNITS — joined via OKC_ARTICLES_ALL.ORG_ID for operating unit resolution.
• OKC_ARTICLE_VERSIONS — references ARTICLE_ID; stores clause version history.
• OKC_ARTICLE_RELATNS_ALL — references TARGET_ARTICLE_ID; defines relationships between clauses.
• OKC_K_ARTICLES_B — references REF_ARTICLE_ID; links clauses to contract documents.
• OKC_FOLDER_CONTENTS — references MEMBER_ID; places clauses in clause library folders.
• OKC_TMPL_DRAFT_CLAUSES, OKC_ART_VAR_SECTIONS, OKC_REVIEW_UPLD_TERMS, and OKC_QA_ERRORS_T — all reference ARTICLE_ID for template drafting, rule validation, review, and quality checks.