Search Results dbms_xmltableindex

Overview

SYS.DBMS_XMLTABLEINDEX is an Oracle-supplied PL/SQL package that resides in the SYS schema and is exposed to the database through a PUBLIC synonym named DBMS_XMLTABLEINDEX. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package forms part of the server-side infrastructure that supports XML-based table structures, commonly referred to as XMLType tables and their associated index definitions. Its role is administrative and DDL-oriented: it provides programmatic interfaces for creating and maintaining the index groups and columns that back XMLType table storage. Because it is a SYS-owned package, it is not an Applications product component and does not carry an APPS schema owner. The ETRM record confirms an object status of VALID and classifies the API as OTHER, indicating that it is a general-purpose database utility rather than a business-specific application programming interface.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within the package. Their names indicate the DDL operations they encapsulate.

• CREATEINDEX — Creates the index structure associated with an XMLType table, establishing the underlying index definition used for query performance.
• ALTERINDEXADDGROUP — Adds a new index group to an existing XML index, allowing structured or unstructured components to be grouped for management purposes.
• ALTERINDEXMODIFY — Modifies attributes of an existing index group, permitting adjustments to its configuration after creation.
• ALTERINDEXDROPGROUP — Removes an index group from an existing XML index.
• ALTERINDEXADDCOLUMN — Adds a column to an existing index group so that additional XML paths or scalar values participate in indexing.
• ALTERINDEXDROPCOLUMN — Removes a column from an existing index group.
• ALTERINDEXRENAMECOLUMN — Renames a column within an existing index group without otherwise altering the index definition.

No parameter lists are documented in the ETRM record, and the procedures should be treated as internal DDL helpers rather than a supported end-user API surface.

Tables Accessed

The ETRM record lists no tables referenced by this package through Applications synonyms. As a dictionary-level utility, the package operates against Oracle data dictionary infrastructure and the XMLType index structures themselves rather than against EBS transactional or setup tables. No APPS synonym mapping is recorded, which is consistent with its status as a SYS-owned database feature package.

Usage Notes

The dependency record shows that DBMS_XMLTABLEINDEX references SYS.STANDARD and the SYS schema, and that it is referenced by the PUBLIC synonym DBMS_XMLTABLEINDEX and by SYS itself. The package is not referenced by any other documented packages, and the count of dependent packages is zero. In practice, this package is invoked indirectly by the Oracle database when XMLType table indexes are created or altered, including operations performed during EBS patching, upgrades, and database administration. It is not intended to be called directly from EBS forms or concurrent programs, and no Applications-level wrapper is documented. Custom code should avoid direct invocation because the interface is an internal Oracle implementation detail subject to change between database releases. Administration of XMLType indexes in an EBS environment is normally performed through supported database utilities and Oracle-provided DDL rather than through this package explicitly.