Search Results okc_subclass_rg_defs

Overview

The table OKC_SUBCLASS_RG_DEFS is a core configuration table within the Oracle E-Business Suite Contracts Core (OKC) module. Its primary function is to define the association between a contract subclass and a rule group definition. This association is fundamental to the rule-based governance and processing of contracts, enabling the system to apply specific business rules, validations, and workflows based on the type of contract being processed. By serving as a junction between subclass definitions and rule groups, this table is critical for enforcing a structured and automated contract management framework in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on linking identifiers. Its primary key is the ID column, which uniquely identifies each association record. The most significant foreign key is SCS_CODE, which references the OKC_SUBCLASSES_B table to identify the specific contract subclass. The table also holds a reference to a rule group definition, though the exact column name for this link is implied by the foreign key relationships rather than explicitly stated in the provided excerpt. The existence of foreign keys from tables like OKC_LSE_RULE_GROUPS, OKC_RG_ROLE_DEFS, and OKL_OPT_RULES to OKC_SUBCLASS_RG_DEFS indicates that the table's primary key (ID) is referenced as SRD_ID (or SRD_ID_FOR) by these dependent objects, establishing it as the central definition point for rule group assignments.

Common Use Cases and Queries

This table is primarily accessed for configuration and diagnostic purposes. A common operational query is to list all rule groups assigned to a specific contract subclass to verify setup. For example: SELECT srd.id, scs.scs_code, scs.name FROM okc_subclass_rg_defs srd, okc_subclasses_b scs WHERE srd.scs_code = scs.scs_code AND scs.scs_code = 'SERVICE';. Conversely, administrators may query to find which subclasses use a particular rule group definition. The table is also integral to the runtime engine; when a user creates a contract of a given subclass, the application queries this table to determine which set of rules (e.g., for validation, pricing, or termination) should be invoked for that document instance.

Related Objects

OKC_SUBCLASS_RG_DEFS is a central hub in the Contracts Core rule definition schema. Its documented foreign key relationships are as follows:

• OKC_SUBCLASSES_B: Linked via the column OKC_SUBCLASS_RG_DEFS.SCS_CODE. This is the master definition table for contract subclasses.
• OKC_LSE_RULE_GROUPS: References OKC_SUBCLASS_RG_DEFS via OKC_LSE_RULE_GROUPS.SRD_ID. This table stores lease-specific rule groups.
• OKC_RG_ROLE_DEFS: References OKC_SUBCLASS_RG_DEFS via OKC_RG_ROLE_DEFS.SRD_ID. This table defines roles within a rule group.
• OKL_OPT_RULES: References OKC_SUBCLASS_RG_DEFS via OKL_OPT_RULES.SRD_ID_FOR. This table, from the Oracle Lease and Finance Management module, stores option rules, demonstrating cross-modular integration.