Search Results cz_model_publications_u1




Overview
Explore in AI Chat

Overview

The CZ_MODEL_PUBLICATIONS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. It serves as the master repository for published configuration models. In the context of Oracle Configurator, a publication is the final, executable version of a configuration model that has been prepared for deployment to end-users, typically via the Oracle Configurator runtime (CZ). Each row in this table represents a specific published instance of a TOP model, which is the highest-level model in a configuration hierarchy. This table is critical for managing the lifecycle of configurator models, from development and testing to production deployment, across both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is PUBLICATION_ID, which uniquely identifies each publication record. According to the provided metadata, the table also enforces a unique constraint (CZ_MODEL_PUBLICATIONS_U1) on the combination of PUBLICATION_ID, DELETED_FLAG, and MODEL_ID, which supports logical deletion and versioning patterns. Essential foreign key columns link the publication to its source components: MODEL_ID references the CZ_DEVL_PROJECTS table to identify the source model, UI_DEF_ID references CZ_UI_DEFS for the associated user interface definition, and SERVER_ID references CZ_SERVERS. The DELETED_FLAG column is a standard indicator for soft-delete functionality, marking a publication as inactive without physically removing the record.

Common Use Cases and Queries

A primary use case is auditing and reporting on the deployment history of configurator models. Administrators can query this table to list all publications for a given model or project, determine the most recent publication, or identify publications used in specific environments. A common query retrieves active publications for a model: SELECT * FROM cz.cz_model_publications WHERE model_id = :model_id AND deleted_flag = '0';. Another typical scenario involves joining with CZ_DEVL_PROJECTS to get the project name: SELECT p.name, m.publication_id, m.creation_date FROM cz.cz_model_publications m, cz.cz_devl_projects p WHERE m.model_id = p.devl_project_id AND m.deleted_flag = '0' ORDER BY m.creation_date DESC;. This data is also essential for runtime resolution, where the Configurator engine uses the publication record to load the correct model and UI definition.

Related Objects

The CZ_MODEL_PUBLICATIONS table has integral relationships with several other Configurator tables, as documented by its foreign keys. It is a parent table to:

It is a child table referencing:
  • CZ_DEVL_PROJECTS (via MODEL_ID)
  • CZ_SERVERS (via SERVER_ID)
  • CZ_UI_DEFS (via UI_DEF_ID)
These relationships form a network where the publication record acts as a central hub, connecting the source model and UI design to its various runtime deployments, client applications, supported languages, and usage logs.