Understanding Generative AI Support in APEX
Learn about Generative Artificial Intelligence (AI) Service support in APEX.
See Also: Creating an App Using Generative AI
In addition to using the generative AI features in APEX App Builder, you can also create and evolve your apps using APEXlang with external tools and AI agents. For more information, see Working with APEXlang in Oracle APEX Developer’s Companion.
About Generative AI Services
Learn about Generative AI Services in APEX.
APEX stores Generative AI Service information as a Generative AI object (or Generative AI Service) on the Generative AI Services page in Workspace Utilities. Since Generative AI Services are stored at the workspace-level, they are visible and available to all applications in the workspace. Generative AI Services support many commercial Generative AI products such as OCI Generative AI Service, OpenAI, Cohere, and Google Gemini.
When you create a Generative AI Service, APEX stores the AI Service key as a Web Credential. The Generative AI Service actually stores information about the AI Service being used.
If you export an application that uses Generative AI Service, the export file omits the actual Web Credential secret from the Web Credential definition. When importing the export file, you must set the Web Credential secret manually or set it using an API.
Administrator Controls
Instance administrators can manage support for AI Services at the workspace or instance-level. To learn more, see Editing Workspace Information and Managing Support for AI Services for an Instance in Oracle APEX Administration Guide.
About the Used by App Builder Setting
Enable the Used by App Builder setting to include built-in Generative AI Service capabilities in APEX.
When you create a Generative AI Service, the Settings, Used by App Builder attribute controls whether built-in Generative AI Service capabilities are available in App Builder, SQL Workshop, and Data Reporter.
Key features added by enabling Used by App Builder include:
-
Create Application Wizard - Adds a Create App Using Generative AI option, enabling users to create a new application using natural language.
-
Create Page Wizard - Adds a Generative AI tab, enabling users to create new applications using natural language.
-
Interactive Reports - Adds natural language support to interactive reports.
-
Code Editors - Adds Generative AI support (such as APEX Assistant) in all Code Editors in App Builder, SQL Workshop, and Data Reporter. Note: Within a given workspace, you can only enable the Used by App Builder setting for one Generative AI Service at a time.
For more information, see:
Including Generative AI in Your Applications
Learn about adding AI in your applications.
You can include AI in your applications by creating a dynamic action which opens the AI Assistant. The actual steps involved can be as simple as hooking a button to the dynamic action.
To learn more, see Including Generative AI in Applications.