Search Results cz_pb_model_exports




Overview
Explore in AI Chat

Overview

The CZ_PB_MODEL_EXPORTS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a model-exports table, serving as a transactional log and status repository for the export operations of configurator models. When a configurator model is published or prepared for runtime execution, the system generates export records in this table. These records are critical for managing the lifecycle of configurator data, tracking the deployment of model updates, and ensuring the correct runtime version is available to end-user applications, such as Oracle Order Management or iStore.

Key Information Stored

The table's primary key is a composite of EXPORT_ID and EXPORT_SEQ, indicating it tracks multiple steps or sequences within a single export operation. Based on its documented foreign key relationships, the table stores identifiers that link an export record to other essential Configurator entities. The MODEL_ID and ROOT_MODEL_ID columns reference the CZ_DEVL_PROJECTS table, identifying the specific model and its root project being exported. The PUBLICATION_ID links to the CZ_MODEL_PUBLICATIONS table, connecting the export to a specific publication event. The SERVER_ID column references the CZ_SERVERS table, which likely denotes the target or source application server for the exported model data, facilitating deployment management.

Common Use Cases and Queries

This table is primarily used for administrative monitoring, troubleshooting, and auditing of the configurator publication process. Common scenarios include verifying the success of a model publication, identifying the most recent export for a given model, or diagnosing publication failures by examining export sequences. A typical query would join to related tables to get a comprehensible status report:

  • Tracking recent exports for a specific model: SELECT exp.* FROM cz_pb_model_exports exp, cz_devl_projects proj WHERE exp.model_id = proj.dev_project_id AND proj.name = 'MODEL_X' ORDER BY exp.export_id DESC;
  • Investigating a failed publication by checking for incomplete export sequences for a given PUBLICATION_ID.
  • Generating an audit report of all model deployments to specific servers over a time period.

Related Objects

The CZ_PB_MODEL_EXPORTS table is centrally connected to several key Configurator tables through defined foreign key constraints:

  • CZ_MODEL_PUBLICATIONS: Joined via CZ_PB_MODEL_EXPORTS.PUBLICATION_ID. This links the export record to the overarching publication transaction.
  • CZ_DEVL_PROJECTS (twice): Joined via CZ_PB_MODEL_EXPORTS.MODEL_ID and CZ_PB_MODEL_EXPORTS.ROOT_MODEL_ID. These relationships connect the export to the specific model and its root development project.
  • CZ_SERVERS: Joined via CZ_PB_MODEL_EXPORTS.SERVER_ID. This associates the export operation with a target application server instance in the environment.