Search Results okc_rule_groups_b

Overview

The OKC_RULE_GROUPS_B table is a core repository within the Oracle E-Business Suite Contracts Core (OKC) module, specifically in versions 12.1.1 and 12.2.2. It serves as a foundational data structure for managing business rules. As its description indicates, it stores a collection of rules that inform an automated process about a specific business function. This table is central to the rule-based engine in Oracle Contracts, enabling the definition, grouping, and hierarchical organization of business logic that can be applied to contract headers, lines, or other entities. Its design supports complex rule structures through self-referential relationships, allowing for nested rule groups.

Key Information Stored

The table's primary key is the ID column, uniquely identifying each rule group. Critical foreign key columns establish its relationships within the Contracts schema and with other product families. The CHR_ID column links a rule group to a specific contract header in the OKC_K_HEADERS_B table, while the CLE_ID column links it to a contract line in OKC_K_LINES_B. A significant structural feature is the PARENT_RGP_ID column, which creates a parent-child hierarchy within the table itself, enabling the nesting of rule groups for sophisticated logical constructs. Other essential columns typically include creation dates, last update dates, and status indicators, which are standard for EBS audit and lifecycle management.

Common Use Cases and Queries

This table is primarily accessed for implementing and reporting on business rules tied to contracts. Common scenarios include querying all rules associated with a specific contract or line item, analyzing the hierarchical structure of a complex rule set, or troubleshooting rule execution. A typical query pattern involves joining OKC_RULE_GROUPS_B to contract headers or lines and then to the detailed rules table (OKC_RULES_B). For instance, to find all rule groups for a contract, one might use:

• SELECT rgp.* FROM okc_rule_groups_b rgp WHERE rgp.chr_id = <contract_id>;

Another frequent use case, as hinted by the user's search for "okl_rules_dff," involves extending rule functionality through Descriptive Flexfields (DFFs). The foreign key from OKL_RULES_DFF to OKC_RULE_GROUPS_B.RGP_ID allows the Oracle Lease and Finance Management (OKL) module to attach custom attributes to the core rule groups defined in OKC.

Related Objects

OKC_RULE_GROUPS_B is a pivotal table with numerous dependencies. Its most direct relationships, as documented, include:

• OKC_K_HEADERS_B / OKC_K_LINES_B: Core contract entities to which rule groups are attached.
• OKC_RULES_B: Stores the individual rules that belong to a rule group.
• OKC_RG_PARTY_ROLES: Associates parties and their roles with specific rule groups.
• OKL_RULES_DFF and OKS_RULES_DFF: Descriptive Flexfields from the Lease (OKL) and Service (OKS) product families that extend the base rule group data with module-specific attributes.
• Self-Reference: The table has a foreign key to itself via PARENT_RGP_ID, enabling hierarchical rule group structures.