Results for “cz_src_model_publications_v”

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

Overview

CZ_SRC_MODEL_PUBLICATIONS_V is an APPS-owned database view in the Oracle E-Business Suite Configurator (CZ) product. It presents a filtered, publication-oriented projection of the CZ_MODEL_PUBLICATIONS table, exposing the runtime publication records that drive Configurator user interfaces, model deployments, and item-based configuration contexts. In EBS 12.1.1 and 12.2.2, this view plays a role in reporting and integration scenarios where external processes, concurrent programs, or custom extensions must resolve which published model configuration applies to a given organization, top-level item, or product key.

The view carries a VALID status and resides in the APPS schema, consistent with standard EBS conventions in which public synonyms expose APPS objects to application and reporting users. The view name carries the "_V" suffix typical of EBS views and is referenced in the ETRM (E-Business Suite Technical Reference Manual) as a configurator source object.

Underlying Base Objects

The documented base object is CZ_MODEL_PUBLICATIONS, referenced through a SYNONYM. The view is defined as a SELECT over that table with three restrictive predicates:

• DELETED_FLAG = '0' — excludes logically deleted publication rows.
• OBJECT_TYPE = 'PRJ' — restricts results to project (model) publications rather than other configurable object types.
• SOURCE_TARGET_FLAG = 'S' — limits rows to source-side publications, distinguishing them from target-side records used in distribution scenarios.

Because these filters are embedded in the view definition, consumers automatically receive only active, source-side, project-type publications without needing to restate the predicates themselves.

Key Columns

The view exposes the following columns from CZ_MODEL_PUBLICATIONS:

• PUBLICATION_ID — primary identifier of the publication record; also rendered in the column list as OBJECT_ID in some documentation contexts.
• MODEL_ID — the model (configuration model) associated with the publication.
• SERVER_ID — the Configurator server instance handling the publication.
• ORGANIZATION_ID — the inventory organization context for the publication, enabling multi-org filtering.
• TOP_ITEM_ID — the top-level model item that the publication represents; this is the column most relevant to item-driven configuration lookups and the object of the user's search.
• PRODUCT_KEY — key identifying the product context.
• PUBLICATION_MODE — indicates the mode under which the model is published.
• UI_DEF_ID, UI_STYLE, PAGE_LAYOUT, CONTAINER — UI definition and presentation attributes for the generated Configurator user interface.
• APPLICABLE_FROM / APPLICABLE_UNTIL — date-effective bounds governing when the publication is valid.
• EXPORT_STATUS — status of the publication export process.
• DISABLED_FLAG — indicates whether the publication is administratively disabled.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical use cases include resolving the publication associated with a specific top item in an organization, diagnosing missing or disabled Configurator UI publications, and integrating item-driven configuration data into custom reports or external systems.

Query by top item and organization:

• SELECT publication_id, model_id, top_item_id, organization_id, publication_mode, disabled_flag FROM cz_src_model_publications_v WHERE top_item_id = :p_top_item_id AND organization_id = :p_org_id;

List active publications with their UI definitions:

• SELECT publication_id, model_id, top_item_id, ui_def_id, applicable_from, applicable_until FROM cz_src_model_publications_v WHERE disabled_flag = 'N' AND SYSDATE BETWEEN applicable_from AND NVL(applicable_until, SYSDATE + 1);

Join to model metadata using MODEL_ID or TOP_ITEM_ID to enrich reporting, keeping in mind that ORGANIZATION_ID filtering is required in multi-org environments. Because the view already excludes deleted, target-side, and non-project rows, it is generally the preferred access path for source-side project publication reporting.