Search Results okc_k_grpings




Overview
Explore in AI Chat

Overview

The table OKC_K_GRPINGS is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for releases 12.1.1 and 12.2.2. It functions as the definitive repository for defining and managing contract group memberships. Its primary role is to establish and maintain the hierarchical relationships within contract groups, enabling the logical grouping of individual contracts and other contract groups for collective management, reporting, and processing. This table is essential for supporting complex contract structures where multiple agreements or subgroups must be treated as a single entity for operational or analytical purposes.

Key Information Stored

The table's structure is designed to capture the parent-child relationships that constitute a group. The critical columns include the system-generated primary key ID. The relationship is defined by the parent group identifier, CGP_PARENT_ID, which references the parent contract group. The table then stores the identity of the included member, which can be either a specific contract via INCLUDED_CHR_ID (referencing a contract header) or another, nested contract group via INCLUDED_CGP_ID. This dual-reference design allows for the flexible inclusion of both atomic contracts and subgroups. The uniqueness constraint CGC_CGC1_UK on these three relationship columns ensures a member (contract or group) is not duplicated within the same parent group.

Common Use Cases and Queries

A primary use case is generating a comprehensive roster of all contracts belonging to a specific master group, which is vital for consolidated billing, renewal tracking, or compliance reporting. Analysts often query this table to understand the contract hierarchy or to audit group composition. A typical query pattern involves a recursive SQL or hierarchical query to traverse the group tree. For example, to list all contracts directly under a known parent group ID, one might use:

  • SELECT included_chr_id FROM okc_k_grpings WHERE cgp_parent_id = &parent_group_id AND included_chr_id IS NOT NULL;

For reporting on the total value or status of all contracts within a group hierarchy, this table would be joined with OKC_K_HEADERS_ALL_B and other contract detail tables using the included_chr_id as the key.

Related Objects

OKC_K_GRPINGS is centrally linked to other fundamental tables in the Contracts Core schema. It has direct foreign key relationships to OKC_K_GROUPS_B for both the parent group (CGP_PARENT_ID) and any included subgroup (INCLUDED_CGP_ID). It also references OKC_K_HEADERS_ALL_B via the INCLUDED_CHR_ID column to link to individual contract documents. These relationships enforce referential integrity, ensuring that every entry in OKC_K_GRPINGS corresponds to a valid group or contract header. Consequently, any processes, APIs, or user interfaces that create, modify, or delete contract group memberships will ultimately interact with this table.