Search Results convert_instance_cp




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, the package APPS.CZ_MODEL_MIGRATION_PVT is a private (PVT) PL/SQL API belonging to the Oracle Configurator (CZ) product family. Its business function is to orchestrate the migration and publication of Configurator models between a source Configurator Repository and a target instance and repository folder. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner, which is significant for an APPS-owned utility that manipulates repository metadata.

The package exposes a collection of constants and typed arrays that reflect the range of operations it performs: model migration (MODE_MIGRATION 'M'), publication (MODE_PUBLICATION 'P'), and copy (MODE_COPY 'T'), along with source and target flag designators and a change-flag value indicating that an object is unchanged. These constructs support the package's role as the engine behind model migration requests created by developers, which carry a selected list of models, a target instance name, and a target repository folder. The header revision string (120.4.12020000.2) confirms the file was maintained across the 12.1.1 and 12.2.2 codelines.

Key Procedures and Functions

Eleven documented procedures and functions make up the public surface of this package:

  • MIGRATE_MODELS — The primary entry point for model migration. It accepts a migration request identifier, standard locking parameters (user, responsibility, application), and an optional run identifier that is generated internally and returned if not supplied.
  • MIGRATE_MODELS_CP — A concurrent-program wrapper around the migration logic, intended to be invoked from a scheduled concurrent request.
  • ALLOCATE_PERSISTENT_ID — Allocates unique persistent record identifiers used to track migrated configuration entities.
  • UPGRADE_CONFIGS_BY_ITEMS_CP — A concurrent-program routine that upgrades existing configurations based on their associated items.
  • UPGRADE_CONFIGS_BY_PRODUCT_CP — A concurrent-program routine that upgrades configurations by product grouping.
  • CONVERT_INSTANCE_CP — Converts instance-level metadata as part of the migration or publication cycle.
  • OBSOLETE_NONPUBLISHABLE — Marks models or publications that are not publishable as obsolete.
  • TARGET_OPEN_FOR — Determines whether a target repository is open and eligible to receive migration or publication operations.
  • GET_CONVERTED_TARGET — Returns the converted target representation used during migration processing.
  • GET_TARGET_NAME_IF_CONVERTED — Resolves the target name when the target instance has already been converted.
  • GET_PERSISTEN_INTL_TEXT_ID — Retrieves the persistent internationalized text identifier associated with a configuration object.

Tables Accessed

The package reads and writes configuration, publication, and repository metadata through APPS synonyms. CZ_CONFIG_HDRS and CZ_CONFIG_ITEMS hold configuration header and line-item data. CZ_MODEL_PUBLICATIONS and its sequence-backed table CZ_MODEL_PUBLICATIONS_S store publication requests and generated identifiers. CZ_DB_SETTINGS and CZ_SERVERS supply instance and server configuration. CZ_PS_NODES, CZ_MODEL_REF_EXPLS, and CZ_DEVL_PROJECTS provide model structure and development project context. CZ_PERSISTENT_REC_IDS supports persistent identifier allocation. CZ_XFR_RUN_INFOS_S tracks transfer run information, and PLITBLM is the Oracle-supplied PL/SQL table used for temporary storage. DUAL is used for scalar evaluations.

Usage Notes

This is a private package; it is not intended for direct customer invocation. It is referenced by six other packages, which indicates it is called internally by public Configurator APIs and concurrent program drivers. Typical invocation paths include the Oracle Configurator developer UI forms, migration and publication concurrent programs, and repository conversion routines. Custom code should use the supported public Configurator APIs rather than calling CZ_MODEL_MIGRATION_PVT directly, since procedures and signatures may change between releases.