Search Results cz_customers




Overview
Explore in AI Chat

Overview

The CZ_CUSTOMERS table is a data object within the Oracle E-Business Suite (EBS) Configurator (CZ) module. According to the official ETRM documentation, its status is explicitly marked as "OBSOLETE," and it was originally designed to store customer data for the Model-Driven Application (MDApp) framework. In the context of EBS 12.1.1 and 12.2.2, this table represents a legacy structure. Its primary role was to serve as a customer master within the Configurator's data model, supporting transactional entities like quotes and opportunities. However, given its obsolete status, its functional significance in active implementations is minimal, and it is likely superseded by standard EBS customer tables such as HZ_PARTIES and HZ_CUST_ACCOUNTS for integrated processes.

Key Information Stored

The core identifier for a customer record in this table is the CUSTOMER_ID column, which serves as the primary key. The table also includes a PARENT_ID column, which establishes a hierarchical relationship between customer records, allowing for parent-child customer structures. While the provided metadata does not list all columns, the foreign key relationships indicate the table was designed to store fundamental customer identifiers to link to related address (CZ_ADDRESSES), contact (CZ_CONTACTS), and transactional data. The obsolete nature of the table suggests that any business-critical customer attributes in a live system would be housed elsewhere in the EBS schema.

Common Use Cases and Queries

Given its obsolete status, direct operational or reporting use of the CZ_CUSTOMERS table in current EBS implementations is strongly discouraged. Historical analysis or data migration projects might necessitate queries against this table. A typical pattern would involve joining the table to its related entities to extract legacy configuration data. For example, to retrieve a legacy customer with its associated addresses, one might use a query such as:

  • SELECT cust.customer_id, addr.address_id FROM cz_customers cust LEFT JOIN cz_addresses addr ON cust.customer_id = addr.customer_id WHERE cust.customer_id = <ID>;

Any new development or integration should utilize the standard Trading Community Architecture (TCA) customer tables instead.

Related Objects

The CZ_CUSTOMERS table has documented foreign key relationships with several other Configurator tables, as per the provided metadata. These relationships illustrate its former central role in the data model:

These dependencies indicate that the CUSTOMER_ID is a key foreign key in multiple transactional and master tables within the obsolete MDApp framework.