Search Results cz_imp_customer_end_user




Overview
Explore in AI Chat

Overview

The CZ_IMP_CUSTOMER_END_USER table is a Configurator (CZ) module staging object in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as an intermediate interface table that holds customer-to-end-user association records prior to validation and loading into the permanent CZ_CUSTOMER_END_USERS table. Records that pass import validation are promoted to the base table; records that fail remain in the interface table with a rejection status, enabling error diagnosis and correction before a subsequent migration attempt.

The ETRM heuristic Data Vault classification for this object is standalone. No foreign keys other than the imported attribute references are documented within the FK structure, which suggests a modeling treatment as a staging/satellite-style structure rather than a conformed hub or link. In practice, the table is transient in nature, populated by import processes and purged or archived once the load is complete, so its classification as a standalone staging object is consistent with its operational role.

Key Information Stored

The table is documented with 19 columns. The most operationally significant are:

  • CUSTOMER_ID — Identifies the customer record associated with the end-user relationship.
  • END_USER_ID — Identifies the end user. The documented FK reference from CZ_IMP_CUSTOMER_END_USER.END_USER_ID to CZ_END_USERS confirms this is the primary relationship key carried through the import.
  • EFF_FROM and EFF_TO — Define the effective date range of the customer/end-user association.
  • DELETED_FLAG — Marks the record as logically deleted, supporting soft-delete semantics during import and rejection processing.
  • REC_STATUS and DISPOSITION — Indicate the processing state of the staging row (for example, pending, loaded, or rejected) and any disposition assigned during validation.
  • RUN_ID and REC_NBR — Identify the import batch run and the sequence number of the record within that run.
  • CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY — Standard audit columns recording who created or last modified each staging row and when.
  • SECURITY_MASK and EFF_MASK — Mask columns used by Configurator to determine whether security and effective-date attributes require recalculation or reprocessing.
  • CHECKOUT_USER — Records the user who has checked out the record during import handling.
  • FSK_CUSTOMER_1_1, FSK_ENDUSER_2_1, FSK_ENDUSER_2_EXT — Foreign surrogate key columns used by Configurator for internal cross-reference resolution during import.

No documented unique index or surrogate primary key constraint is supplied in the ETRM metadata for this table; the combination of CUSTOMER_ID, END_USER_ID, RUN_ID, and REC_NBR typically functions as the business-key candidate in practice. The physical surrogate key is not explicitly documented.

Common Use Cases and Queries

Typical usage centers on monitoring import outcomes, resolving rejections, and purging processed rows. A common pattern is to identify rejected staging records for correction:

  • Rejection review: SELECT CUSTOMER_ID, END_USER_ID, REC_STATUS, DISPOSITION, RUN_ID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS = 'REJECTED';
  • Batch reconciliation: count staged versus loaded rows per import run by grouping on RUN_ID and REC_STATUS to confirm the load completed for a given batch.
  • Effective-dating verification: query EFF_FROM / EFF_TO to confirm the validity window of a customer/end-user relationship before promotion to CZ_CUSTOMER_END_USERS.
  • Stale record cleanup: remove staging rows whose REC_STATUS indicates successful load and whose CREATION_DATE precedes a defined retention threshold.

Reporting is generally diagnostic rather than analytical, since the table is a transient staging surface and not a system-of-record for customer/end-user data.

Related Objects

The following objects are most significant in relation to this table:

  • CZ_CUSTOMER_END_USERS — The destination base table that receives validated records from this interface table.
  • CZ_END_USERS — Referenced by the documented foreign key CZ_IMP_CUSTOMER_END_USER.END_USER_ID → CZ_END_USERS; supplies the end-user definition the staging row links to.
  • CZ_CUSTOMERS — The customer master corresponding to the CUSTOMER_ID attribute carried through the import.
  • The Configurator customer/end-user import concurrent program and its associated PL/SQL loaders, which read from this table, apply validation, and populate CZ_CUSTOMER_END_USERS.
  • Configurator security and effective-date mask processing logic, which consumes the SECURITY_MASK and EFF_MASK columns during promotion.

Because the table functions as a standalone staging surface, its dependency set is narrow; the primary integration point is the import process that bridges it to CZ_CUSTOMER_END_USERS.