Overview
What Is Trusted Answer Search?
Oracle Trusted Answer Search is a purpose-built language-to-target mapping system for enterprise applications. It maps natural-language user questions to curated, application-defined search targets, such as reports, URLs, or SQL-driven views.
Trusted Answer Search is designed for scenarios where accuracy, speed, security, and repeatability are required. Instead of generating free-form responses, the platform returns deterministic results that the application can use to render the correct report or direct the user to the right page.
Trusted Answer Search combines Oracle AI Vector Search, lexical search, and re-ranking techniques to improve relevance. It also incorporates feedback-assisted multi-vector search so administrators can incorporate human feedback and continuously improve quality over time.
The platform includes operational controls for enterprise deployment, including change management, versioning, query regression analysis, and staged testing.
The Trusted Answer Search platform is intended to be integrated into applications that want to expose a natural language interface to their users to access the application’s functionality and reports.
Trusted Search Versus Agentic AI
The Enterprise Requirement
Many application experiences require deterministic and auditable outcomes. Users expect the same question to produce the same result, and organizations must ensure confidential data is never exposed.
Limits of General Agentic Patterns for Bounded Tasks
General-purpose Large-Language Model (LLM) and Retrieval-Augmented Generation (RAG) approaches are effective for broad, open-ended questions. However, for bounded, application-specific questions, they can introduce the following issues:
-
Non-deterministic output and potential hallucinations
-
Higher latency and compute cost than required
-
Variable behavior across model updates
-
Limited understanding of enterprise-specific jargon since LLMs are not trained on it
-
Low reliability of NL2SQL for complex enterprise schemas
Trusted Answer Search Approach
Trusted Answer Search addresses these issues by using constrained retrieval and controlled outputs:
-
Manages search spaces that contain the search targets.
-
Enables creation of search targets within search spaces. These search targets (URL to direct the user to, reports to show to the user, etc.) are associated with sample questions and descriptions in natural language.
-
Maps natural language questions posed by users to search targets using vector similarity and information retrieval. The natural language descriptions and sample questions associated with search targets are used by the multi-vector search and information retrieval algorithms to facilitate in retrieval of the right search target.
-
Returns deterministic (pre-curated, non-LLM generated) responses that the application interprets to reliably take next steps such as opening a specific report, or redirecting the user to the URL.
-
Supports extraction of parameters from the user’s query, for example: dates, regions, categories, people, companies. These parameters are returned to the application along with the target.
-
Enables feedback and correction workflows so that search space experts can review “incorrect matches”, mark matches as correct, propose new search target descriptions or sample questions, or create new search targets — creating a structured loop for improving quality over time.
-
Includes change management and versioning for safe rollout.
-
Preserves security boundaries by relying on targets that are already built to honor end-user identity.
-
Provides out-of-the-box administration and end-user experiences, plus APIs for custom integration.
The result is a practical, enterprise pattern for trusted, repeatable language interfaces.
Architecture and Concepts
Architecture
Trusted Answer Search includes five components:
-
Admin APEX application: used by search space experts to configure and manage search spaces
-
Portal APEX application: ready-made end-user experience that can be deployed by enterprise teams
-
Search API: used by developers who want the maximum flexibility to integrate the Trusted Answer Search solution into their application or platform, and who do not prefer using the packaged APEX applications
-
Search backend: the core Trusted Answer Search platform containing code and metadata built on Oracle AI Database 26ai.
Personas and Access
-
Search Space Users: End-users can search using natural language and provide feedback within allowable search spaces
-
Search Space Experts: Experts have access to assigned search spaces. They curate targets and natural language descriptions for targets. Experts can perform all actions that a user can perform.
-
Search Administrators: Search Admins have complete access across all search spaces; they can manage search space experts, and perform all expert/user actions.

