Search Results okc_rg_role_defs




Overview
Explore in AI Chat

Overview

The OKC_RG_ROLE_DEFS table is a core data definition table within the Oracle E-Business Suite Contracts Core module (OKC). It functions as a configuration table that governs the application of business rule groups to specific contract parties. Its primary role is to define which predefined contract party roles are eligible to act as the subject or the object for a rule group within a specific contract subclass. This establishes a critical link between the abstract business rules defined for a contract type and the concrete parties involved in a contract, enabling role-based rule enforcement in agreements.

Key Information Stored

The table stores the associations that authorize specific roles for rule group participation. While the full column list is not detailed in the provided metadata, the foreign key relationships indicate the presence of several critical columns. The primary key column is ID. The SRD_ID column stores a foreign key to the OKC_SUBCLASS_RG_DEFS table, linking to a specific rule group definition for a subclass. The SRE_ID column stores a foreign key to the OKC_SUBCLASS_ROLES table, identifying the specific contract party role (e.g., Buyer, Supplier, Authorized Contact) that is permitted for this rule group. This combination effectively answers: "For this rule group, which party roles can this rule be applied to or evaluated against?"

Common Use Cases and Queries

This table is central to configuring and validating contract business rules. A common use case is during contract authoring or amendment, where the system validates if a party assigned to a given role on the contract header or line is a permissible participant for any active rule groups. Administrators may query this table to audit or report on role-based rule configurations. A typical diagnostic query would join to related definition tables to list all authorized roles for a rule group.

SELECT scrd.rule_group_code,
       scr.role_code,
       scr.name role_name
  FROM okc_rg_role_defs rrd,
       okc_subclass_rg_defs scrd,
       okc_subclass_roles scr
 WHERE rrd.srd_id = scrd.id
   AND rrd.sre_id = scr.id
   AND scrd.subclass_code = 'SERVICE'
 ORDER BY scrd.rule_group_code, scr.role_code;

Related Objects

  • OKC_SUBCLASS_RG_DEFS: Defines the rule groups available for a contract subclass. Joined via OKC_RG_ROLE_DEFS.SRD_ID = OKC_SUBCLASS_RG_DEFS.ID.
  • OKC_SUBCLASS_ROLES: Defines the valid party roles for a contract subclass. Joined via OKC_RG_ROLE_DEFS.SRE_ID = OKC_SUBCLASS_ROLES.ID.
  • OKC_RG_PARTY_ROLES: This table holds the actual instance-level assignments of contract parties to rule groups. It references OKC_RG_ROLE_DEFS via OKC_RG_PARTY_ROLES.RRD_ID = OKC_RG_ROLE_DEFS.ID, enforcing that runtime assignments are valid against the predefined role definitions.