Results for “last_replication”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_END_USERS is the master reference table for Oracle SellingPoint end users within the Oracle Configurator (CZ) module of Oracle E-Business Suite. It stores the individuals or organizational contacts for whom configurations, quotes, proposals, and opportunities are created. In the SellingPoint sales cycle, the end user is frequently distinct from the EBS application user operating the session; CZ_END_USERS captures that distinction by holding contact, address, login, and organizational attributes for the selling party's customers and prospects.

The table resides in the CZ schema and is documented as VALID in both ETRM 12.1.1 and 12.2.2. Its heuristic Data Vault classification is hub-leaning, meaning it functions as a durable business entity repository keyed by a surrogate identifier, with surrounding transactional tables acting as links or satellites. This classification is a modeling suggestion rather than an enforced construct; the physical implementation is a conventional EBS table with standard audit columns. The 47-column breadth reflects a mix of identity, contact, flexibility, and concurrency attributes accumulated across release levels.

Key Information Stored

The primary key is the surrogate END_USER_ID, enforced by the unique index CZ_END_USERS_PK. No additional unique index is documented, so the surrogate alone serves as the documented business-key candidate; natural identity is therefore distributed across descriptive attributes rather than constrained.

Common Use Cases and Queries

Typical reporting resolves end-user identity onto configuration and quote headers, validates orphaned references, and audits replication status. A representative join pattern follows:

Because END_USER_ID is referenced by many tables, deletion should be logical (DELETED_FLAG) rather than physical, preserving historical configuration and quote lineage.

Related Objects

The documented foreign keys identify the principal dependents and interface tables:

  • CZ_CONFIG_HDRS — references CZ_END_USERS twice, via USER_ID_CREATED and USER_ID_FOR_WHOM_CREATED.
  • CZ_QUOTE_HDRS — references via USER_ID_CREATED and USER_ID_FOR_WHOM_CREATED.
  • CZ_PROPOSAL_HDRS — references via USER_ID_CREATED and USER_ID_FOR_WHOM_CREATED.
  • CZ_OPPORTUNITY_HDRS — references via END_USER_ID.
  • CZ_CUSTOMER_END_USERS — association of end users to customers through END_USER_ID.
  • CZ_END_USER_GROUPS — group membership keyed by END_USER_ID.
  • CZ_IMP_END_USER, CZ_IMP_CUSTOMER_END_USER, CZ_IMP_END_USER_GROUP — interface tables that load and stage end-user and group data.