Search Results cz_contacts




Overview
Explore in AI Chat

Overview

The CZ_CONTACTS table is a historical data object within the Oracle E-Business Suite (EBS), specifically for the Configurator (CZ) module. Its primary role was to store contact information for customers within the context of the Model-Driven Application (MDApp) framework. As explicitly noted in the official ETRM documentation, this table is now OBSOLETE. This status indicates that while the table may still exist in the CZ schema of databases supporting versions 12.1.1 or 12.2.2 for backward compatibility, it is no longer actively maintained or used by current Configurator application logic. Its functionality has been superseded by other, more centralized contact management structures within the broader EBS architecture.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique contact identifier and its relationships to other entities. The primary key is the CONTACT_ID column, which uniquely identifies each contact record. Two critical foreign key columns establish core relationships: CUSTOMER_ID links the contact to a specific customer record in the CZ_CUSTOMERS table, and ADDRESS_ID links the contact to a physical address stored in the CZ_ADDRESSES table. While specific detail columns (e.g., name, phone, email) are not enumerated in the excerpt, the table's purpose implies it historically held such attributes to define a customer's point of contact for configurable item transactions.

Common Use Cases and Queries

Given its obsolete status, direct operational use cases are deprecated. However, historical data analysis or migration projects may necessitate querying this table. A typical pattern would involve joining to its related customer and address tables to retrieve a complete historical contact profile. For example, a query to audit legacy data might be:

SELECT cc.contact_id, cc.customer_id, cust.customer_name, addr.address_line1
FROM cz.cz_contacts cc
LEFT JOIN cz.cz_customers cust ON cc.customer_id = cust.customer_id
LEFT JOIN cz.cz_addresses addr ON cc.address_id = addr.address_id
WHERE cust.customer_name LIKE '%<Customer>%';

Reporting would be purely for archival purposes, such as generating lists of contacts associated with historical quotes or proposals before a system decommissioning.

Related Objects

The ETRM documentation specifies several foreign key relationships, highlighting CZ_CONTACTS' former integration point. The table is referenced by multiple header tables in the Configurator module, demonstrating its role in transactional documents.