5.5 Creating an App Using Generative AI

Create an application using Generative AI and enter natural language.

Note:

This feature requires you create a Generative AI Service and enable the Used by App Builder setting. If no Generative AI Services are available in the workspace, the Create App Using Generative AI option in the Create Application Wizard is hidden. To learn more, see Managing Generative AI Services.

When you click Create App Using Generative AI option in the Create Application Wizard, the APEX Assistant appears and guides your through the process of creating an application.

Tip:

If you have made changes to the tables in your workspace, the APEX Assistant may prompt you to refresh the data dictionary cache to work with the latest tables. Follow the on-screen instructions. If you want to send a sample prompt from APEX Assistant, you can install any of the available sample dataset. Once installed, APEX uses two of the most recently installed sample datasets and APEX Assistant provides sample prompts as quick pick buttons. Click on one of these buttons to send the sample request to the AI Service.

The example that follows builds an application on the sample dataset, Project Data. To learn more about installing a sample dataset, see Using Sample Datasets in Oracle APEX SQL Workshop Guide.

To create an app using Generative AI:

1. On the Workspace home page, click the App Builder icon.
2. Click Create.

   The wizard prompts you to select a method of creating your application.

3. Click Create App Using Generative AI.

   The APEX Assistant appears.

   Tip:

   If APEX Assistance does not detect any tables, it may prompt you to browse the sample datasets included with APEX. If prompted, click Browse Sample Datasets and install a sample dataset.

   
   

   
   Description of the illustration create_app_using_ai.png

   
   

   APEX Assistant prompts you enter a message.

4. In the field provided:
   1. Type your message here - Describe the app you want to create, including the data or tables to use. For example:

      Create an app with an interactive report on EBA_PROJECTS

   2. Click Send Message (or press Enter).

      APEX Assistant displays a brief summary outlining the app and pages to be created.

5. Review the summary. If needed, enter more messages to change the requirements.
6. When you are satisfied, click Create Application.
   The Create Application Wizard appears.
7. Review and edit the attributes as needed. To learn more about an attribute, see field-level Help.
8. Click Create Application.