Search Results cz_devl_prj_usr_grp_pk




Overview
Explore in AI Chat

Overview

The CZ_DEVL_PRJ_USER_GROUPS table is a junction table within the Oracle E-Business Suite Configurator (CZ) module. Its primary function is to manage the many-to-many relationship between development projects and user groups. This association was used to control access and assignment of specific configuration projects to defined sets of users, typically within the context of the Model Developer Application (MDApp). It is critical to note that the official product documentation explicitly marks this table as OBSOLETE. This status indicates that while the table may still exist in the database schema for upgrade and compatibility reasons, its functional use in current implementations of Oracle EBS 12.1.1 and 12.2.2 is deprecated, and new customizations should avoid direct dependencies on it.

Key Information Stored

The table's structure is minimal, serving purely as an associative entity. It contains only two significant columns, which together form its composite primary key. The DEVL_PROJECT_ID column stores a foreign key reference to a specific configuration development project defined in the CZ_DEVL_PROJECTS table. The USER_GROUP_ID column stores a foreign key reference to a user group defined in the CZ_USER_GROUPS table. Each unique combination of these two IDs represents a single permission assignment, linking one project to one user group. The table lacks descriptive columns, as its sole purpose is to maintain this relationship.

Common Use Cases and Queries

Given its obsolete status, direct operational use cases in active development are strongly discouraged. Historically, its purpose was to support security and access control models for configuration project development. Typical queries would have involved identifying which user groups had access to a particular project or listing all projects assigned to a specific user group. A sample analytical query to retrieve this information, for legacy reporting or audit purposes, might resemble the following pattern:

  • SELECT p.PROJECT_NAME, ug.NAME AS USER_GROUP_NAME FROM cz.CZ_DEVL_PRJ_USER_GROUPS assoc JOIN cz.CZ_DEVL_PROJECTS p ON assoc.DEVL_PROJECT_ID = p.DEVL_PROJECT_ID JOIN cz.CZ_USER_GROUPS ug ON assoc.USER_GROUP_ID = ug.USER_GROUP_ID ORDER BY p.PROJECT_NAME;

Any new functionality requiring similar assignment logic should utilize supported APIs and data models provided by Oracle.

Related Objects

The table's existence is defined entirely by its relationships with two core Configurator tables, as documented by its foreign key constraints. It is a child table to both CZ_DEVL_PROJECTS and CZ_USER_GROUPS. The integrity of the data in CZ_DEVL_PRJ_USER_GROUPS is dependent on the existence of corresponding records in these parent tables.

  • CZ_DEVL_PROJECTS: The primary parent table for configuration development projects. The CZ_DEVL_PRJ_USER_GROUPS.DEVL_PROJECT_ID column references the CZ_DEVL_PROJECTS.DEVL_PROJECT_ID primary key.
  • CZ_USER_GROUPS: The primary parent table for defining user groups within the Configurator module. The CZ_DEVL_PRJ_USER_GROUPS.USER_GROUP_ID column references the CZ_USER_GROUPS.USER_GROUP_ID primary key.

The table itself has a primary key constraint named CZ_DEVL_PRJ_USR_GRP_PK on the (DEVL_PROJECT_ID, USER_GROUP_ID) columns, enforcing the uniqueness of each project-to-user-group assignment.