Search Results okc_item_partys_b




Overview
Explore in AI Chat

Overview

The OKC_ITEM_PARTYS_B table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. Historically, its purpose was to establish and manage relationships between contract items and the parties or roles associated with them, a fundamental concept for defining deliverables, responsibilities, and obligations within a contractual agreement. However, based on the explicit documentation provided, this table is now classified as obsolete within the context of Oracle EBS releases 12.1.1 and 12.2.2. Its presence in the database schema is typically maintained for backward compatibility and data reference, but new implementations and customizations should avoid direct dependencies on this object, as its data model and functionality have been superseded by other structures within the application.

Key Information Stored

While the detailed column list is not provided in the excerpt, the primary and foreign key relationships indicate the core data elements this table was designed to store. The primary key column ID served as the unique identifier for each record. The two critical foreign key columns define the table's relational purpose: CIM_ID links to a specific contract item in the OKC_K_ITEMS table, and CPL_ID links to a specific party role definition in the OKC_K_PARTY_ROLES_B table. This structure allowed a many-to-many relationship, enabling a single contract item to be associated with multiple party roles and vice versa.

Common Use Cases and Queries

Given its obsolete status, direct operational or reporting use of this table in current implementations is strongly discouraged. Historically, queries would have been used to answer questions such as: "Which parties are responsible for delivering this specific line item?" or "List all contract items assigned to a particular supplier role." A sample historical query pattern might have been:

SELECT k.item_number, p.party_name, r.role_code
FROM okc_item_partys_b ip,
     okc_k_items k,
     okc_k_party_roles_b r,
     hz_parties p
WHERE ip.cim_id = k.id
  AND ip.cpl_id = r.id
  AND r.object_id = p.party_id;

Any such reporting requirements in a current system should be fulfilled using the active, supported data models that replaced this obsolete table.

Related Objects

The documented foreign key relationships explicitly define this table's integration points within the Contracts Core schema. These relationships are critical for understanding historical data lineage and for crafting queries if analyzing legacy data.

  • OKC_K_ITEMS: This table stores the master definitions of contract items. The OKC_ITEM_PARTYS_B.CIM_ID column is a foreign key to OKC_K_ITEMS.ID.
  • OKC_K_PARTY_ROLES_B: This table defines the roles that parties (e.g., Buyer, Seller, Approver) play within a contract. The OKC_ITEM_PARTYS_B.CPL_ID column is a foreign key to OKC_K_PARTY_ROLES_B.ID.

These relationships confirm the table's original role as a junction table connecting items to party roles.