Search Results end_user_id




Overview
Explore in AI Chat

Overview

The CZ_END_USER_GROUPS table is a core intersection table within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a critical data structure for managing the many-to-many relationship between end users and user groups, a foundational concept for access control and functional permissions within the Configurator runtime environment. This table is essential for the Oracle SellingPoint framework, enabling the assignment of specific configuration models, rules, and user interfaces to defined groups of users. Its primary role is to link individual end-user identities with collective security and functional groups, thereby controlling which configuration experiences and data are available to different user populations.

Key Information Stored

The table's structure is purposefully simple, consisting of two key foreign key columns that form a composite primary key. The END_USER_ID column stores a unique identifier that references a specific end-user record in the CZ_END_USERS table. The USER_GROUP_ID column stores a unique identifier that references a specific user group definition in the CZ_USER_GROUPS table. The combination of these two columns (CZ_END_USER_GROUPS_PK) enforces data integrity by ensuring that a single user cannot be assigned to the same group more than once. No other descriptive columns are present, as all descriptive attributes for users and groups are maintained in their respective parent tables.

Common Use Cases and Queries

A primary use case is auditing and administering user group memberships. System administrators or support personnel frequently query this table to generate reports on which users belong to specific groups, or to list all groups assigned to a particular user. This is vital for troubleshooting access issues or performing security reviews. Common SQL patterns include listing all users in a group by name, or finding all groups for a given user. For example, to find all groups for a user with a specific login name, a query would join CZ_END_USER_GROUPS to CZ_END_USERS (on END_USER_ID) and CZ_USER_GROUPS (on USER_GROUP_ID). Another critical operational use case is during the runtime loading of a configuration model, where the application queries this table to determine the effective set of rules and UI properties applicable to the current user based on their group affiliations.

Related Objects

The CZ_END_USER_GROUPS table maintains explicit foreign key relationships with two parent tables, as documented in the provided ETRM metadata. These relationships are fundamental to its purpose and data integrity.

  • CZ_END_USERS: The foreign key from CZ_END_USER_GROUPS.END_USER_ID references the primary key in the CZ_END_USERS table. This table contains the master list of all end users known to the Configurator, storing details such as login names and descriptive information.
  • CZ_USER_GROUPS: The foreign key from CZ_END_USER_GROUPS.USER_GROUP_ID references the primary key in the CZ_USER_GROUPS table. This table defines the various user groups used to segment and control access for different sets of end users within the configuration environment.

Any data manipulation on this intersection table is dependent on the existence of corresponding records in these two parent tables.