Results for “sae_id_for”

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

Overview

OKC_STD_ART_INCMPTS is a Contracts Core (OKC) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that registers incompatibilities between standard articles. Standard articles are pre-defined reusable clause and article definitions maintained in the contracts repository; the incompatibility table records the pairings in which one standard article cannot be combined with another within the same contract or template. The object resides in the OKC schema and is listed with VALID status.

From a dimensional modeling perspective, the mined FK structure suggests a Data Vault classification of link. This is a heuristic recommendation rather than a documented Oracle classification: the table carries no descriptive attributes beyond standard WHO/audit columns and instead resolves a many-to-many relationship between two rows of the same parent entity, OKC_STD_ARTICLES_B. In Data Vault terms it functions as a same-hub link (a self-referencing link), recording the association between one standard article (SAE_ID) and the standard article it is incompatible with (SAE_ID_FOR).

Key Information Stored

The documented physical schema exposes 9 columns. The most significant are:

• SAE_ID — the surrogate key of the standard article (from OKC_STD_ARTICLES_B) that participates in the incompatibility relationship. Part of the composite primary key.
• SAE_ID_FOR — the surrogate key of the standard article that SAE_ID is incompatible with. Also part of the composite primary key, forming the other half of the relationship pair.
• OBJECT_VERSION_NUMBER — optimistic locking / concurrency control column used by the AOL/forms layer to detect concurrent updates.
• CREATED_BY — the user who created the incompatibility record.
• CREATION_DATE — the date and time the record was inserted.
• LAST_UPDATED_BY — the user who last modified the record.
• LAST_UPDATE_DATE — the timestamp of the most recent modification.
• LAST_UPDATE_LOGIN — the login identifier associated with the last update, used for auditing.
• SECURITY_GROUP_ID — the operating unit / security group discriminator, referencing FND_SECURITY_GROUPS, enabling multi-org style data segregation.

The surrogate primary key is OKC_STD_ART_INCMPTS_PK, defined on the composite of (SAE_ID, SAE_ID_FOR). A separate unique index, OKC_STD_ART_INCMPTS_U1, is documented on the same two columns (SAE_ID, SAE_ID_FOR). Because the PK and U1 cover the same columns, these two columns are the business-key candidates: the pair together guarantees that a given incompatibility between any two standard articles is registered exactly once, and the combination is functionally the natural (business) key of the relationship.

Common Use Cases and Queries

The principal use case is validation at contract authoring time: when a user attempts to attach a standard article to a contract, the application can check whether that article is already flagged incompatible with an article already present. Retrieval of the full incompatibility set for a given article is the most common query pattern:

SELECT i.sae_id, i.sae_id_for
FROM   okc.okc_std_art_incmpts i
WHERE  i.sae_id = :p_article_id;

To report incompatibilities with article names, join twice to the parent table, once for each side of the relationship, aliasing the table for the SAE_ID and SAE_ID_FOR legs respectively. Reporting use cases include auditing which clause combinations are prohibited, and validating configuration completeness across a contracts implementation. Because the table is a pure link with no descriptive payload, it is typically queried through joins rather than scanned directly.

Related Objects

• OKC_STD_ARTICLES_B — the primary parent table. SAE_ID references it (the article in question) and SAE_ID_FOR also references it (the incompatible article). Both FK legs join on OKC_STD_ARTICLES_B.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data segregation.
• OKC_STD_ARTICLES_TL — translatable article names/descriptions, conventionally joined for reporting readable article titles.
• OKC_STD_ARTICLES_VL — the view combining base and translation rows, commonly used in queries instead of the base table.
• OKC_K_ARTICLES — the contract-level article instance table, relevant to enforcement logic at runtime.
• OKC_ARTICLES_ALL — the organization-facing article access object used by the Contracts UI.

In summary, OKC_STD_ART_INCMPTS is a compact, audit-stamped link table enforcing mutual-exclusion rules between standard contract articles, keyed by the ordered pair (SAE_ID, SAE_ID_FOR) and secured by SECURITY_GROUP_ID.