Search Results okc_subclasses_b_pk

Overview

The OKC_SUBCLASSES_B table is a core master data table within the Oracle E-Business Suite Contracts Core (OKC) module, specifically in versions 12.1.1 and 12.2.2. It functions as a configuration and control table that defines the hierarchical structure and permissible attributes for contract line styles. As indicated by its description, it determines the line style hierarchy, valid rule groups, valid party roles, and commonly used standard article sets for contracts. This table is essential for enforcing business rules and maintaining data integrity across the contract lifecycle, ensuring that contract lines conform to predefined organizational standards and classifications.

Key Information Stored

The primary data stored in OKC_SUBCLASSES_B revolves around the definition and properties of contract subclasses. The table's structure is centered on a unique subclass code. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal critical data points. The CODE column serves as the unique identifier (Primary Key: OKC_SUBCLASSES_B_PK) for each subclass. The CLS_CODE column is a foreign key linking back to the OKC_CLASSES_B table, establishing the parent-child relationship between a contract class and its subclasses. Other columns, implied by the table's description, would store attributes such as the display name, hierarchy level, indicators for enabling specific rule groups, party roles, and references to standard article sets.

Common Use Cases and Queries

This table is primarily referenced for setup validation, reporting on contract configuration, and as a constraint for transactional data. A common use case is to identify all valid subclasses available for a specific contract class during contract authoring or setup. For instance, to list all subclasses within a given class for a report or LOV, one would query:

• SELECT scs.code, scs.name FROM okc_subclasses_b scs WHERE scs.cls_code = :p_class_code ORDER BY scs.code;

Another typical scenario involves analyzing the configuration of a particular subclass to understand its associated rule groups or roles, which would involve joining to related tables like OKC_SUBCLASS_RG_DEFS or OKC_SUBCLASS_ROLES. System administrators and functional implementers query this table to verify and audit the contract line style hierarchy configured for the application.

Related Objects

As evidenced by its extensive foreign key relationships, OKC_SUBCLASSES_B is a central reference point for numerous transactional and setup tables within the Contracts Core and integrated modules like Oracle Lease Management (OKL). Key related objects include:

• Parent Table: OKC_CLASSES_B (via CLS_CODE foreign key).
• Core Transaction Tables: OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, and OKC_K_SEQ_LINES, which store contract headers and lines that reference a subclass.
• Configuration Tables: OKC_SUBCLASS_RG_DEFS (Rule Groups), OKC_SUBCLASS_ROLES (Party Roles), OKC_STD_ART_CLASSINGS (Standard Articles), OKC_SUBCLASS_RESPS, and OKC_SUBCLASS_TOP_LINE, which define subclass-specific attributes.
• Other Dependent Tables: OKC_ASSENTS and OKL_CRTRN_SBCLSSES, highlighting integration with assent and leasing functionality.