Hi,
We are currently working on enabling Natural Language Query (Ask Oracle EBS) functionality in Oracle E-Business Suite to allow users to query application data using natural language through an APEX-based interface.
During implementation, we observed that the NLQ solution appears to be using ECC-based views/datasets as data sources.
However, we would like architectural clarification on the following:
Primary Question
Is Enterprise Command Center (ECC) setup and configuration a mandatory prerequisite for Enabling Natural Language Query (Ask Oracle EBS) in Oracle EBS?
doc: nlq_views.sql
example: PER_ECC_ASSIGNMENT_V, QA_ECC_RESULTS_V, OE_ECC_ORDER_LINES_V, INV_ECC_ONHAND_V etc.
Additional Observations:
- Some ECC views automatically reflect transactional data updates.
- Some datasets require ECC data load programs.
- In certain cases, ECC data load programs fail with “The requested URL /ecc/ir/data/inv/datasets/inv-onhand was not found” error.
Because of this behavior, we want to confirm whether:
- NLQ depends fully on ECC datasets.
- ECC deployment and dataset configuration are required before NLQ can function correctly.
- NLQ can work independently of ECC, or ECC is part of the standard architecture.
We appreciate any guidance or insights from peers who have implemented NLQ in their environments, as this will help us validate our understanding of the recommended architecture and ensure alignment with standard Oracle practices.
Thank you in advance for your guidance.