Search Results okc_rep_contracts_all




Overview
Explore in AI Chat

Overview

The OKC_REP_CONTRACTS_ALL table is the central repository for contract header information within the Oracle E-Business Suite Contracts Core module (OKC). It serves as the primary table for storing the latest version of all contracts authored using the Oracle Contracts Repository. As a multi-org table (indicated by the "_ALL" suffix), it contains data for all operating units, with security typically enforced via views like OKC_REP_CONTRACTS. Its role is foundational to the Contracts application, acting as the master record from which contract relationships, parties, terms, and other detailed components are linked.

Key Information Stored

The table's primary key is the CONTRACT_ID, a unique system-generated identifier for each contract. Based on its documented foreign key relationships, other critical columns include CONTRACT_TYPE, which links to the OKC_BUS_DOC_TYPES_B table to define the contract's business document classification (e.g., Sales Agreement, Purchase Agreement). The NOTIFY_CONTACT_ROLE_ID links to the OKC_REP_CONTACT_ROLES_B table, identifying a default contact role for notifications. While the full column list is not detailed in the provided metadata, a typical contract header table would also store attributes such as contract number, start/end dates, status, description, authoring information, and the associated operating unit (ORG_ID).

Common Use Cases and Queries

This table is central to reporting and data extraction for contract management. Common use cases include generating a master list of all active contracts, analyzing contracts by type, and auditing contract creation. A typical query to retrieve basic contract information for a specific operating unit would join to the document types table for clarity.

  • Sample Query: Basic Contract List
    SELECT ctr.contract_id, ctr.contract_number, ctr.start_date, ctr.end_date, ctr.status, typ.name contract_type
    FROM okc_rep_contracts_all ctr,
    okc_bus_doc_types_b typ
    WHERE ctr.contract_type = typ.bus_doc_type_code
    AND ctr.org_id = :p_org_id
    ORDER BY ctr.creation_date DESC;
  • Reporting Use Case: This table is the starting point for most operational reports, such as contract expiration dashboards or volume analysis by type and status.

Related Objects

As indicated by the foreign keys, OKC_REP_CONTRACTS_ALL has several critical child tables that store detailed contract components, forming the core data model for repository contracts.

  • OKC_REP_CONTRACT_PARTIES: Stores all parties (e.g., customer, supplier, internal contacts) associated with a contract.
  • OKC_REP_CONTRACT_RELS: Manages relationships between contracts, such as amendments, renewals, or hierarchies.
  • OKC_REP_CONTRACT_ACCESS: Holds security rules defining which users or roles can view or modify the contract.
  • OKC_BUS_DOC_TYPES_B: Reference table for valid contract types.
  • OKC_REP_CONTACT_ROLES_B: Reference table for valid contact roles, linked via the NOTIFY_CONTACT_ROLE_ID.