Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

AI Agent - Subject Area Usage

Accepted answer
64
Views
5
Comments
Saroj Kumar Behera
Saroj Kumar Behera Rank 5 - Community Champion
in Oracle Analytics Forum

Hi,

Can we create OAC - AI Agent based on Subject area data.

Regards

Saroj

Tagged:

Best Answer

  • RVohra
    RVohra Mod
    Answer ✓

    @Saroj Kumar Behera ,

    We can definitely create AI Agents based on the Subject Area but need to consider following:

    1. AI agents cannot directly query the database. They rely on the semantic model / subject area.
    2. Subject areas must have:
      1. good metadata
      2. friendly column names
      3. defined hierarchies
    3. Security still applies:
      • row-level security
      • role-based access

    Hope it helps!

Answers

  • Rajaraman Loganathan
    Rajaraman Loganathan Rank 2 - Community Beginner

    Yes, OAC AI Agent can be created on Subject Area but to enable creating AI Agent based on specific Subject Area Indexing needs to be defined on the said subject area using Search.Index option.

  • Mohammed Rafi
    Mohammed Rafi Rank 4 - Community Specialist

    @Rajaraman Loganathan - If I am not wrong there is no separate indexing step required to make a Subject Area accessible for Natural Language Query (NLQ) or AI Assistant.

  • Rajaraman Loganathan
    Rajaraman Loganathan Rank 2 - Community Beginner

    @Mohammed Rafi Could see only the Indexed subject areas are listed to choose dataset while creating AI Agent

  • Brendan T
    Brendan T Rank 6 - Analytics & AI Lead

    Recent updates to the platform have specifically expanded the AI Assistant and AI Agent frameworks to support enterprise subject areas alongside standard datasets.
    Key Features for Subject Area-Based AI Agents
    Indexing and Synonyms: As of March 2025, search indexing includes support for subject areas. This allows administrators to define synonyms for columns within a subject area, making it easier for the AI Agent to understand natural language business queries (e.g., mapping "Earnings" to the "Converted Revenue" column).Author Control: Content authors can explicitly specify which data sources—including specific subject areas—users are permitted to interact with using natural language.
    Domain Specialization: The January 2026 update introduced domain-specialized AI agents. These agents leverage Retrieval-Augmented Generation (RAG) and custom instructions to allow consumers to interact with curated enterprise data models (subject areas) using their own business vocabulary.