Search Results dbms_i_index_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_I_INDEX_UTL is a core Oracle Server-supplied PL/SQL package that resides in the SYS schema and is shipped in a VALID state in both Oracle E-Business Suite 12.1.1 and 12.2.2. The package name follows Oracle's internal naming convention for "index utility" support components, where the I_ prefix denotes an internal (non-public) helper variant. It forms part of the internal infrastructure that supports domain indexing and extensible index type operations, most notably the Oracle Data Cartridge Interface (ODCI) framework. In the EBS context, this package is not an application-facing API; it is a database kernel utility that indirectly supports features such as function-based indexes, extensible indexing, materialized view (snapshot) refresh, and export/import metadata handling. Because it lives in the SYS schema and is classified as OTHER rather than a public EBS API, it is never intended for direct invocation by EBS application code, concurrent programs, or forms.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents zero public procedures or functions for this package. This is consistent with its role as an internal kernel helper: DBMS_I_INDEX_UTL exists primarily to expose internal callable entry points consumed by sibling SYS packages rather than a published specification for end users. Accordingly, no parameter lists or signature-level details are documented, and none should be assumed. The package is best understood as a private subroutine container whose internal logic is governed by Oracle's proprietary Data Cartridge and index-management implementation.

  • No documented standalone procedures or functions are exposed for customer use.
  • Its callable surface is reserved for internal SYS package consumption only.

Tables Accessed

The ETRM metadata does not list any application tables referenced through APPS synonyms, which is expected for a SYS-owned internal package. Any data dictionary access it performs is against fixed SYS objects (such as index metadata), not against EBS product schema tables. Consequently, there are no documented EBS tables that this package reads or writes. Application support teams troubleshooting EBS issues should not expect this package to touch APPS-level data directly; its effects are manifest indirectly through index and materialized view operations managed by higher-level SYS components.

Usage Notes

SYS.DBMS_I_INDEX_UTL is referenced by four documented packages: DBMS_EXPORT_EXTENSION, DBMS_INDEX_UTL, DBMS_ODCI, and DBMS_SNAPSHOT. These dependencies confirm its supporting role in export/import of extensible objects, index utilities, the ODCI/Data Cartridge interface, and materialized view management. Application developers and DBAs should never call this package directly from custom EBS code, forms, or concurrent programs; it is invoked internally by Oracle whenever the corresponding kernel features are exercised. Because it is a SYS object, it should never be modified, recompiled manually, or replaced, as doing so risks invalidating dependent kernel packages and compromising database integrity. When encountering the name during dependency or error analysis in EBS 12.1.1 or 12.2.2, it should be treated as a read-only internal Oracle component rather than an EBS application API.