Skip to Main Content
Enhance your Oracle APEX App with Document-Aware Generative AI Agents

About This Workshop

Youtube Video

About This Workshop
This workshop demonstrates how to integrate Oracle APEX with OCI Generative AI Agents, showcasing how enterprises can enhance their applications with intelligent, context-aware capabilities. You will explore the power of Large Language Models (LLMs) combined with Retrieval-Augmented Generation (RAG) to transform raw enterprise documents into actionable insights.

As part of this workshop, you will begin by uploading various documents to OCI Object Storage, which serves as a secure, scalable repository for your enterprise data. These documents are then processed through an ingestion job, which parses, indexes, and prepares the data for interaction using the OCI Generative AI service.

You will integrate a chat interface within your Oracle APEX application, allowing end users to interact with the Generative AI Agent in real time. The AI agent uses the previously ingested content to provide intelligent, personalized, and context-rich responses, enhancing user experience and driving operational efficiency.

Workshop Info

1 hour, 30 minutes
  • Lab 1: Configure OCI API Keys and Bucket
  • Lab 2: Create Knowledge Base and Generative Al Agents
  • Lab 3: Setup Task for Application Development
  • Lab 4: Create APEX App and Configure REST Data Source
  • Lab 5: Add Page Items and Page Processes
  • Lab 6: Enhance Application Ul
  • Lab 7: Run the Application
  • A paid Oracle Cloud Infrastructure (OCI) account. 
  • An OCI compartment. An Oracle Cloud account comes with two pre-configured compartments - The tenancy (root compartment) and ManagedCompartmentForPaaS (created by Oracle for Oracle Platform services).

  • The logged-in user should have the necessary privileges to create and manage Autonomous Database instances in this compartment. You can configure these privileges via an OCI IAM Policy. If you are using a Free Tier account, it is likely that you already have all the necessary privileges.

Other Workshops you might like