We are pleased to announce the ability to enable Natural Language Query (NLQ) of Oracle E-Business Suite Release 12.2 leveraging Oracle Generative Artificial Intelligence (AI) is now available.
What is Natural Language Query Using Oracle Cloud Generative AI?
The Oracle Select AI feature available in Oracle Autonomous Database (ADB), processes a natural language prompt, supplements the prompt with metadata, and then accesses the Large Language Models (LLMs) to generate a SQL query, and if requested, runs that query.
Oracle E-Business Suite (EBS) provides many powerful querying and sophisticated reporting capabilities such as EBS Enterprise Command Centers (ECC). Oracle Select AI goes a step further by enabling users to ask EBS questions in their natural language and get results in the simple Ask Oracle E-Business Suite user interface (UI) (See Figure 1 – Ask Oracle E-Business Suite [EBS] UI).
What is the Technical Architecture?
Oracle Select AI enables the natural language query of EBS 12.2 by leveraging Autonomous Database’s Select AI feature and Oracle Cloud Infrastructure’s Generative AI, translating a natural language question into a SQL query.
The SQL query is then executed in the EBS database to provide the results. Each query is executed in a new XX_NLQ schema that has minimum grants. Together with new secured views and new Virtual Private Database (VPD) policies, EBS security setups are honored. The system utilizes Oracle APEX to provide a simple and intuitive Ask Oracle E-Business Suite UI.
The following diagram, Figure 2 – Technical Architecture Diagram, shows the interaction between the APEX front end, ADB on Oracle Cloud Infrastructure (OCI), the LLM service, and EBS.
Note: While ADB must run on OCI, the EBS system itself can be deployed on-premises or on OCI.
Where Can I Learn More About Enabling Natural Language Query of EBS?
A newly published technical paper is now available: Enabling Natural Language Query of Oracle E-Business Suite (EBS) Release 12.2, Leveraging Oracle Generative AI (MOS Note 3059877.1).
This technical paper describes:
- A prototype APEX application that enables natural language query of EBS data by leveraging OCI Generative AI. For more information about integrating EBS with APEX, see Enhanced Integration with EBS 12.2 and APEX Now Available.
- The full list of prerequisites for enabling natural language query of EBS, such as EBS 12.2.7, Database 19c, and APEX 24.1.
- The steps to enable natural query language of EBS 12.2 leveraging Oracle Generative AI.
References
- Enabling Natural Language Query of Oracle E-Business Suite (EBS) Release 12.2, Leveraging Oracle Generative AI (MOS Note 3059877.1)
- Extending Oracle E-Business Suite Release 12.2 with Oracle APEX (PDF)
- Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Note 1577661.1)
- Oracle Cloud Infrastructure Documentation – About Oracle Select
- Oracle E-Business Suite Developer’s Guide (HTML)
Related Articles
- Enhanced Integration with EBS 12.2 and APEX Now Available
- Introducing Select AI – Natural Language to SQL Generation on Autonomous Database
- Oracle E-Business Suite 12.2.14 Now Available
- AD and TXK Delta 16 Updates Available for EBS 12.2
- OA Framework 12.2 Latest Bundels Available (Oct 2024)
- EBS 12.2 Certified with Database Release Update 19.25 – All Platforms
- EBS Technology Blog Announcements: Oracle Application Framework