Results for “root_model_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_PB_MODEL_EXPORTS is a Configurator (CZ) module table in the Oracle E-Business Suite schema CZ. It records the export history of configurator models — the act of publishing a model from a development project to a target server or publication, along with the sequence and status of each transfer. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table serves as the operational log linking a model definition to its destination environment, enabling the Configurator runtime to track which version of a model has been propagated and whether it has been superseded.

Under a heuristic Data Vault classification mined from its foreign-key structure, CZ_PB_MODEL_EXPORTS is best modeled as a link entity. It does not hold a single natural business entity of its own; instead it associates multiple hubs — model, root model, server, and publication — while also carrying descriptive attributes such as status and transfer timestamps. This link classification is a modeling suggestion derived from the FK topology rather than a formally declared Data Vault construct.

Key Information Stored

The table is defined with sixteen documented columns. Its composite primary key, enforced by the unique index CZ_PB_MODEL_EXPORTS_PK, is (EXPORT_ID, EXPORT_SEQ). EXPORT_ID is the surrogate identifier for an export event, while EXPORT_SEQ disambiguates multiple sequential operations within that event — the column the user searched for, and the reason the pair rather than EXPORT_ID alone forms the business-key candidate.

• MODEL_ID — the configurator model being exported; FK to CZ_DEVL_PROJECTS.
• ROOT_MODEL_ID — the top-level model in the hierarchy; also FK to CZ_DEVL_PROJECTS, supporting related-model exports.
• SERVER_ID — target server for the export; FK to CZ_SERVERS.
• PUBLICATION_ID — the publication context; FK to CZ_MODEL_PUBLICATIONS.
• REMOTE_MODEL_ID — identifier assigned to the model on the remote target.
• EXPORT_REVERSE_SEQ — sequence used for reverse or rollback export ordering.
• STATUS — current state of the export operation.
• SUPERSEDED_FLAG — indicates whether this export has been replaced by a later one.
• LAST_XFR_ACTIVITY — timestamp of the most recent transfer activity.
• MIGRATION_GROUP_ID — groups exports belonging to a single migration batch.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard EBS who-columns for traceability.

Common Use Cases and Queries

Typical usage centers on audit and reconciliation of model deployments. Administrators query the table to confirm that a model reached its target server, to detect exports marked superseded, or to reconstruct migration batches.

• List exports for a model: SELECT export_id, export_seq, server_id, status FROM cz_pb_model_exports WHERE model_id = :model_id ORDER BY creation_date DESC;
• Find active (non-superseded) exports: WHERE superseded_flag = 'N'.
• Track a migration batch: WHERE migration_group_id = :group_id.
• Join to CZ_SERVERS for target-name reporting, and to CZ_DEVL_PROJECTS for model names.

Related Objects

Four documented foreign keys define the table's principal relationships; these reference tables are the most significant dependents and join partners.

• CZ_DEVL_PROJECTS — joined via MODEL_ID and ROOT_MODEL_ID; supplies model and root-model definitions.
• CZ_SERVERS — joined via SERVER_ID; identifies the export target server.
• CZ_MODEL_PUBLICATIONS — joined via PUBLICATION_ID; defines the publication that governs the export.
• Index CZ_PB_MODEL_EXPORTS_PK — the unique index implementing the composite primary key.

Together these objects place the exports log squarely within the Configurator model-publication and deployment workflow.