Search Results cz_imp_end_user_group




Overview
Explore in AI Chat

Overview

CZ_IMP_END_USER_GROUP is a staging table in the Oracle E-Business Suite Configurator (CZ) module, owned by the CZ schema. It serves as an interim landing area for records destined for the production association table CZ_END_USER_GROUPS. Rows loaded into this table originate from bulk import routines, data migration scripts, or interface programs, and are subsequently validated, accepted, or rejected before being promoted into the operational end-user group assignments. Because Configurator models complex product structures and the users authorized to configure them, the integrity of end-user-to-group mappings is critical; this staging table isolates raw import data from the live configuration metadata.

The table is classified as VALID in the ETRM catalog and contains 23 documented physical columns in 12.2.2. Its heuristic Data Vault classification, mined from foreign-key structure, is standalone. As a modeling suggestion, this reflects the fact that the table’s foreign-key footprint is narrow (a single documented reference). Rather than functioning as a classic hub or satellite, it behaves as a transient load buffer, so treating it as a staging standalone entity — rather than a durable Data Vault component — is the appropriate analytical stance.

Key Information Stored

The most significant columns fall into identity, lineage, and processing-control categories:

No dedicated surrogate primary key column is documented; identity is effectively composite, anchored on END_USER_ID plus USER_GROUP_ID within a given RUN_ID.

Common Use Cases and Queries

Typical scenarios include monitoring the status of import batches, diagnosing rejected rows before they reach the production table, and auditing historical group assignments. A frequently used pattern inspects unresolved records for a run:

  • SELECT REC_NBR, END_USER_ID, USER_GROUP_ID, REC_STATUS, DISPOSITION FROM CZ_IMP_END_USER_GROUP WHERE RUN_ID = :run_id AND REC_STATUS <> 'ACCEPTED' ORDER BY REC_NBR;
  • Reconciling staged rows against live assignments: SELECT i.END_USER_ID, i.USER_GROUP_ID FROM CZ_IMP_END_USER_GROUP i WHERE NOT EXISTS (SELECT 1 FROM CZ_END_USER_GROUPS g WHERE g.END_USER_ID = i.END_USER_ID AND g.USER_GROUP_ID = i.USER_GROUP_ID);
  • Reporting by load window using CREATION_DATE and RUN_ID to track import volume over time.

Reporting extracts generally join to CZ_END_USERS to translate identifiers into recognizable user names.

Related Objects

  • CZ_END_USER_GROUPS — the target table for promoted rows; the primary downstream dependency.
  • CZ_END_USERS — referenced via END_USER_ID; supplies user identity and descriptive attributes.
  • CZ_USER_GROUPS — supplies group definitions for the USER_GROUP_ID value.
  • CZ_IMP_* interface tables — companion staging tables loaded by the same Configurator import programs and sharing RUN_ID semantics.
  • CZ_END_USER_GROUP import/concurrent programs — the executables that read this staging table and write to CZ_END_USER_GROUPS, setting REC_STATUS and DISPOSITION.

Because the table is classified as standalone, its dependency web is shallow: the dominant joins are to CZ_END_USERS and the production CZ_END_USER_GROUPS table.