Search Results rec_count




Overview
Explore in AI Chat

Overview

APPS.CZ_PB_MGR is the core publication manager package body within the Oracle E-Business Suite product information management and ETRM (Enterprise Trade and Regulatory Management) schema. Its primary business function is to manage the creation, validation, publication, and lifecycle control of runtime models that are generated from design-time definitions. In Oracle EBS 12.1.1 and 12.2.2, this package orchestrates the transformation of configuration and rules data held in the design-time tables into consumable runtime structures, controls which publications are active, and maintains synchronization between source models and their published targets. It also performs identifier resolution and export handling for UI components and object attribute definitions.

Key Procedures and Functions

The package exposes 63 documented procedures and functions. The principal entries include:

The body also defines helper constants and identifier-resolution fields (PSNREFID, RULCOMID, UINREFID, IGNOREID) used when resolving references such as cz_ps_nodes.reference_id, cz_rules.rule_folder_id, and UI node references.

Tables Accessed

All referenced tables are accessed through APPS synonyms and include:

Usage Notes

CZ_PB_MGR is typically invoked from Oracle Forms (including administrator and publication management forms), from concurrent programs such as the publish and republish model concurrent processes, and from custom or extension code that needs to drive publication programmatically. Error handling is channeled through the LOG_PB_ERRORS routine and CZ_DB_LOGS, so callers should expect detailed error records rather than relying solely on raised exceptions. Because the package performs deep model copies and cross-reference resolution, it is sensitive to the state of CZ_MODEL_PUBLICATIONS and related design-time tables; RESET_PROCESSING_PUBS and CHECK_PUBLICATION_OVERLAP should be used to recover or validate before re-invoking publication. Eight other packages reference this body, so changes to its documented interfaces can affect dependent publication and export logic.