Search Results exploretree_error

Overview

APPS.CZ_MIGRATE is a configuration migration package in the Oracle EBS Configurator (CZ) schema. Its role is to move Configurator setup data—UI definitions, UI templates, UI pages, Java rule ad doc chunks, and related cross-reference structures—from a source environment to a target environment, and to synchronize the Database Dictionary objects (tables, columns, primary keys, sequences, and triggers) that back those entities. It is a migration utility rather than a business-transaction API; the majority of its routines exist to compare source and destination metadata, copy rows in bulk, and adjust database objects so the copied setup remains consistent.

The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling schema—normally APPS. The header carries a 2006 release stamp (120.1), indicating the code base has been stable since the early Configurator releases carried forward into 12.1.1 and 12.2.2. It is not referenced by any other package, which confirms it is intended for direct invocation from a concurrent program, a menu-driven form, or a controlled SQL*Plus session run by a system administrator.

Key Procedures and Functions

The entry point is migrate_setup, which accepts an in/out run identifier, a local name, and a force-run flag, and returns an integer status. It coordinates the overall migration and delegates to migrate.

• compare_versions, compare_columns, compare_pk_columns — compare source and target object definitions before copying.
• get_table_columns, get_table_pk_columns — resolve column and primary-key column lists from data dictionary views.
• copy_table, copy_table_override, copy_all_tables — move table data, with an override path for special handling.
• copy_table_slowmode, copy_table_fastmode, copy_table_fastnorefresh, copy_table_fastrefresh — performance variants of the copy operation.
• disable_triggers, enable_triggers — suppress and restore row triggers around bulk loads.
• adjust_sequence, adjust_all_sequences — reset sequence values to match copied data.
• report, setup_migration_cp — emit migration output and provide the concurrent-program wrapper.

The package also declares EXPLORETREE_ERROR, initialized with PRAGMA EXCEPTION_INIT to Oracle error -20001. This is the exception raised when Configurator Explorer tree structures fail validation during migration, and it is the term most commonly associated with this package in support searches.

Tables Accessed

Migration targets include CZ_UI_DEFS, CZ_UI_TEMPLATES, CZ_UI_PAGES, CZ_JRAD_CHUNKS, CZ_DB_SETTINGS, CZ_SERVERS, CZ_XFR_TABLES, and CZ_XFR_RUN_INFOS_S, which hold the run transaction records. Dictionary references use USER_TAB_COLUMNS, USER_CONS_COLUMNS, USER_TRIGGERS, ALL_TABLES, ALL_TAB_COLUMNS, ALL_CONSTRAINTS, and ALL_CONS_COLUMNS, reached through APPS synonyms.

Usage Notes

Invoke CZ_MIGRATE through the Configurator migration concurrent program (setup_migration_cp) or from an administrator session, typically during environment cloning or patch promotion. Because it disables triggers and rewrites sequences, run it in a maintenance window with the Configurator application offline. Investigate EXPLORETREE_ERROR (-20001) as a data integrity fault in the Explorer tree definition rather than a code defect.