Search Results cz_opp_hdr_contacts_pk

Overview

The CZ_OPP_HDR_CONTACTS table is a junction table within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to manage the many-to-many relationship between sales opportunities and their associated contact persons. By linking opportunity headers to contact records, it enables the tracking of all relevant individuals involved in a specific sales opportunity. As explicitly noted in the official ETRM documentation, this table is marked as "Obsolete." This status indicates that while the table may still exist in the database schema for backward compatibility, its associated functionality is no longer actively developed or recommended for new implementations. Its role is typically superseded by more current data models within the broader CRM or Sales modules of EBS.

Key Information Stored

The table's structure is minimal, serving primarily as an associative entity. Its two key columns form a composite primary key and define its relationships. The OPPORTUNITY_HDR_ID column stores the unique identifier for a sales opportunity, linking to the CZ_OPPORTUNITY_HDRS table. The CONTACT_ID column stores the unique identifier for a contact, linking to the CZ_CONTACTS table. The combination of these two columns ensures that a specific contact is not duplicated for a given opportunity. Beyond these foreign key columns, the table does not typically store additional descriptive attributes about the relationship itself, as its sole purpose is to establish the link.

Common Use Cases and Queries

Given its obsolete status, direct operational use of this table in new customizations or reports is discouraged. However, for historical data analysis or supporting legacy integrations, common queries involve retrieving contact lists for opportunities. A typical reporting query would join this table to its parent tables to extract meaningful information. For example, to list all contacts for a specific opportunity, one might use a SQL pattern such as:

SELECT c.contact_name, c.email, c.phone
FROM cz_contacts c,
cz_opp_hdr_contacts j
WHERE j.opportunity_hdr_id = :p_opp_id
AND j.contact_id = c.contact_id
ORDER BY c.contact_name;

Another use case is verifying the existence of a relationship before performing data maintenance or during data migration validation scripts.

Related Objects

The CZ_OPP_HDR_CONTACTS table has defined foreign key relationships with two core Configurator tables, as documented in the ETRM metadata:

• CZ_OPPORTUNITY_HDRS: This is the parent table for opportunity header information. The relationship is established via the CZ_OPP_HDR_CONTACTS.OPPORTUNITY_HDR_ID column referencing the primary key of CZ_OPPORTUNITY_HDRS.
• CZ_CONTACTS: This is the parent table for contact master data. The relationship is established via the CZ_OPP_HDR_CONTACTS.CONTACT_ID column referencing the primary key of CZ_CONTACTS.

These relationships are critical for maintaining referential integrity. Any record in CZ_OPP_HDR_CONTACTS must have a valid corresponding record in both parent tables. The table itself is referenced by its primary key constraint, CZ_OPP_HDR_CONTACTS_PK, on the (OPPORTUNITY_HDR_ID, CONTACT_ID) columns.