Search Results okc_std_art_set_mems




Overview
Explore in AI Chat

Overview

The OKC_STD_ART_SET_MEMS table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to manage the relationship between standard articles and the sets to which they belong. In the context of contract authoring and management, a Standard Article Set is a predefined collection of legal or business clauses (articles) that can be efficiently applied to contract documents. This table acts as a junction table, recording the precise membership of individual standard articles within these defined sets, enabling the modular and reusable assembly of contract terms.

Key Information Stored

The table's structure is designed to capture the essential link between an article and its set. The primary key is a composite of two columns, which uniquely identifies each membership record. The SAE_ID column stores the unique identifier for the Standard Article, serving as a foreign key to the OKC_STD_ARTICLES_B table. The SAT_CODE column stores the code that identifies the specific Standard Article Set to which the article belongs. Together, these columns define a single instance of an article's inclusion in a set. While the provided metadata focuses on these core columns, other descriptive or control columns (such as creation date, last update date, and sequence number) are typically present in such tables to support application functionality and auditing.

Common Use Cases and Queries

This table is central to operations involving the selection and application of standard contract language. A primary use case is the dynamic generation of a list of available articles when a user is building a contract and selects a specific Standard Article Set. The application queries this table to retrieve all member article IDs for the chosen set. For reporting and administration, common queries include listing all articles within a specific set, identifying which sets contain a particular article, or validating data integrity. A typical SQL pattern to fetch articles for a set would be:

  • SELECT sae_id FROM okc_std_art_set_mems WHERE sat_code = '&SET_CODE';

This result is then often joined to OKC_STD_ARTICLES_B to get the full article text and details for presentation to the user or for inclusion in a contract document.

Related Objects

The OKC_STD_ART_SET_MEMS table has a direct and critical relationship with the base table for standard articles. As documented in the provided metadata:

  • OKC_STD_ARTICLES_B: This table is referenced via a foreign key constraint. The column OKC_STD_ART_SET_MEMS.SAE_ID references the primary key in OKC_STD_ARTICLES_B. This relationship ensures referential integrity, guaranteeing that every article listed in a set is a valid, existing standard article. The table is also intrinsically linked to the business object representing a Standard Article Set, whose master definition is likely stored in a separate table keyed by the SAT_CODE.