Search Results owner_migrate_update_hashcode

Overview

DBMS_OBJECTS_APPS_UTILS is a SYS-owned PL/SQL package that forms part of the object management infrastructure underpinning Oracle E-Business Suite. Its primary responsibility is the maintenance and synchronization of stored schema object definitions — particularly PL/SQL type, package, and source definitions — across the EBS database. In the context of Oracle EBS 12.1.1 and 12.2.2, this package supports operations that must reconcile object metadata during patching, upgrades, cloning, and online patching (adop) phases, where objects may be moved between schemas or require recompilation following dependency changes. The package is declared with AUTHID DEFINER, meaning it executes with the privileges of its owner (SYS), allowing it to perform privileged DDL and metadata operations that ordinary APPS-schema sessions cannot execute directly. The metadata classifies the API as "OTHER," indicating it is an internal utility rather than a public application programming interface exposed to end users or standard concurrent processing. The presence of the RECOMPILE_TYPES routine, which the user queried under the search term "recompile_types," reflects the package's role in resolving invalid type definitions that arise when underlying dependencies change.

Key Procedures and Functions

• UPDATE_TYPES — Updates type definitions between two schemas, accepting parameters that identify the source schema, target schema, type name, and a boolean flag controlling whether the update is checked. It is used to propagate or refresh type metadata across schema boundaries.
• SPLIT_SOURCE — A function that parses a source definition into a structured collection of source lines, returning a numeric status and populating an OUT parameter of the DBMS_OBJECTS_UTILS_TSOURCE type. It supports source-line handling during object migration or comparison.
• RECOMPILE_TYPES — Accepts a collection of type names (DBMS_OBJECTS_UTILS_TNAMEARR) and recompiles the corresponding type definitions, resolving invalid or stale objects after dependency changes. This is the routine surfaced by the "recompile_types" search.
• OWNER_MIGRATE_UPDATE_TDO — Updates the stored type definition object (TDO) to reflect a new owner, taking a raw object identifier and the new owner schema name. It is invoked during ownership migration scenarios.
• OWNER_MIGRATE_UPDATE_HASHCODE — A function that recomputes and returns an updated hash code for a migrated type definition object, given its raw object identifier. It preserves metadata integrity when ownership changes.

Tables Accessed

The documented ETRM metadata does not enumerate specific tables referenced through APPS synonyms. However, the package's function of reading and updating type and source definitions implies access to the underlying data dictionary views and object metadata repositories, such as those supporting DBA_SOURCE, ALL_TYPES, and the EBS object migration tracking structures. Because the package operates under SYS with definer's rights, it can read and modify dictionary base tables directly.

Usage Notes

DBMS_OBJECTS_APPS_UTILS is an internal utility and is not intended for direct invocation by application users or standard concurrent programs. It is typically called by other EBS infrastructure packages and by AD utilities during patching, upgrade, cloning, and online patching operations when type definitions require synchronization or recompilation. The metadata records that the package is referenced by one other package, confirming its role as a dependency of higher-level object management code. Custom code should not call this package directly; doing so bypasses supported interfaces and risks inconsistent metadata. Administrators encountering invalid type objects should rely on documented AD and adpatch utilities rather than invoking RECOMPILE_TYPES manually.