Search Results cz_user_groups




Overview
Explore in AI Chat

Overview

The CZ_USER_GROUPS table is a core data structure within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store definitions for distinct user groups, which are used to manage access and permissions for different categories of users interacting with the configurator runtime. The table's documented description, "Oracle SellingPoint user groups," indicates its origin in the legacy Oracle SellingPoint product, which evolved into Oracle Configurator. Critically, the ETRM metadata explicitly marks this table as "OBSOLETE." This status signifies that while the table exists in the schema for backward compatibility, its active use in new implementations or customizations is discouraged, and it may be subject to removal in future releases.

Key Information Stored

The primary data element stored in this table is the unique identifier for a user group. Based on the provided metadata, the central column is USER_GROUP_ID, which serves as the table's primary key (CZ_USER_GROUPS_PK). This numeric or alphanumeric key uniquely defines each user group record. While the specific ETRM excerpt does not list additional columns, typical columns in such a reference table would likely include a name (e.g., USER_GROUP_NAME), a description, creation dates, and who created it. The singular confirmed and critical piece of information is the USER_GROUP_ID, which acts as a foreign key in related tables to associate specific development projects and end-user sessions with predefined user groups.

Common Use Cases and Queries

Given its obsolete status, direct interaction with this table in new development is not recommended. Its historical use case was to segment users (e.g., internal sales, partners, customers) for applying different configuration rules, UI views, or pricing logic within the Configurator runtime. Common queries would involve joining this table to its related entities to list or audit group assignments. For example, to identify all development projects associated with a specific user group, one might use a query such as:

Reporting would typically focus on understanding the mapping between user groups, development projects, and end-user sessions for support or migration purposes, rather than for building new application logic.

Related Objects

The CZ_USER_GROUPS table has defined foreign key relationships with two other tables in the CZ schema, as documented in the ETRM metadata. These relationships are fundamental to understanding its integration point.

  • CZ_DEVL_PRJ_USER_GROUPS: This table references CZ_USER_GROUPS via the USER_GROUP_ID column. It links user groups to specific configuration development projects, controlling which groups can access or are targeted by a project.
  • CZ_END_USER_GROUPS: This table references CZ_USER_GROUPS via the USER_GROUP_ID column. It links user groups to end-user runtime sessions, determining the functional and data permissions applied during a configuration transaction.

In both relationships, the USER_GROUP_ID in CZ_USER_GROUPS is the referenced primary key, and the same-named column in the foreign tables contains the key values.