Search Results cz_rp_entries_u1




Overview
Explore in AI Chat

Overview

The CZ_RP_ENTRIES table is a core repository table within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a central registry or catalog for objects managed by the Configurator Developer toolset. This table does not store the detailed definition of configuration models or components itself; instead, it maintains essential metadata that enables the organization, identification, and retrieval of these objects from the broader repository. Its primary role is to support the object management framework within the Configurator environment, providing a unified structure for querying and relating different Configurator entities.

Key Information Stored

The table's structure is designed to uniquely identify and categorize repository items. The critical columns, as defined by its primary keys, are OBJECT_TYPE and OBJECT_ID. The OBJECT_TYPE classifies the kind of Configurator entity, such as a model or project, while the OBJECT_ID is a unique numeric identifier for that specific instance. An alternative unique key (CZ_RP_ENTRIES_U1) includes ENCLOSING_FOLDER and NAME, indicating the table also tracks an object's hierarchical location within the repository's folder structure and its descriptive name. This combination allows the system to enforce unique naming within a given folder and object type.

Common Use Cases and Queries

A primary use case is generating inventories or reports of Configurator objects for administrative or migration purposes. Developers and administrators frequently query this table to understand the scope and organization of the configuration repository. Common SQL patterns include listing all objects of a specific type, finding objects within a particular folder, or joining to detailed tables to create comprehensive object reports. For example, to list all development projects with their repository metadata, one might execute:

  • SELECT rp.NAME, rp.ENCLOSING_FOLDER, dp.* FROM CZ_RP_ENTRIES rp, CZ_DEVL_PROJECTS dp WHERE rp.OBJECT_ID = dp.DEVL_PROJECT_ID AND rp.OBJECT_TYPE = 'PROJECT';

This table is also integral to the functioning of the Configurator Developer user interface, where it facilitates browsing and searching the repository tree.

Related Objects

As a central registry, CZ_RP_ENTRIES has defined foreign key relationships with other core Configurator tables, using its OBJECT_ID as the link to the detailed data. Based on the provided metadata, the documented relationships are:

  • CZ_DEVL_PROJECTS: The foreign key CZ_RP_ENTRIES.OBJECT_ID references CZ_DEVL_PROJECTS. This links a repository entry of type 'PROJECT' to its full definition in the development projects table.
  • CZ_MODEL_USAGES: The foreign key CZ_RP_ENTRIES.OBJECT_ID references CZ_MODEL_USAGES. This links a repository entry (typically for a model or component) to its usage definitions, which control how models are instantiated and configured.

These relationships confirm that CZ_RP_ENTRIES is a parent table for key Configurator entities, and its OBJECT_ID column is reused as the primary key in these child detail tables.