Search Results chk_txnqry_disbl_switch

Overview

CTXSYS.CTX_QUERY is the Oracle Text query API package shipped in the CTXSYS schema and exposed to Oracle E-Business Suite through public and product-specific synonyms. In the EBS 12.1.1 and 12.2.2 environments documented in ETRM, the package is recorded with owner CTXSYS, status VALID, API classification OTHER, and 16 documented subprograms. Its business function is to provide the runtime services required to execute, tune, and explain full-text searches against Oracle Text indexes. EBS modules that store and search large volumes of descriptive or unstructured text — including Oracle Advanced Marketing (AMV), Applications (APPLSYS, APPS), Receivables (AR), Customer Service (CS), Product Information/Engineering (EGO), iStore and Oracle iSupport pages (ICX), CRM Foundation (JTF), Contracts (OKC), Projects (PA), and the HTML-based Techstack reporting components (DRILOAD, DRIXMD, DRVXMD) — depend on this package to drive user-facing search behavior.

Key Procedures and Functions

The documented subprograms fall into several functional groups. Query execution and hit counting are handled by COUNT_HITS, COUNT_HITS_CLOB_QUERY, FCONTAINS, and RESULT_SET, with CLOB-oriented variants COUNT_HITS_CLOB_QUERY and RESULT_SET_CLOB_QUERY supporting documents stored in CLOB columns rather than VARCHAR2. Query tuning and diagnostics are provided by EXPLAIN and EXPLAIN_CLOB_QUERY, which return the parse tree and scoring information used to validate and optimize search expressions, and by BROWSE_WORDS, which supports wildcard, fuzzy, and thesaurus browsing of indexed tokens. Relevance refinement and feedback are served by HFEEDBACK and HFEEDBACK_CLOB_QUERY, which implement the hierarchical feedback algorithm that adjusts result ranking based on a set of known-relevant documents.

• COUNT_HITS, COUNT_HITS_CLOB_QUERY — return the number of documents matching a query.
• FCONTAINS — evaluate whether a text column satisfies a search condition.
• RESULT_SET, RESULT_SET_CLOB_QUERY — produce ordered result sets for a given query.
• EXPLAIN, EXPLAIN_CLOB_QUERY — return query execution plans for tuning and troubleshooting.
• HFEEDBACK, HFEEDBACK_CLOB_QUERY — perform hierarchical relevance feedback.
• BROWSE_WORDS — list indexed terms for a token or wildcard pattern.
• STORE_SQE, STORE_SQE_CLOB_QUERY — persist stored query expressions for later reuse.
• REMOVE_SQE — delete a stored query expression.
• CHK_XPATH — validate an XPath expression used against XML-indexed content.
• CHK_TXNQRY_DISBL_SWITCH — inspect the control switch governing transactional query behavior.

Tables Accessed

ETRM documents only two referenced objects, both accessed through APPS synonyms: DBMS_ASSERT, used to validate and sanitize identifiers and SQL fragments, and PLITBLM, an internal PL/SQL table support object. Query results themselves are drawn from the Oracle Text index structures maintained by CTXSYS (such as the DR$ tables) rather than from base application tables directly. This design keeps EBS application access mediated by the CTX_QUERY API and its SECURITY and index-definition configuration.

Usage Notes

CTX_QUERY is not normally called directly by end users. It is invoked by EBS forms containing Oracle Text–enabled search blocks, by concurrent programs that index or re-index text columns, and by custom PL/SQL that performs CONTAINS-style searches against indexed columns. The package is referenced by four other packages and is granted to PUBLIC, so custom code may call it through the CTX_QUERY synonym; nevertheless, direct calls should be limited to documented subprograms, and dependency chains such as CTX_DDL and the DRILOAD/DRIXMD/DRVXMD reports should be reviewed before upgrades, since changes to CTXSYS in the database release can affect EBS search functionality.