Search Results okc_std_art_incmpts




Overview
Explore in AI Chat

Overview

The OKC_STD_ART_INCMPTS table is a core repository within the Oracle E-Business Suite Contracts Core module (OKC). Its primary function is to enforce business logic by registering and managing incompatibility rules between standard articles. Standard articles are predefined, reusable contract clauses or terms stored in the system. This table acts as a control mechanism, preventing the simultaneous inclusion of mutually exclusive or logically conflicting articles within a single contract document. By maintaining this registry, the application ensures contract integrity and adherence to defined business rules during the authoring and amendment processes in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to define a bidirectional incompatibility relationship between two articles. Its primary key is a composite of two columns, which also serve as foreign keys. The critical columns are:

  • SAE_ID: Stores the unique identifier (ID) of a standard article. This column references the OKC_STD_ARTICLES_B table.
  • SAE_ID_FOR: Stores the unique identifier (ID) of another standard article that is incompatible with the article identified by SAE_ID. This column also references the OKC_STD_ARTICLES_B table.

The relationship is typically reciprocal; an entry (SAE_ID = A, SAE_ID_FOR = B) implies that article A is incompatible with article B. For complete enforcement, a corresponding record (SAE_ID = B, SAE_ID_FOR = A) is often also present.

Common Use Cases and Queries

The primary use case is validation during contract template creation or contract authoring. When a user attempts to add an article to a document, the application queries this table to check for any registered incompatibilities with articles already present. A common reporting need is to list all incompatibilities for a given article to aid administrators in maintaining rule sets.

Sample SQL to find all articles incompatible with a specific article (ID: 1000):

SELECT inc.sae_id_for, art.article_title
FROM okc_std_art_incmpts inc, okc_std_articles_b art
WHERE inc.sae_id = 1000
AND inc.sae_id_for = art.id;

To find all mutually incompatible article pairs in the system:

SELECT a.article_title, b.article_title
FROM okc_std_art_incmpts inc,
okc_std_articles_b a,
okc_std_articles_b b
WHERE inc.sae_id = a.id
AND inc.sae_id_for = b.id
ORDER BY a.article_title;

Related Objects

The OKC_STD_ART_INCMPTS table has a direct and exclusive relationship with the standard article master table. The documented foreign key relationships are:

  • OKC_STD_ARTICLES_B: The table is referenced twice by OKC_STD_ART_INCMPTS.
    • Foreign Key from OKC_STD_ART_INCMPTS.SAE_ID to OKC_STD_ARTICLES_B.
    • Foreign Key from OKC_STD_ART_INCMPTS.SAE_ID_FOR to OKC_STD_ARTICLES_B.

This design means that both articles involved in an incompatibility rule must be valid records in the standard articles master table. The application's business logic for contract validation and article management heavily depends on this relationship.