Search Results okc_rep_contract_parties




Overview
Explore in AI Chat

Overview

The OKC_REP_CONTRACT_PARTIES table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for storing all parties associated with a contract, defining their roles and linking them to the master contract record. Its primary role is to establish and maintain the relationships between a contract and the various external and internal entities involved, such as suppliers, customers, and internal organizations. This table is fundamental for contract party management, enabling reporting, compliance, and operational processes that depend on accurate party identification and role assignment.

Key Information Stored

The table's structure is designed to uniquely identify a party within the context of a specific contract and role. The primary key is a composite of three columns: CONTRACT_ID, PARTY_ID, and PARTY_ROLE_CODE. This ensures that a party can be associated with a contract in multiple distinct roles. The PARTY_ID column stores the identifier for the party entity, but its semantic meaning is derived from the associated PARTY_ROLE_CODE. As per the documentation, the source of the PARTY_ID is determined by the role: it references PO_VENDORS for a SUPPLIER-ORG role, HZ_PARTIES (Trading Community Architecture) for a CUSTOMER role, and HR_ALL_ORGANIZATION_UNITS for internal organizational roles. This design allows the table to act as a unified interface for party data sourced from disparate application foundations within Oracle EBS.

Common Use Cases and Queries

A primary use case is generating a complete list of all parties for a given contract, which is essential for contract summaries and compliance reporting. Another common scenario involves identifying all contracts where a specific vendor or customer party is involved, which supports supplier and customer relationship management. For data validation and integration, queries often join this table to its source tables (e.g., PO_VENDORS, HZ_PARTIES) to verify party existence and synchronize attributes. A typical reporting query to list all parties for a contract would be:

  • SELECT contract_id, party_role_code, party_id FROM okc_rep_contract_parties WHERE contract_id = :p_contract_id ORDER BY party_role_code;

To resolve the party name, the query must be extended with a conditional outer join to the relevant source table based on the PARTY_ROLE_CODE.

Related Objects

The OKC_REP_CONTRACT_PARTIES table maintains defined foreign key relationships with other core Contracts tables, as documented in the ETRM metadata. It is a child table of OKC_REP_CONTRACTS_ALL, linked via the CONTRACT_ID column. This relationship ensures that every party record is tied to a valid master contract. Conversely, OKC_REP_CONTRACT_PARTIES acts as a parent table to OKC_REP_PARTY_CONTACTS. The foreign key from OKC_REP_PARTY_CONTACTS.CONTRACT_PARTY_ID references the primary key in OKC_REP_CONTRACT_PARTIES, establishing that detailed contact information for a party is stored separately and linked to the specific contract-party-role combination. These relationships are critical for maintaining data integrity across the contract party hierarchy.

  • Table: OKC_REP_CONTRACT_PARTIES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_CONTRACT_PARTIES,  object_name:OKC_REP_CONTRACT_PARTIES,  status:VALID,  product: OKC - Contracts Core ,  description: This table stores the Parties in a Contract. The Party can be from PO_VENDORS, HZ_PARTIES, or HR_ALL_ORGANIZATION_UNITS. A PARTY_ID with a PARTY_ROLE_CODE of SUPPLIER-ORG comes from PO_VENDORS; A PARTY_ID with a PARTY_ROLE_CODE of CUSTOMER ,  implementation_dba_data: OKC.OKC_REP_CONTRACT_PARTIES , 

  • Table: OKC_REP_CONTRACT_PARTIES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_CONTRACT_PARTIES,  object_name:OKC_REP_CONTRACT_PARTIES,  status:VALID,  product: OKC - Contracts Core ,  description: Stores the Parties in a contract. The party can be from PO_VENDORS, HZ_PARTIES, or HR_ALL_ORGANIZATION_UNITS. A PARTY_ID with a PARTY_ROLE_CODE of SUPPLIER comes from PO_VENDORS; A PARTY_ID with a PARTY_ROLE_CODE of CUSTOMER or PARTNER com ,  implementation_dba_data: OKC.OKC_REP_CONTRACT_PARTIES , 

  • Table: OKC_REP_PARTY_CONTACTS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_PARTY_CONTACTS,  object_name:OKC_REP_PARTY_CONTACTS,  status:VALID,  product: OKC - Contracts Core ,  description: Stores the contacts for a party in a contract. The contact record can be from PO_VENDOR_CONTACTS, HZ_PARTIES, or PER_PEOPLE_F, depending on the party role of the contacts party. A contact whose party has a role of SUPPLIER comes from PO_ ,  implementation_dba_data: OKC.OKC_REP_PARTY_CONTACTS , 

  • Table: OKC_REP_CONTRACTS_ALL 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_CONTRACTS_ALL,  object_name:OKC_REP_CONTRACTS_ALL,  status:VALID,  product: OKC - Contracts Core ,  description: This table is the main Contracts table. This table stores the latest version of all contracts authored in Contract Repository. ,  implementation_dba_data: OKC.OKC_REP_CONTRACTS_ALL , 

  • Table: OKC_REP_PARTY_CONTACTS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_PARTY_CONTACTS,  object_name:OKC_REP_PARTY_CONTACTS,  status:VALID,  product: OKC - Contracts Core ,  description: This table stores the contacts for a party in a contract. The contact record can be from PO_VENDOR_CONTACTS, HZ_PARTIES, or PER_PEOPLE_F, depending on the party role of the contact party. A contact whose party has a role of SUPPLIER_ORG c ,  implementation_dba_data: OKC.OKC_REP_PARTY_CONTACTS , 

  • Table: OKC_REP_CONTRACTS_ALL 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_REP_CONTRACTS_ALL,  object_name:OKC_REP_CONTRACTS_ALL,  status:VALID,  product: OKC - Contracts Core ,  description: This is the main Contracts table. This table stores the latest version of all Repository-authored contracts. ,  implementation_dba_data: OKC.OKC_REP_CONTRACTS_ALL ,