Search Results update_phrase

Overview

CTXSYS.DRITHSL is an Oracle Text (interMedia Text) internal PL/SQL package that provides the specialized thesaurus loader interface used by the Oracle Text thesaurus loading utilities. The name DRITHSL derives from the Oracle Text "drit" family of dictionary/thesaurus routines, with the "SL" suffix denoting "thesaurus loader." Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack, this package is not part of the EBS application schema objects (such as AP, GL, or INV) and is not registered as an EBS concurrent program or form. Rather, it belongs to the CTXSYS schema, the Oracle Text administrator account, and becomes visible to EBS through the standard database grants and synonyms that Oracle Text installs. Its business function is to allow Oracle Text to construct, populate, and dump thesaurus entries from within the database server rather than through external command-line utilities, enabling EBS-based full-text search configurations to manage thesauri used for document and knowledge-base search.

Key Procedures and Functions

The package exposes a documented set of ten procedures and functions. The primary entry points include:

• CREATE_THESAURUS — a specialized version of DRITHSC.CREATE_THESAURUS adapted for the thesaurus loader; it establishes a named thesaurus and returns a numeric identifier or status.
• CREATE_PHRASE — a specialized version of DRITHSC.CREATE_PHRASE for the thesaurus loader; it creates a phrase entry within a thesaurus and returns a numeric result. This is the object most relevant to the user search term "create_phrase."
• DUMP_THESAURUS — a procedure that emits the stored contents of a named thesaurus, used for export and diagnostic purposes.
• NEXT_DUMP_LINE — a function that retrieves the next line of dumped thesaurus output, supporting streaming of DUMP_THESAURUS results.
• ALLOCATE_IDS — a procedure that allocates a contiguous block of thesaurus identifiers and returns the starting identifier of that block.
• INSERT_PHRASE — a procedure that inserts a phrase row with its associated identifiers, qualification, note, and ring identifier.
• INSERT_BT, INSERT_FPHRASE, UPDATE_PHRASE, and GET_THSID_BYNAME complete the loader interface, handling broader-term relationships, forward phrase inserts, phrase updates, and name-to-identifier lookups respectively.

Parameter lists are not reproduced here; only the documented purpose of each program unit is described.

Tables Accessed

The ETRM metadata records references through APPS synonyms to DBMS_ASSERT and DUAL. DBMS_ASSERT is a PL/SQL-supplied package used for SQL injection protection and identifier validation, while DUAL is the standard single-row pseudo-table. The metadata does not disclose the underlying Oracle Text dictionary tables (such as those in the CTXSYS schema for thesaurus storage), and those should be considered internal to Oracle Text rather than directly visible EBS application tables.

Usage Notes

In EBS 12.1.1 and 12.2.2, DRITHSL is typically invoked indirectly. It is called by Oracle Text thesaurus loading workflows, by the CTXLOAD or equivalent loader routines, and by any custom PL/SQL that programmatically builds a thesaurus before an EBS text index is created or synchronized. It is not exposed through standard EBS forms or concurrent programs. Custom developers who need to construct thesauri for EBS "Search" or knowledge-management indexing should call this package only from within the CTXSYS execution context and with the appropriate privileges. Because it is an Oracle-supplied internal package, its interface is subject to change between database releases and should not be relied upon by custom code without version-specific validation against the installed Oracle Text component.