Search Results okc_k_groups_b




Overview
Explore in AI Chat

Overview

The OKC_K_GROUPS_B table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as the primary repository for user-defined contract groups, which function as logical "buckets" or categories for organizing contracts. These groups are a fundamental part of the contract hierarchy and classification system, enabling users to manage, report on, and apply business rules to collections of contracts as a single entity. Its role is central to structuring contract portfolios, facilitating bulk operations, and establishing relationships between contracts for purposes such as renewal cascades or default settings.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is the ID column, which uniquely identifies each contract group record. Based on its central role and foreign key relationships, the table is expected to store essential attributes for each group, including a unique identifier (ID), a name or code for the group, a description, effective dates (start and end), and status indicators. It likely contains audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE, which are standard in Oracle EBS tables. The data defines the group entity itself, while its relationships to specific contracts are managed through associated junction tables.

Common Use Cases and Queries

A primary use case is creating and maintaining logical collections of contracts for streamlined management and reporting. Administrators can define groups based on criteria like business unit, contract type, or geographic region. Common queries involve listing all active contract groups, identifying contracts within a specific group, or generating summary reports for a group's total value or status. Sample SQL patterns include joining with the OKC_K_GRPINGS table to resolve group membership.

  • To list all contract groups: SELECT id, name, description FROM okc_k_groups_b WHERE sysdate BETWEEN start_date AND nvl(end_date, sysdate);
  • To find contracts in a specific group (joining via OKC_K_GRPINGS): SELECT kgr.contract_id FROM okc_k_groups_b kgb, okc_k_grpings kgr WHERE kgb.id = kgr.cgp_parent_id AND kgb.id = :group_id;

Related Objects

The OKC_K_GROUPS_B table has several key dependencies, as indicated by its foreign keys. The OKC_K_GRPINGS table references it twice, for CGP_PARENT_ID and INCLUDED_CGP_ID, establishing the hierarchical relationships and membership links between groups and contracts. Within the Oracle Service Contracts (OKS) module, the OKS_K_DEFAULTS table references OKC_K_GROUPS_B for both CGP_NEW_ID and CGP_RENEW_ID, linking contract groups to defaulting rules for new and renewal contracts. This integration highlights how groups defined in Contracts Core drive automated processes in related modules.