Search Results ctx_anl




Overview
Explore in AI Chat

Overview

CTXSYS.CTX_ANL is a PL/SQL package owned by the CTXSYS schema — the Oracle Text (interMedia Text) system account — and is delivered as part of the standard Oracle database installation rather than as an Oracle E-Business Suite product-specific component. Within the EBS 12.1.1 and 12.2.2 technology stack it is classified in the ETRM repository with an API classification of OTHER, reflecting its role as an Oracle Text administrative utility rather than a business-facing application programming interface. The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking schema rather than those of the CTXSYS owner, so effective access is governed by the caller's own grants on Oracle Text objects.

The business function of CTX_ANL is dictionary maintenance for Oracle Text indexing. Oracle Text supports user-defined "thesaurus" and "stoplist"-type analysis dictionaries that influence how documents are tokenized, stemmed, and normalized during indexing. CTX_ANL provides the programmatic interface through which such a dictionary is registered against a particular language and subsequently removed. In an EBS environment, this supports full-text search over stored documents, attachments, and descriptive flexfield content where Oracle Text indexes are used.

Key Procedures and Functions

Two procedures are documented in the ETRM metadata:

  • ADD_DICTIONARY — Registers a named dictionary with Oracle Text for a specified language, supplying the dictionary content itself. It is the entry point for creating a new analysis dictionary that subsequent indexing operations can reference.
  • DROP_DICTIONARY — Removes a previously registered dictionary by name, de-registering it so it is no longer available to the indexing infrastructure.

The package specification exposes only these two procedures; no functions or additional overloads are documented. Parameter lists are intentionally omitted here, as the ETRM record documents the callable surface only at the level of procedure names.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms, which is consistent with the package's ownership: CTX_ANL operates on Oracle Text's own data dictionary objects within the CTXSYS schema, not on EBS application tables such as FND_ or AP_ entities. Dictionary definitions managed through ADD_DICTIONARY and DROP_DICTIONARY are persisted in Oracle Text's internal repository, and the package is likewise recorded as being referenced by zero other packages, confirming that it sits outside the EBS inter-package dependency graph and is not invoked by any standard application logic.

Usage Notes

Because CTX_ANL is an Oracle Text system package and carries AUTHID CURRENT_USER, it is not normally invoked from EBS forms, concurrent programs, or standard product code. Typical invocation is from a DBA or developer session connected as a schema holding the required Oracle Text privileges, executed through SQL*Plus or a similar tool during index configuration or troubleshooting. The invoking user must have EXECUTE permission on the package, granted by CTXSYS, and must additionally possess the underlying Oracle Text privileges on the dictionary operations themselves. Customizations that build full-text search over EBS content — for example, indexing attachment text — are the most plausible scenario in which a site would call ADD_DICTIONARY directly. The package should be treated as database-supplied infrastructure; it is not patched or versioned by EBS patching and should not be modified.