Search Results related_contract_id

Overview

The OKC_REP_CONTRACT_RELS table is a core data repository within the Oracle E-Business Suite Contracts Core (OKC) module. Its primary function is to store and manage explicit, user-defined relationships between different contract documents in the system. This table is essential for establishing a structured hierarchy and network of contracts, enabling complex business scenarios where one contract may be a renewal, amendment, master agreement, or exhibit of another. By maintaining these relationships, the module supports comprehensive contract lifecycle management, reporting, and analysis, ensuring that the connections between related legal documents are formally tracked and auditable.

Key Information Stored

The table's structure is designed to capture the essential elements of a contract-to-contract relationship. The primary identifier is the system-generated CONTRACT_RELATIONSHIP_ID. The core relationship is defined by two key foreign key columns: CONTRACT_ID and RELATED_CONTRACT_ID, which store the identifiers of the two linked contracts from the OKC_REP_CONTRACTS_ALL table. The nature of the link is defined by the RELATED_CONTRACT_ROLE column, which specifies the role (e.g., "Renewal," "Amendment") that the RELATED_CONTRACT_ID plays relative to the CONTRACT_ID. Additionally, the RELATIONSHIP_TYPE_ID provides a foreign key link for further categorization or validation of the relationship type, though its specific reference table is not detailed in the provided metadata.

Common Use Cases and Queries

A primary use case is generating reports on contract hierarchies, such as listing all amendments or renewals for a specific master agreement. Support teams often query this table to understand the full context of a contract during troubleshooting or audit requests. A typical SQL pattern retrieves all related contracts for a given document:

• SELECT rel.related_contract_role, rc.contract_number FROM okc_rep_contract_rels rel, okc_rep_contracts_all rc WHERE rel.related_contract_id = rc.contract_id AND rel.contract_id = :p_contract_id;

Conversely, to find all contracts where a specific document plays a subordinate role:

• SELECT rel.related_contract_role, rc.contract_number FROM okc_rep_contract_rels rel, okc_rep_contracts_all rc WHERE rel.contract_id = rc.contract_id AND rel.related_contract_id = :p_contract_id;

Data integrity checks are also common, such as identifying orphaned relationships where one of the referenced contracts no longer exists.

Related Objects

OKC_REP_CONTRACT_RELS is centrally linked to the primary contract repository, OKC_REP_CONTRACTS_ALL, through two foreign key constraints on the CONTRACT_ID and RELATED_CONTRACT_ID columns. This ensures that relationships can only be established between valid contract records. The table's primary key constraint is OKC_REP_CONTRACT_RELS_PK on CONTRACT_RELATIONSHIP_ID. While not fully detailed in the excerpt, the RELATIONSHIP_TYPE_ID column implies a dependency on another lookup or definition table that governs allowable relationship types. This table is foundational for any reporting view or API within the Contracts Core module that needs to traverse or display contract relationships.