Search Results okc_change_requests_b




Overview
Explore in AI Chat

Overview

The OKC_CHANGE_REQUESTS_B table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as the primary transactional table for storing all requests to modify an existing contract. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the contract change management process, enabling structured and auditable modifications to contractual terms, parties, or deliverables after a contract has been established. Each record represents a distinct change request, which can subsequently be associated with multiple specific amendments or changes.

Key Information Stored

The table's primary key is the ID column, which uniquely identifies each change request. A critical foreign key is the CHR_ID column, which links the change request to its parent contract header in the OKC_K_HEADERS_B table. While the provided ETRM metadata does not list all columns, standard practice in OKC tables suggests the table will also contain essential audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), object version number (OBJECT_VERSION_NUMBER), and a JTF_NOTES column for storing descriptive text. Additional columns likely manage the request's status, type, and sequencing within the contract's lifecycle.

Common Use Cases and Queries

This table is central to reporting on contract amendments and understanding the change history of a contract. Common use cases include generating a list of all change requests for a specific contract, tracking the volume of amendments over time, and auditing the change process. A typical query would join OKC_CHANGE_REQUESTS_B to the contract headers table to retrieve request details alongside contract information.

  • Sample Query: To find all change requests for a contract number, one would execute:
    SELECT crt.ID, crt.CHR_ID, kh.CONTRACT_NUMBER, crt.CREATION_DATE
    FROM OKC.OKC_CHANGE_REQUESTS_B crt,
    OKC.OKC_K_HEADERS_B kh
    WHERE crt.CHR_ID = kh.ID
    AND kh.CONTRACT_NUMBER = '<CONTRACT_NUMBER>';
  • Data from this table feeds into standard Oracle Contracts reports and is accessed via the Contracts user interface for managing the amendment workflow.

Related Objects

The OKC_CHANGE_REQUESTS_B table is a central hub in the contract change data model. As indicated by the foreign key relationships, it is directly referenced by several other transactional tables:

  • OKC_CHANGES_B: Stores the individual line-level changes that are grouped under a single change request (CRT_ID).
  • OKC_CHANGE_PARTY_ROLE: Holds changes related to contract parties and their roles for a request.
  • OKC_CR_K_ACCESSES: Manages security and access control for the change request.
  • OKC_K_PROCESSES: Tracks approval and workflow processes associated with the change request.
  • OKC_K_HEADERS_B: The parent table for all contracts, to which the change request is linked via CHR_ID.

Direct querying of this table should be performed with caution, and standard Oracle Contracts APIs should be preferred for any programmatic data operations to maintain data integrity.