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:
- SAE_ID — The identifier of the standard article; participates in the primary key OKC_STD_ART_SET_MEMS_PK and in the unique index OKC_STD_ART_SET_MEMS_U1. It also forms a foreign key to OKC_STD_ARTICLES_B.
- SAT_CODE — The Standard Article Set code identifying the set to which the article belongs; the second component of both the primary key and the unique index.
- OBJECT_VERSION_NUMBER — Supports optimistic concurrency control during updates to membership records.
- CREATED_BY, CREATION_DATE — Standard audit columns recording the creating user and timestamp.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Audit columns capturing the most recent modification context.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org or data-level security partitioning.
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.
-
Records the membership of articles in a Standard Article Set.
-
Records the membership of articles in a Standard Article Set.
-
Table: OKC_FOLDER_CONTENTS 12.1.1
This table stores the clauses associated to a folder. This replaces the table OKC_STD_ART_SET_MEMS used in releases prior to 11.5.10
-
This table stores the clauses associated to a folder. This replaces the table OKC_STD_ART_SET_MEMS used in releases prior to 11.5.10.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2