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.
- END_USER_ID — surrogate primary key; the join column referenced by every dependent table.
- NAME, LASTNAME, FIRSTNAME, MI, TITLE — person name components and honorific.
- LOGIN_NAME — SellingPoint login identifier used during configuration sessions.
- DBMS_ID — external system identifier for integration and reconciliation.
- EMAIL_ADDR, PHONE, FAX, PAGER, CELLULAR — contact channels.
- ADDR_LINE1, ADDR_LINE2, CITY, STATE, PROVINCE, COUNTY, ZIP, COUNTRY — mailing address.
- END_USER_ORG_ID — organizational grouping for the end user.
- FND_USER_ID — optional link to the EBS application user record in FND_USER.
- ALLOWABLE_DISCOUNT — pricing authorization attribute.
- REPLICATE_FLAG, LAST_REPLICATION — replication state for distributed SellingPoint deployments.
- DELETED_FLAG, EFF_FROM, EFF_TO, EFF_MASK, SECURITY_MASK — logical deletion, effective dating, and access control.
- CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CHECKOUT_USER — standard audit and concurrency columns.
- USER_NUM01–04, USER_STR01–04 — descriptive flexfield-style extension attributes.
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:
- Configurations by end user:
SELECT c.CONFIG_HDR_ID, u.NAME FROM CZ_CONFIG_HDRS c JOIN CZ_END_USERS u ON c.USER_ID_CREATED = u.END_USER_ID; - Quotes raised on behalf of a buyer: join CZ_QUOTE_HDRS.USER_ID_FOR_WHOM_CREATED to CZ_END_USERS.END_USER_ID.
- Replication monitoring:
SELECT END_USER_ID, REPLICATE_FLAG, LAST_REPLICATION FROM CZ_END_USERS WHERE REPLICATE_FLAG = 'Y' AND LAST_REPLICATION IS NULL; - Linkage to EBS users:
SELECT u.END_USER_ID, f.USER_NAME FROM CZ_END_USERS u JOIN FND_USER f ON u.FND_USER_ID = f.USER_ID; - Group membership analysis via CZ_END_USER_GROUPS and CZ_CUSTOMER_END_USERS.
- Impact analysis before purging: confirm no dependent header rows exist in CZ_CONFIG_HDRS, CZ_QUOTE_HDRS, CZ_PROPOSAL_HDRS, or CZ_OPPORTUNITY_HDRS.
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.
-
Oracle SellingPoint users
-
Oracle SellingPoint users
-
VIEW: CZ.CZ_END_USERS# 12.2.2
-
VIEW: CZ.CZ_END_USERS# 12.2.2
-
TABLE: CZ.CZ_END_USERS 12.1.1
-
TABLE: CZ.CZ_END_USERS 12.2.2
-
eTRM - CZ Tables and Views 12.2.2
Import control table responsible for NOUPDATE flags
-
eTRM - CZ Tables and Views 12.1.1
Import control table responsible for NOUPDATE flags