Search Results cz_devl_projects

Overview

The CZ_DEVL_PROJECTS table is the core master data repository for a configurator model or project within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the foundational record for every configurable product model developed in the Configurator Developer (CZ Developer) environment. Each row uniquely identifies a model, acting as the central hub from which all related configuration data—including components, rules, user interfaces, and logic—is organized and referenced. Its integrity is critical for the entire configuration lifecycle, from model development and publication to runtime execution in order management or other transactional systems.

Key Information Stored

While the provided metadata focuses on relationships, the primary and unique keys indicate the essential columns for identification and data integrity. The table's primary key is DEVL_PROJECT_ID, a unique system-generated identifier for each model. The unique key constraint (CZ_DEVL_PROJECTS_U1) also includes LAST_UPDATE_DATE and DELETED_FLAG, highlighting the importance of tracking model modifications and supporting soft-delete functionality. Other significant columns, typical for such master tables in EBS, include CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, and NAME or DESCRIPTION fields for the model. The foreign key relationship to CZ_INTL_TEXTS via INTL_TEXT_ID suggests the table supports multilingual descriptions for the model project.

Common Use Cases and Queries

This table is central to administrative, diagnostic, and integration tasks. Common use cases include auditing all configurator models in the system, identifying models pending publication, and generating reports for model inventory. A fundamental query retrieves a list of active models:

• SELECT devl_project_id, name, creation_date, last_update_date FROM cz_devl_projects WHERE deleted_flag = '0';

For troubleshooting, developers often join this table to related entities to understand a model's complete structure or to identify rules and UI definitions associated with a specific project ID. Integration scripts may query this table to validate the existence of a model before processing related data extracts or imports.

Related Objects

The CZ_DEVL_PROJECTS table has extensive foreign key relationships, underscoring its role as the master table for the Configurator module. Key documented relationships include:

• CZ_RULES & CZ_RULE_FOLDERS: Stores all business rules and their organizational folders for the model (joins on DEVL_PROJECT_ID).
• CZ_UI_DEFS & CZ_GRID_DEFS: Contains user interface definitions and layout grids for the model (joins on DEVL_PROJECT_ID).
• CZ_PS_NODES: The primary table for the model structure (Product Structure Nodes), linked both as a reference and directly via DEVL_PROJECT_ID.
• CZ_MODEL_PUBLICATIONS: Tracks publication events of the model to runtime (joins on MODEL_ID).
• CZ_EXPRESSIONS & CZ_FUNC_COMP_SPECS: Holds the logical expressions and functional component specifications defining model behavior (joins on DEVL_PROJECT_ID).
• CZ_DEVL_PRJ_USER_GROUPS: Manages security and access control for the development project (joins on DEVL_PROJECT_ID).