Search Results cz_customer_end_users




Overview
Explore in AI Chat

Overview

The CZ_CUSTOMER_END_USERS table is a data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role was to manage the assignment of customers to specific end users within the context of the Model Developer Application (MDApp). As explicitly noted in the official ETRM documentation, this table is now classified as OBSOLETE. This designation indicates that while the table may still exist in the database schema for backward compatibility, its functional purpose has been superseded or deprecated in the application's architecture. Its historical function was to establish a many-to-many relationship between customer entities and end-user entities, a linkage critical for user-specific configuration and access control in earlier implementations of the Configurator.

Key Information Stored

The table's structure is defined by a composite primary key, which also represents the core data it stores. The two key columns are CUSTOMER_ID and END_USER_ID. The CUSTOMER_ID column holds a foreign key reference to a unique customer record in the CZ_CUSTOMERS table. The END_USER_ID column holds a foreign key reference to a unique user record in the CZ_END_USERS table. Together, each row in this table represents a single, distinct association between one customer and one end user. No other descriptive columns are indicated by the provided metadata, underscoring the table's function as a pure intersection or mapping entity.

Common Use Cases and Queries

Given its obsolete status, direct operational use of this table in new development or reporting is strongly discouraged. Typical use cases would have been historical, such as querying which users were authorized to configure products for a specific customer, or determining all customers assigned to a particular user. A sample historical query to retrieve these assignments might have been:

  • SELECT c.customer_name, e.user_name FROM cz_customer_end_users ce, cz_customers c, cz_end_users e WHERE ce.customer_id = c.customer_id AND ce.end_user_id = e.end_user_id;

In current practice, consultants and developers should rely on the newer, supported APIs and data models that have replaced this table's functionality. Any existing data within this table should be considered legacy and may only be relevant for data migration or audit trail purposes.

Related Objects

The table's relationships are explicitly defined by its foreign key constraints, as documented in the ETRM. It is directly dependent on two parent tables:

  • CZ_CUSTOMERS: The CZ_CUSTOMER_END_USERS.CUSTOMER_ID column references the primary key of this table. This table stores master data for customers within the Configurator module.
  • CZ_END_USERS: The CZ_CUSTOMER_END_USERS.END_USER_ID column references the primary key of this table. This table stores master data for end users within the Configurator module.

The relationship is strictly maintained through these foreign keys, ensuring referential integrity between the assignment records and the master data entities they link. There are no documented foreign keys where other tables reference CZ_CUSTOMER_END_USERS, which is consistent with its obsolete nature.