Search Results okc_std_art_classings




Overview
Explore in AI Chat

Overview

The table OKC_STD_ART_CLASSINGS is a core data structure within the Oracle E-Business Suite Contracts Core module (OKC). It functions as a configuration and reference table, central to the management of standard contract articles. Its primary role is to define associations between standard article sets and specific contract subclasses. This enables organizations to predefine which standardized clauses, terms, and conditions (grouped into article sets) are commonly applicable or required for particular types of contracts, thereby streamlining the contract authoring process and ensuring consistency and compliance across agreements.

Key Information Stored

The table stores the mapping relationship between a contract subclass and the standard article sets deemed relevant for it. Key columns include the unique identifier (ID), the subclass code (SCS_CODE) which references OKC_SUBCLASSES_B, and the standard article set code (SAT_CODE). The PRICE_TYPE column is also part of the unique constraint, indicating that the association between a subclass and an article set can be further qualified by a specific pricing model or context. The primary key constraint OKC_STD_ART_CLASSINGS_PK is on the ID column, while the unique constraint SAC_SAIT1_UK ensures that the combination of SAT_CODE, PRICE_TYPE, and SCS_CODE is not duplicated.

Common Use Cases and Queries

The primary use case is during contract creation or template definition, where the system references this table to suggest or automatically include the appropriate standard articles based on the selected contract subclass. For reporting and administration, common queries involve listing all standard article sets available for a given subclass or identifying which subclasses utilize a specific article set. A sample query to retrieve all article set associations for a subclass would be:

  • SELECT sat_code, price_type FROM okc_std_art_classings WHERE scs_code = :p_scs_code;

Conversely, administrators might run a query to audit usage:

  • SELECT scs_code, COUNT(*) FROM okc_std_art_classings GROUP BY scs_code;

Related Objects

The most direct relationship is with the OKC_SUBCLASSES_B table, enforced by a foreign key constraint on the SCS_CODE column. This ensures that any subclass referenced in the classification mapping is a valid, defined subclass within the system. The SAT_CODE column logically references standard article sets, which are likely defined in a related table such as OKC_STD_ARTICLES_TL or similar, though this specific foreign key is not detailed in the provided metadata. This table is integral to the standard article assignment functionality within the Contracts Core's data model.