Search Results create_relation

Overview

CTXSYS.DRITHSC is the Oracle Text thesaurus management package that resides in the CTXSYS schema and implements the "HS" (thesaurus) component of the Oracle Text Server (DRIT) architecture. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package provides the programmatic interface through which thesauri used by the Oracle Text index engine are created, populated, and maintained. A thesaurus in this context is a structured vocabulary of terms, synonym relationships, broader/narrower term hierarchies, and preferred-term mappings that the Oracle Text CONTAINS and CATSEARCH operators exploit at query time to expand a user's search terms.

The ETRM classification assigns DRITHSC an API classification of OTHER, reflecting its role as an internal Oracle Text administrative package rather than an EBS business API. It exposes eighteen documented procedures and functions covering the full lifecycle of thesaurus objects: existence checking, creation, truncation, renaming, deletion, and the maintenance of phrase and term-relation entries. Because it is owned by CTXSYS and not by APPS, the package is referenced from EBS by fully qualified name or through CTXSYS synonyms, and it is indirectly used wherever an EBS module relies on Oracle Text for content searching — for example, iStore, Knowledge Management, and Applications Technology content-search features.

Key Procedures and Functions

The documented API is organized into thesaurus-level operations, phrase-level operations, and relation/term operations.

• CHECK_THESAURUS_EXISTS, CREATE_THESAURUS, CREATE_THESAURUS_LSB, DROP_THESAURUS, DROP_USER_THESAURI, TRUNC_THESAURUS, and RENAME_THESAURUS handle the thesaurus container itself. CHECK_THESAURUS_EXISTS tests for prior existence; CREATE_THESAURUS builds a new, empty thesaurus and returns its identifier (erroring if it already exists); CREATE_THESAURUS_LSB is the supplemental-logging-enabled variant of creation; DROP_THESAURUS removes a thesaurus by identifier without erroring if it is absent; DROP_USER_THESAURI removes all thesauri owned by a given user or by non-existent users; TRUNC_THESAURUS empties a thesaurus while retaining its definition; and RENAME_THESAURUS changes a thesaurus name.
• CREATE_PHRASE, CREATE_PHRASE_LSB, DROP_PHRASE, and RENAME_PHRASE manage individual phrases (the lexical entries) within a thesaurus.
• MAKE_PT and CHANGE_SN manipulate term semantics: MAKE_PT establishes a preferred term, and CHANGE_SN alters sense/scope information associated with a term.
• CREATE_TR, DROP_TR, and UPDATE_TR operate on term-relation ("TR") entries, which encode the synonym, broader-term, narrower-term, and related-term links between phrases.
• CREATE_RELATION and DROP_RELATION define and remove the relation types (the vocabulary of link categories, such as SYN, BT, NT, RT) that TR entries reference. The user's query term "create_relation" maps directly to the CREATE_RELATION procedure, which registers a new relation category so that term-relation records can subsequently be created against it.

Tables Accessed

The ETRM metadata records only DUAL as a referenced table via APPS synonyms. This reflects the fact that DRITHSC is a PL/SQL wrapper: its substantive data manipulation is performed against the CTXSYS-owned Oracle Text dictionary tables (the thesaurus, phrase, and term-relation tables such as DR$THS, DR$THS_PHRASE, and related structures) that are not exposed through the APPS synonym layer. Custom EBS code calling this package does not read or write those dictionary tables directly; all access is mediated through the DRITHSC API. No EBS application tables are documented as being touched by this package.

Usage Notes

DRITHSC is invoked from PL/SQL rather than from a dedicated EBS form or concurrent program. In practice it is called by Oracle Text administrative scripts, by DBMS_ jobs that periodically rebuild or synchronize a thesaurus, and by custom EBS extensions that need to programmatically seed or maintain search vocabularies. Because the package belongs to CTXSYS, EXECUTE privilege is granted to PUBLIC by default in a standard Oracle database installation, but EBS customizations should still be written defensively: the calling schema must have permission to operate on the target thesaurus, and CREATE_THESAURUS requires that the thesaurus not already exist. The ETRM metadata notes that DRITHSC is referenced by three other packages, indicating that higher-level Oracle Text components (for example, thesaurus import/export or administration utilities) depend on it. When invoked as part of EBS patching or cloning, thesaurus definitions stored in the CTXSYS schema are database-level objects and are not migrated by the standard EBS AD utilities, so organizations relying on custom thesauri should plan to export and re-import them explicitly.