Results for “okc_std_art_set_mems”

50+ results




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

Overview

The OKC_STD_ART_SET_MEMS table resides in the OKC schema, which belongs to the Contracts Core (OKC) product family within Oracle E-Business Suite. It records the membership of articles in a Standard Article Set, functioning as an intersection or association table that resolves the many-to-many relationship between standard articles and the article sets to which they belong. In Oracle Contracts, standard articles are reusable clause or article definitions, and Standard Article Sets group these articles together for reuse across contract templates and authored contract documents. The table therefore underpins the composition of article sets used during contract authoring and template administration.

From a Data Vault modeling perspective, the metadata indicates a satellite-leaning classification. This heuristic reflects the table's role as an attribute-bearing structure tied to a parent hub through the SAE_ID foreign key, rather than as an independent hub or a pure link. Modelers may wish to treat OKC_STD_ART_SET_MEMS as a satellite attached to the standardized article entity, capturing set membership as descriptive context.

Key Information Stored

The table contains nine documented columns. The most significant include:

The surrogate primary key is the composite OKC_STD_ART_SET_MEMS_PK (SAE_ID, SAT_CODE). The unique index OKC_STD_ART_SET_MEMS_U1 on the same column pair represents the documented business-key candidate, ensuring that any given article appears at most once within a given article set.

Common Use Cases and Queries

Typical use cases include determining which articles constitute a given Standard Article Set, identifying all sets to which an article is assigned, and auditing membership changes for compliance or version control. A representative query listing members of a set is:

SELECT m.SAE_ID, m.SAT_CODE, b.ARTICLE_NAME FROM OKC_STD_ART_SET_MEMS m, OKC_STD_ARTICLES_B b WHERE m.SAE_ID = b.ID AND m.SAT_CODE = :set_code;

Reporting scenarios may join this table to article base tables to produce set composition reports, or aggregate counts to identify sets with unusually large or small membership. Security-filtered queries should constrain on SECURITY_GROUP_ID where row-level security applies.

Related Objects

  • OKC_STD_ARTICLES_B — The parent entity for articles; joined via OKC_STD_ART_SET_MEMS.SAE_ID.
  • OKC_STD_ARTICLES_TL — Provides translated article names for reporting joins.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID to enforce data security.
  • OKC_STD_ART_SETS_B — Likely master definition of Standard Article Sets keyed by SAT_CODE.
  • OKC_STD_ART_SET_MEMS_PK / _U1 — The primary key constraint and unique index enforcing membership integrity.
  • OKC standard article and contract authoring APIs — Consume set membership when rendering articles into contract documents.