Results for “cz_user_groups”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_USER_GROUPS is a table in the CZ schema belonging to the Oracle Configurator (CZ) product family. The ETRM metadata describes it explicitly as OBSOLETE — Oracle SellingPoint user groups. This designation is significant: the table was introduced to support SellingPoint, an earlier Oracle selling and configuration application, and is no longer an active functional component in Oracle E-Business Suite Release 12.1.1 or 12.2.2. It is retained in the schema for upgrade continuity and referential integrity, but no current Configurator or SellingPoint business flow depends on it for live processing.

The table defines user groups that governed access to configuration models and related authoring objects. Each row carries both identity attributes (name, description) and a set of authorization flags controlling read, create, update, and delete privileges, along with configuration-change permissions and discount limits.

From a Data Vault modeling perspective, the mined FK structure classifies CZ_USER_GROUPS as hub-leaning. As a modeling suggestion, it behaves as a hub: the primary key USER_GROUP_ID is a stable business key referenced by two dependent link/association tables, which is the classic hub pattern.

Key Information Stored

The table contains 20 documented columns. The most important include:

• USER_GROUP_ID — surrogate primary key, enforced via CZ_USER_GROUPS_PK. This is the sole column in the unique index and serves as the business-key candidate for downstream relationships.
• GROUP_NAME and GROUP_DESC — human-readable identity and description of the user group.
• READ_AUTH, CREATE_AUTH, UPDATE_AUTH, DELETE_AUTH — authorization flags defining the group's CRUD privileges.
• ALLOW_CONFIG_CHANGES — flag indicating whether members may alter configuration definitions.
• USER_GROUP_DISC_LIMIT — discount ceiling applied to the group.
• DELETED_FLAG — soft-delete indicator rather than physical removal.
• EFF_FROM, EFF_TO, EFF_MASK — date-effective range controls.
• SECURITY_MASK — bitmask governing security scope.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• CHECKOUT_USER — identifies the user holding a checkout lock on the group definition.

The surrogate key is USER_GROUP_ID; no separate secondary unique index is documented, so GROUP_NAME is not enforced as unique by the schema.

Common Use Cases and Queries

Because the table is obsolete, live application use cases are largely historical. Practical query patterns are diagnostic and migration-oriented. A typical lookup retrieves the group identity and privilege flags:

• SELECT USER_GROUP_ID, GROUP_NAME, READ_AUTH, CREATE_AUTH, UPDATE_AUTH, DELETE_AUTH FROM CZ.CZ_USER_GROUPS WHERE DELETED_FLAG = 'N';
• Date-effective filtering: WHERE EFF_FROM <= SYSDATE AND (EFF_TO IS NULL OR EFF_TO > SYSDATE).
• Audit/reporting on stale or orphaned rows: join to CZ_END_USER_GROUPS and CZ_DEVL_PRJ_USER_GROUPS to determine whether a group is still referenced before archiving.
• Legacy migration validation: count groups with populated SECURITY_MASK or USER_GROUP_DISC_LIMIT to assess data quality before decommissioning.

Reporting should restrict to soft-deleted exclusions and treat any results as historical reference only.

Related Objects

The documented foreign-key relationships show two dependent tables that reference CZ_USER_GROUPS through the USER_GROUP_ID column:

• CZ_DEVL_PRJ_USER_GROUPS — associates user groups with development projects via CZ_DEVL_PRJ_USER_GROUPS.USER_GROUP_ID.
• CZ_END_USER_GROUPS — associates end-user memberships via CZ_END_USER_GROUPS.USER_GROUP_ID.

Both are child/association tables that depend on the hub record. When validating or purging legacy data, these two relations are the primary referential checks; any dependent rows must be reconciled before CZ_USER_GROUPS records are archived. No additional documented objects reference this table in the supplied metadata.