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


  4. APEX Assistant offers two options:
    • Select an pre-defined option.

      Based on the Sample Datasets installed, APEX Assistant displays possible options. In the previous image, the pre-defined option, Develop an app to manage Project Data is highlighted.

    • Type your message here - In the field provided, enter text describing the application you want to build and click Send Message (or press Enter).

      For example, if you enter create an app on project tables, APEX Assistant provides a summary of the app to be created, including a list of pages and enabled features. Click Create Application to continue.

  5. In APEX Assistant, click Create an app to maintain Project Data.

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

  6. Enter more messages to iterate through application design using natural language. You can add, remove, or rename pages. You can add or remove features. You can also change to use different table or data.
  7. Once satisfied, click Create Application to continue.

    The Create an Application page appears with the Name and Pages included and Features and Setting configured.

  8. Review the Create an Application page. Update or change any pages or options. To learn more, see Running the Full Create Application Wizard.
  9. Click Create Application.