Search Results enable_publication

Overview

CZ_PB_MGR is the publication management engine within the Oracle EBS Configurator (CZ) module, responsible for controlling how configuration models and user interface definitions are published from a source environment to one or more target environments. The package header declares an extensive set of package-level variables and a custom exception, EXPLORETREE_ERROR, initialized via PRAGMA EXCEPTION_INIT to error number -20001. This exception is raised internally when the explore-tree logic cannot proceed, and the header comments explicitly document the use of DBMS_STANDARD.RAISE_APPLICATION_ERROR for surfacing user-defined errors—particularly to handle remote exceptions returned from INSERT_JRAD_DOC across database links.

Functionally, CZ_PB_MGR orchestrates the lifecycle of a publication: selecting a root model, verifying that the model is current, generating sequence identifiers, copying model hierarchies, exporting UI definitions, and tracking export status through the CZ_MODEL_PUBLICATIONS and CZ_PB_MODEL_EXPORTS tables. It supports both single-model and bulk publication flows, and it participates in republish scenarios where an existing publication must be refreshed.

Key Procedures and Functions

• SEQUENCE_GENERATE — Produces unique identifiers used when materializing publication and export records.
• PUBLISH_MODEL / PUBLISH_ALL_MODELS / PUBLISH_SINGLE_MODEL_CP / PUBLISH_MODELS_CP — Drive the publication process for a single model, all eligible models, or via concurrent-program entry points.
• MODEL_UPTO_DATE / IS_UI_UPTO_DATE — Evaluate whether a model or UI definition has changed since its last publication, gating unnecessary exports.
• DEEP_MODEL_COPY — Performs recursive copies of model hierarchies, including child model references recorded in CZ_MODEL_REF_EXPLS.
• CHECK_PUBLICATION_OVERLAP — Detects conflicting or overlapping publication ranges before enabling a publication.
• EDIT_PUBLICATION / EDIT_TGT_PUB — Maintain publication and target-publication attributes.
• ENABLE_PUBLICATION / DISABLE_PUBLICATION / DELETE_PUBLICATION — Control publication state. DISABLE_PUBLICATION is the procedure most commonly associated with the "disable_publication" search term and is used to suspend an active publication without removing its definition.
• REPUBLISH_MODEL / CREATE_REPUBLISH_PUBLICATION — Re-issue an existing publication, creating the necessary republish record.
• LOG_PB_ERRORS / RESET_PROCESSING_PUBS — Manage error capture and clear stale "processing" status flags.
• RETRIEVE_DB_LINK — Resolves the database link used for remote publication targets.
• EXPORT_SINGLE_OA_UI — Exports a single OA framework UI definition as part of the publication payload.

Tables Accessed

Publication state is persisted primarily in CZ_MODEL_PUBLICATIONS, CZ_PB_MODEL_EXPORTS, and CZ_MODEL_REF_EXPLS, which together record the root model, target servers, export identifiers, and child model references. Configuration content is read from CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, CZ_ITEM_TYPES, CZ_PROPERTIES, CZ_PS_NODES, CZ_PS_PROP_VALS, CZ_DEVL_PROJECTS, CZ_EXPRESSIONS, CZ_LCE_TEXTS, and CZ_MODEL_USAGES. CZ_SERVERS supplies server names used to build database links, while CZ_DB_LOGS and CZ_DB_SETTINGS provide logging and environment configuration.

Usage Notes

CZ_PB_MGR is invoked from the Configurator publication forms, from concurrent programs that publish a single model or an entire set of models, and from custom code that needs to enable, disable, edit, or delete a publication record. Because the package is referenced by eight other packages, changes to its signatures or semantics can ripple across the Configurator publication subsystem. When disabling a publication via DISABLE_PUBLICATION, callers should ensure no in-flight publication jobs remain, since RESET_PROCESSING_PUBS may otherwise be required to clear stale processing flags before a subsequent enable or republish.