Search Results remove_index

Overview

CTXSYS.DRIIXS is an Oracle Text (interMedia Text) internal PL/SQL package that belongs to the CTXSYS schema, the schema that owns the Oracle Text server-side objects shipped with the database. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environment, this package is not a business application API; it is infrastructure supplied by the Oracle Text option and exposed to EBS through the CTXSYS schema. Its role is to manage index sets — named, reusable collections of index definitions that the Oracle Text "ConText" indexing engine can apply across one or more text columns. Rather than requiring an administrator to define index attributes column by column, DRIIXS allows an index set to be created once, populated with column entries, copied, and then applied or dropped as a unit. Within EBS, this capability underpins the storage and retrieval of text-based content (for example, descriptive flexfield text, attachments, or catalog/search metadata) that relies on Oracle Text indexing.

Key Procedures and Functions

The package exposes eight documented program units, all centered on lifecycle management of index sets:

• CREATE_INDEX_SET — Creates a new named index set, establishing the container to which index columns are later added.
• ADD_INDEX — Adds a column (with an optional storage clause) to an existing index set, defining an individual index entry within that set.
• REMOVE_INDEX — Removes a previously added column entry from an index set.
• DROP_INDEX_SET — Drops a single named index set from the dictionary.
• DROP_USER_INDEX_SETS — Drops all index sets owned by a given user, or by the current user when no user name is supplied.
• COPY_INDEX_SET — A function that copies an existing index set (identified by index id) into a new named index set, returning a preference record and an out parameter row count. This supports cloning an existing configuration for reuse.
• GETINDEXINDEXSET — Retrieves the index-set definition associated with an already-existing index, returning the index-set table structure to the caller.
• GETINDEXIXSCOLUMNS — Retrieves the set of columns belonging to an already-existing index, returning the column table structure to the caller.

These units map to a predictable administrative pattern: define, extend, inspect, clone, and remove index-set metadata.

Tables Accessed

The ETRM metadata records a single referenced table, PLITBLM, reached through an APPS synonym. PLITBLM is an Oracle Text back-end table that stores the truncated left-hand tokens used by the ConText index when stemmed or partial-token lookups are performed. DRIIXS references this table indirectly as part of the index-set operations it performs; the read/write behavior is therefore tied to Oracle Text indexing activity rather than to EBS application data tables. No EBS transactional or interface tables are documented as accessed by this package.

Usage Notes

DRIIXS is invoked programmatically, typically from Oracle Text administrative scripts, DDL-adjacent PL/SQL blocks, or EBS code that automates text index creation and maintenance. It is referenced by six other packages, indicating that higher-level Oracle Text routines depend on it rather than end users calling it directly. In an EBS 12.1.1 or 12.2.2 instance, it would be exercised when text indexes are created, cloned, or dropped in support of search functionality, attachments, or descriptive content. Because it resides in CTXSYS, direct modification or invocation by EBS developers is strongly discouraged; the CTXSYS schema is Oracle-owned, and the package is upgraded or patched with the database. Custom EBS code should rely on documented Oracle Text APIs (such as CTX_DDL and CTX_DDL-like procedures) rather than calling DRIIXS directly. The "Codecatalyst Dx6" search term does not correspond to this object; DRIIXS is unrelated to any Codecatalyst tooling and is purely an Oracle Text internal index-set management package.