Build Oracle APEX Applications Using Generative AI Service

APEX Application using GenAI

 

Using Generative AI, OCI APEX makes development easy. Users can build strong, scalable applications with little coding. Now, you can create a low-code APEX application by simply using the GenAI option.

 

In this blog post, I will illustrate, with screenshots, how to create an APEX application by simply configuring GenAI and leveraging its capabilities in just a few minutes.

 

Sample APEX Application created using GenAI:

 

Pre-Requisite

 

- Provision an ATP Database or APEX deployment.

- Create the APEX workspace.

- Configure Generative AI Service in the APEX application.

- Utilize the GenAI to create an APEX application.

 

 

Provision an Autonomous Database

Follow the blog link to create an ATP database: https://beingpiyush.blogspot.com/2023/04/oracle-cloud-provision-autonomous.html

 

Enable the APEX workspace

 

1.      Open the APEX ORDS URL:

- Navigate to https://<IP_or_PublicEdnpoint>/ords/apex

 

 

2.      Create Workspace

- Click on: Create Workspace

 

 

- Choose either a New Schema or Existing Schema.

- In this Demo we are creating a New Schema

 

 

 

- Click on Create Workspace.

 

 

3.      Workspace Created:

- Sign out of Administration Services and sign in to `GenAI_Workspace` to begin building applications.

- Login with the APEX workspace name, Username, and Password.

 

4.      Default Dashboard:

 

 

Configure Generative AI Service

To utilize the Generative AI Service first we must configure the Generative AI Service with available AI models.

 

1. Access App Builder:

- Click on App Builder.

 

 

- Click on Workspace Utilities.

 

 

- Go to Generative AI.

 

- Click on Create.

 

 

 

2. Choose the AI Provider:

 

- From the drop-down menu, select the AI Provider.

 

- For this demo, we are utilizing the OCI Generative AI.

 

- By default, the Model ID is cohere.command r 16k, however, this Model ID is not functional.

- Choose ‘cohere.command r plus 08 2024’.

 

 

 

- Click on Create.

 

 

 Utilize Generative AI capabilities to create a low code Apex application.

 

1. Create a New App:

- Go to the home page and click on Create or Create a New App.

 

 

- Provide a name for the application and click on Create App Using Generative AI.

 

2. Install Sample Datasets:

- Before creating the application using AI, we need to have some tables in the workspace.

 

- Click on Browse Sample Datasets.

 

 

- Choose any dataset from the available options and install it.

 

 

 

- Click on Next and Install Dataset.

 

 

 

- Now your first application is created. Let's choose the GenAI capability to create the application using GenAI.

- Accept the terms.

 

 

4. APEX Assistance Page:

- The APEX Assistance page will show chatbot options.

 

 

- In the chat option, type your requirement.

 

 

- Manually choose additional options from the Features.

 

 

- Additionally, select About Page and Feedback.

 

- Click on Create Application.

 

 

- Wait for 2-3 minutes, and your application will be created.

 

 

- Click on Run Application to view your application.

 

- The login page will appear, asking for the username and password.

 

Add Schema to Workspace and Onboard a User

 

1. Add Schema:

- Go back to the APEX workspace dashboard as the ADMIN user.

 

 

 

 

 

 

 

- Click on Add Schema.

 

 

2. Create an Application User:

- Click on Manage Workspace and then Manage Developer and Users.

 

- Click on Create User.

 

- Choose the correct workspace name and workspace schema.

 

 

- Provide a password and create the user.

 

 

 

 

 

Congratulations! Your first APEX application is created using the GenAI Service. The Administrator Page allows you to add users, see feedback, and much more.

 

 

 

Administrator Page you can add users and see the feedback and many more.