18.9.1 Understanding Generative AI Support in APEX

Learn about Generative Artificial Intelligence (AI) Service support in APEX.

• About Generative AI Services
  Learn about Generative AI Services in APEX.
• About the Used by App Builder Setting
  Enable the Used by App Builder setting to include built-in Generative AI Service capabilities in APEX.
• Including Generative AI in Your Applications
  Learn about adding AI in your applications.

18.9.1.1 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.

18.9.1.2 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.

18.9.1.3 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.