Search Results dbms_objects_utils_tname

Overview

SYS.DBMS_OBJECTS_APPS_UTILS is a SYS-owned PL/SQL package body shipped with the Oracle Database and used within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack. It is a utility package that supports the Oracle object-type infrastructure used by EBS, particularly the management and recompilation of object types and their generated source. Its role is administrative rather than business-functional: it assists the database in maintaining the integrity of object type definitions, their generated code, and the type metadata that EBS relies upon in the data dictionary.

In the EBS environment, many framework and application components depend on object types (TDOs) and their associated type bodies. Over time these can become invalidated by patches, upgrades, or changes to dependent objects. This package provides the internal plumbing required to split, update, recompile, and migrate type metadata so that object types remain valid and consistent with the dictionary. As a SYS-owned package body, it is not an application-facing API and is not intended for direct use by EBS developers or end users.

Key Procedures and Functions

Five documented units are exposed by this package. Each is oriented toward type maintenance and recompilation.

• UPDATE_TYPES — Updates object type definitions in the dictionary, refreshing type metadata to reflect current definitions.
• SPLIT_SOURCE — Splits type source text into discrete elements, supporting the processing of type and type body source by the utilities in this package.
• RECOMPILE_TYPES — Recompiles invalid object types, restoring them to a valid state after dependency changes such as patching or upgrades.
• OWNER_MIGRATE_UPDATE_TDO — Handles migration-related updates to type definitions (TDOs) when ownership or schema context changes.
• OWNER_MIGRATE_UPDATE_HASHCODE — Updates the stored hash code associated with a migrated type definition to keep it consistent with the current source.

No parameter signatures are documented in the ETRM metadata, so callers should treat these as internal utilities and rely on the packaged implementation when required.

Tables Accessed

The package references data dictionary objects rather than application tables. Documented dependencies include COLTYPE$, SUBCOLTYPE$, TYPE$, OBJ$, SOURCE$, DEPENDENCY$, USER$, and the PL/SQL internal table PLITBLM. These provide the type definition, column type, source code, dependency, and user/schema information required to update, split, and recompile object types. It also depends on the DBMS_OBJECTS_UTILS_* types, UTL_OBJECTS_LIB, UTL_RECOMP, DBMS_OUTPUT, and STANDARD. No APPS synonym tables are documented as referenced.

Usage Notes

This package is invoked internally during database and EBS maintenance operations, particularly during patching, upgrades, and recompilation routines. It is not referenced by any database object in the documented dependency chain, and it is not exposed through EBS forms or concurrent programs. Custom code should not invoke it directly; where type recompilation is needed, standard utilities such as UTL_RECOMP are the appropriate supported entry point. Any interaction with this package should be limited to Oracle-supplied maintenance processes.