Core Concepts
Search Target
A Search Target is a curated asset, such as a URL to a report, chart, or SQL-generated view. It is defined by descriptions and sample queries, and is what the system retrieves in response to user questions. Trusted Answer Search does not store or index the reports or URLs in any way. It simply returns the target to the application that uses Trusted Answer Search, along with any parameters contained in the natural language query. The application is free to take action (such as sending the user to the URL) based on the target returned.
Consider the example of a brokerage application that must answer common questions about current positions, previous trades, tax statement location, etc. Trusted Answer Search returns to the application the URL for the page showing current account positions (among other ranked results). The application or website then can redirect the user to the top returned result.
Following is a list of examples spanning diverse application domains:
-
Retail banking portal: “Client Daily Cash Position” target links to an authenticated cash-balance dashboard filtered by account and settlement window.
-
Field service management app: “Open High-Severity Work Orders” target maps to a dispatch board that prefilters by territory and severity status.
-
Corporate finance analytics: “Quarterly Operating Expense Variance” target surfaces a workbook that compares budget versus actuals with drill-through filters by cost center.
Target Action
A Target Action is metadata associated with a Search Target. It is usually one of the following:
- URL to open a report or page
- SQL statement to populate a report view
Trusted Answer Search returns action metadata to the client; execution is handled by the client application.
Continuing the brokerage example, the “Trade history in Q4” target publishes a deterministic action that downstream apps use to open a page displaying trade history with quarter filters applied.
Examples illustrate how applications consume target actions:
-
Retail banking target “Daily Cash Position” returns
https://portal.examplebank.com/reports/cash-position?customer_id=:CUSTOMER_ID, letting the application or website open the authenticated dashboard after substituting the resolved customer ID. -
Workforce planning target “Upcoming Staffing Gaps” returns a SQL query that filters upcoming shifts by
:REGION_CODE, allowing the APEX report to bind the extracted region value and render schedule gaps.
SELECT shift_id,
start_time,
end_time,
required_headcount,
scheduled_headcount
FROM workforce_shifts
WHERE region_code = :REGION_CODE
AND start_time BETWEEN SYSDATE AND SYSDATE + 7
AND scheduled_headcount < required_headcount
ORDER BY start_time;
Target Inputs
Target Inputs make URL and SQL actions dynamic. Placeholders in an action template are populated from values extracted from user queries.
Example URL template:
https://www.brokerage123.com/investments?username=:USERNAMES
In this example, if the user query includes a username value, :USERNAMES is replaced with the recognized value.
So, Trusted Answer Search would return:
https://www.brokerage123.com/investments?username=adamwhen the user queries: “show me investment report for Adam”https://www.brokerage123.com/investments?username=johnwhen the user queries: “give me John’s investment report”
The Target Input :USERNAMES is linked to a Target Value Set MY_USERNAMES that contains a list of usernames so that Trusted Answer Search only substitutes approved values or synonyms. More on target value sets below.
Target Value Sets
Target Value Sets define allowed values used in extraction of keywords from a user query and substituting those extracted words into target actions. Two Target Value Set types are supported:
- Static value sets: explicitly curated lists of values (with optional synonyms)
- Table column-based value sets: values sourced from a database table column and synced as needed (with optional synonyms)
Synonyms can improve matching, while canonical values are used for action substitution.
In the brokerage example, the MY_USERNAMES Target Value Set might define canonical values such as JOHN_SMITH and ADAM_JONES with synonyms like “john” or “adam”. Target Inputs reference this value set so that :USERNAMES is replaced with the canonical user identifier even when the user query uses a synonym.
Search Space
A Search Space is a versioned collection of search targets for a specific application domain. Teams can isolate changes, collaborate, compare versions, and promote approved updates.
In the retail banking example, the Search Space expert maintains a “Retail Banking” search space that groups targets such as “Current account positions,” “Tax reporting statements,” and “Total return in the current FY.” Experts can stage updates, review diffs, and promote a tested configuration to production once approvals are complete.
How It Works
Trusted Answer Search uses a deterministic, LLM-free hybrid retrieval pipeline.
1. Query Normalization
The system normalizes user input before retrieval:
- Corrects common spelling errors (e.g., sevverity → severity)
- Normalizes morphology such as singular/plural forms (e.g., bugs → bug).
- Removes low-value stop words (e.g., the, show, a) while preserving domain terms
This produces normalized tokens and normalized query text.
2. Dual Retrieval
Semantic Retrieval
Vector similarity retrieval using Oracle AI Vector Search embeds query and corpus text to identify intent-level similarity. Corpus text includes target descriptions, target sample queries, and expert upvoted/downvoted user queries in search targets.
Semantic retrieval provides strong recall when wording differs.
Lexical Retrieval
Keyword-based matching retrieves targets from an inverted index built from:
- Target descriptions
- Sample queries
- Expert-reviewed user feedback queries
- Target value sets and synonyms linked to a search target’s inputs
Lexical retrieval provides high precision when terminology aligns.
3. Re-ranking and Fusion
Ranked lexical and semantic result lists are fused into a single ordered list using a re-ranking algorithm. This balances exact token match with semantic intent match.
4. Target Input Extraction
For targets with dynamic actions, the system matches normalized query terms against Target Value Set’s values and synonyms, then substitutes canonical values into URL or SQL templates.
Example Walkthrough
User query:
Show my stock trades in Q1 2026
-
Normalize the query.
- Spelling correction: No typos detected.
- Morphology handling: Reduce “trades” to “trade,” remove auxiliary verbs.
Normalized text: “show my stock trade in Q1 2026” - Stop-word filtering: Drop “show”, “my”, “in” and filler words to keep the high-value tokens.
Normalized keywords: stock, trade, Q1, 2026.
-
Run dual retrieval.
Lexical search:
- Matches detected: “stock,” “trade,” “Q1,” “2026” across target descriptions and sample queries.
- Target Value Set exact matches:
Q1(quarter),2026(year). - Ranked lexical results:
- Rank 1: “Same-Day Trade Confirmations” (precise hits on “trade,” “stock,” and the year token “2026”)
- Rank 2: “Quarterly Stock Trade History”
- Rank 3: “Equity Trade History – Year Selector”
Semantic search:
- Ranked semantic results:
- Rank 1: “Quarterly Stock Trade History” (strong semantic match)
- Rank 2: “Equity Transactions Timeline”
- Rank 3: “Trade Confirmations Archive”
-
Re-rank and fuse the lexical and semantic lists.
- Rank 1: “Quarterly Stock Trade History” — despite ranking second lexically, it has strong lexical coverage and the best semantic match, so re-ranking promotes it to the top.
- Rank 2: “Same-Day Trade Confirmations” — maintains a high position thanks to lexical precision, but trails the top result semantically.
- Rank 3: “Equity Trade History – Year Selector” — retains solid lexical alignment yet weaker semantic relevance compared to the top two.
-
Extract target inputs.
For the “Quarterly Stock Trade History” target, the following target inputs are extracted from the user query:
- Target action URL template:
https://www.brokerage123.com/trade-history?quarter=:QUARTER&year=:YEAR&type=stock. :QUARTERresolves toQ1.:YEARresolves to2026.
- Target action URL template:
The resulting URL is https://www.brokerage123.com/trade-history?quarter=q1&year=2026&type=stock, which the application can open directly to display the client’s Q1 2026 trade history.
This hybrid approach ensures customers get fast, consistent, and trustworthy answers to business questions, without relying on generative models.
Feedback-Aware Relevance
Trusted Answer Search incorporates feedback from the Search Space Expert to improve retrieval quality:
-
Positive signals: User queries with upvoted search targets participate in the semantic search to increase the surface area of a Search Target in the embeddings space (i.e., through multi-vector search) and also contribute to the keywords in a search target for lexical search, increasing both lexical and semantic salience.
-
Negative signals: User queries with downvoted targets help remove irrelevant targets, reducing future false positives.
Reliability Characteristics
- Deterministic behavior for a fixed corpus and configuration
- Independent lexical and vector indexes for performance
- Incremental indexing for new and updated targets
- Interpretable retrieval and ranking pipeline without generative response variability