AI Solution

Using Natural Language to Query Oracle E-Business Suite Data

Introduction

A large amount of enterprise data resides in databases, and it would be easier to access if any user could query it with natural language. This would save time for technical users, who would otherwise have to use specialized SQL knowledge to build queries. But how would we access Oracle E-Business Suite data with natural language? By using large language models to turn our questions into SQL, query the database, and return answers.

This demo shows how to use Oracle APEX and Oracle Autonomous Database Select AI to create an application that lets users query a database with natural language without them needing SQL knowledge. For example, you’ll be able to type a question, such as “How many purchase orders don’t have a purchase order number?” get results, and then refine them using natural language by saying, “Sort by month and year.”

Demo

Demo: Using Natural Language to Query Oracle E-Business Suite Data (1:43)

Prerequisites and setup

  1. Oracle Cloud account—sign-up page
  2. Oracle Cloud Infrastructure—documentation
  3. Oracle APEX—documentation
  4. OCI Generative AI—documentation
  5. Oracle Autonomous Database—documentation