---
title: A Practical Use for AI in APEX – Delivery Bookings
description: Discover how to enhance Oracle APEX delivery booking systems with AI for efficient, user-friendly scheduling.
image: https://content.dsp.co.uk/hubfs/A%20Practical%20Use%20for%20AI%20in%20APEX%20%E2%80%93%20Delivery%20Bookings.png
---

[![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk)

[![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk)

- Services 
    - Consulting Services 
          - [Oracle](https://www.dsp.co.uk/oracle-consultancy)
          - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy)
          - [Google](https://www.dsp.co.uk/google-cloud-consultancy)
          - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture)
    - Managed Services 
          - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services)
          - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services)
          - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services)
          - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services)
          - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services)
          - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services)
    - Licensing and SAM 
          - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services)
          - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam)
    - Application Services 
          - [Application Development](https://www.dsp.co.uk/software-development)
          - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation)
          - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex)
          - [Application Extensions](https://www.dsp.co.uk/software-customisation)
          - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution)
          - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services)
          - [Development Training](https://www.dsp.co.uk/oracle-apex-training)
    - Data Science 
          - [AI Strategy](https://www.dsp.co.uk/ai-strategy)
          - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai)
          - [Agentic AI](https://www.dsp.co.uk/agentic-ai)
          - [Data Management for AI](https://www.dsp.co.uk/data-management)
          - [Power BI](https://www.dsp.co.uk/power-bi-services)
          - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services)
          - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning)
    - Cloud Migration and Management 
          - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment)
          - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation)
          - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration)
          - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services)
          - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management)
          - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure)
    - Integration and APIs 
          - [API Management](https://www.dsp.co.uk/api-development-services)
          - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services)
    - Disaster Recovery and Security 
          - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions)
          - [Security Compliance](https://www.dsp.co.uk/data-security)
          - [Cloud Security](https://www.dsp.co.uk/cloud-security)
  
  
  
   
  
  ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg)
  
  
  
  
  
  
  
  #### Getting to know us
  
    - [About us](https://www.dsp.co.uk/about)
    - [What we do](https://www.dsp.co.uk/what-we-do)
    - [Leadership](https://www.dsp.co.uk/dsp-product-leads)
    - [Careers](https://www.dsp.co.uk/careers)
- Technologies 
    - Oracle Cloud Infrastructure 
          - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services)
          - [IaaS](https://www.dsp.co.uk/iaas)
          - [PaaS](https://www.dsp.co.uk/paas-security)
    - Oracle Database 
          - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting)
          - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services)
          - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services)
          - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services)
    - Oracle Engineered Systems 
          - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy)
          - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance)
    - Oracle Applications 
          - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services)
          - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services)
          - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services)
          - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services)
          - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services)
    - Microsoft 
          - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy)
          - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services)
          - [Power BI](https://www.dsp.co.uk/power-bi-services)
          - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services)
    - Google 
          - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner)
    - Multicloud and Database Hyperscaler 
          - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner)
          - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning)
          - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws)
          - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud)
    - Open Source Database 
          - [PostgreSQL](https://www.dsp.co.uk/postgresql-services)
          - [MySQL](https://www.dsp.co.uk/mysql-services)
          - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql)
  
  
  
  #### Managed Services
  
    - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services)
    - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services)
    - [MySQL](https://www.dsp.co.uk/mysql-support)
  
  
  
  
  
  
  #### Application Services
  
    - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration)
    - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services)
    - [Microsoft](https://www.dsp.co.uk/microsoft-partnership)
    - [ISV Services](https://www.dsp.co.uk/isv-support-and-services)
  
  
  
  
  
  
  
  
  #### Cloud Services
  
    - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services)
    - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services)
    - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database)
    - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud)
  
  
  
  
  
  
  #### Data Science
  
    - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services)
    - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services)
    - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services)
  
  
  
  
  
  
  
  
  #### Consulting Services
  
    - [Oracle](https://www.dsp.co.uk/oracle-consultancy)
    - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy)
    - [Google](https://www.dsp.co.uk/google-cloud-consultancy)
    - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations)
  
  
  
  
  
  
  #### Technology Solutions
  
    - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner)
    - [Data Security](https://www.dsp.co.uk/data-security)
    - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture)
    - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery)
- Industries 
    - [Finance](https://www.dsp.co.uk/finance)
    - [Healthcare](https://www.dsp.co.uk/healthcare-it-services)
    - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport)
    - [Higher Education](https://www.dsp.co.uk/higher-education)
    - [Public Sector](https://www.dsp.co.uk/public-sector)
    - [Manufacturing](https://www.dsp.co.uk/manufacturing)
    - [Retail](https://www.dsp.co.uk/retail)
    - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services)
  
  
  
  ### Recent case study:
  
  #### Oracle EBS Cloud Deployment
  
  Consolidating and Migrating assets into Oracle Cloud Infrastructure.
  
  [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)
  
   
  
  
  
  
  
  
  
  #### Most Visited Pages
  
    - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing)
    - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/)
    - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration)
    - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services)
    - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services)
  
  
  
  
  
  
  
  
  #### -
  
    - [SQL Server Support](https://www.dsp.co.uk/sql-server-support)
    - [Oracle Support](https://www.dsp.co.uk/oracle-support)
    - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy)
    - [New Application Development](https://www.dsp.co.uk/oracle-apex-services)
    - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop)
- Resources 
    - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download)
    - [ISG](https://www.dsp.co.uk/isg-oracle-report)
    - [Blogs](https://www.dsp.co.uk/blogs)
    - [Case Studies](https://www.dsp.co.uk/case-studies)
    - [Testimonials](https://www.dsp.co.uk/testimonials)
    - [Events](https://www.dsp.co.uk/events)
    - [Webinars](https://www.dsp.co.uk/webinars)
    - [Insights](https://www.dsp.co.uk/insights)
    - [Technical Resources](https://www.dsp.co.uk/technical-resources)
  
  
  
  ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.
  
   
  
  [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305)
  
  
  
  
  
  
  
  #### Resources
  
    - [Blogs](https://www.dsp.co.uk/blogs)
    - [Webinars](https://www.dsp.co.uk/webinars)
    - [Case Studies](https://www.dsp.co.uk/case-studies)
    - [Testimonials](https://www.dsp.co.uk/testimonials)
- About 
    - [About DSP](https://www.dsp.co.uk/about)
    - [What We Do](https://www.dsp.co.uk/what-we-do)
    - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board)
    - [Careers](https://www.dsp.co.uk/careers)
    - [Project Harar](https://www.dsp.co.uk/project-harar)
- [Customer Area](https://www.dsp.co.uk/contact-us) 
    - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/)
    - [Customer Resources](https://www.dsp.co.uk/welcome)
- [Contact us](https://www.dsp.co.uk/contact-us)

# A Practical Use for AI in APEX – Delivery Bookings

[ Gareth Mayor ](https://content.dsp.co.uk/author/gareth-mayor) 13-Aug-2025 14:49:58

A Practical Use for AI in APEX – Delivery Bookings

7:56

### Contents

[15-Jul-2025 15:02:43

Enhance User Experience with AI Vector Search in APEX

](https://content.dsp.co.uk/enhance-user-experience-with-ai-vector-search-in-apex) [19-Feb-2025 12:51:03

Oracle APEX 24.2 General Builder Enhancements

](https://content.dsp.co.uk/oracle-apex-24.2-general-builder-enhancements) [31-Jul-2024 14:21:23

AI-Powered Apps

](https://content.dsp.co.uk/ai-powered-apps)

Traditionally, [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) applications with an appointment/delivery booking system would show a date/time ordered list of available time slots for the end user to select. Depending on the complexity of the system, some filters may only show certain date ranges or simply morning/afternoon. These systems can be inefficient as the end user tries to find a timeslot that suits their needs. For example, they might be available any Monday or Tuesday but not on other days, which makes hunting for those slots difficult. Ultimately, these systems haven't changed for many years. So, let me show you how to leverage the power of [AI](https://www.dsp.co.uk/ai) within APEX to filter the results efficiently and make the experience quicker and more fluid for the end user.

I am using Oracle 23ai, the first version to support Vector column types, and Oracle APEX version 24.2.

 

## Setting up the example data

Let's create our table where we will store our delivery slots. This will be a simple table that holds a date and time for the start and end of the delivery slot, a location that the delivery team will cover (because a delivery team based in London will not deliver to Scotland), and the number of delivery employees that will be in the van )as some items, like sofas and beds will need more than one person). Lastly, we need a column to show if a slot has been booked already. The code I've used for this can be found [here](https://content.dsp.co.uk/hubfs/del_slots%20table%20ddl.sql).

[![Example Del_Slots DDL](https://content.dsp.co.uk/hs-fs/hubfs/Example%20Del_Slots%20DDL.jpg?width=1696&height=478&name=Example%20Del_Slots%20DDL.jpg)](https://content.dsp.co.uk/hubfs/Example%20Del_Slots%20DDL.jpg)

Now for some example data. [Click here](https://content.dsp.co.uk/hubfs/del_slots%20table%20data.sql) for the script that I've used if you want to follow this example closely.

[![Example Del_Slots Data](https://content.dsp.co.uk/hs-fs/hubfs/Example%20Del_Slots%20Data.jpg?width=1840&height=877&name=Example%20Del_Slots%20Data.jpg)](https://content.dsp.co.uk/hubfs/Example%20Del_Slots%20Data.jpg)

For the purposes of the example, this would be enough, but let's make the application a little more complete and create a table to hold some products and another for customer data. The products will automatically retrieve the number of delivery employees needed to handle the product, and the customer data will hold the customer's location to match up with the delivery location.

To start, we'll create the products table; the code is available [here](https://content.dsp.co.uk/hubfs/products%20table%20ddl.sql).

[![Example Products DDL](https://content.dsp.co.uk/hs-fs/hubfs/Example%20Products%20DDL.jpg?width=1678&height=800&name=Example%20Products%20DDL.jpg)](https://content.dsp.co.uk/hubfs/Example%20Products%20DDL.jpg)  
   
And to create the records, I'm using the script found [here](https://content.dsp.co.uk/hubfs/products%20table%20data.sql).

[![language_sql](https://content.dsp.co.uk/hs-fs/hubfs/language_sql.png?width=810&height=690&name=language_sql.png)](https://content.dsp.co.uk/hubfs/language_sql.png)  
   
Lastly, the table to hold the customer data is available [here](https://content.dsp.co.uk/hubfs/customers%20table%20ddl.sql).

![Example Customer DDL](https://content.dsp.co.uk/hs-fs/hubfs/Example%20Customer%20DDL.jpg?width=1717&height=810&name=Example%20Customer%20DDL.jpg)

## Creating the App

For this example, I've created an empty application. Firstly, I've added a simple page on page 1 to collect the customer's name, location and the product they are ordering. I've used a simple select list to ensure that the data matches the delivery locations, as well as a select list for the product. I've then added a button that submits the page.

[![App Page 1](https://content.dsp.co.uk/hs-fs/hubfs/App%20Page%201.jpg?width=2236&height=1052&name=App%20Page%201.jpg)](https://content.dsp.co.uk/hubfs/App%20Page%201.jpg)

On the page processing, I've added a simple process to save the customer data to the CUSTOMERS table and then navigate to a second page where we will select the delivery slot.

![App Page 1 Processing](https://content.dsp.co.uk/hs-fs/hubfs/App%20Page%201%20Processing.jpg?width=2232&height=1050&name=App%20Page%201%20Processing.jpg)

For the delivery page, I've created a simple report that gets all delivery slots that match the delivery location, have at least the correct number of delivery employees and have not already been booked. Usually, we would add another column to allow the user to click and select the desired delivery slot, but we're going to amend this screen to provide some AI magic.

![App Page 2](https://content.dsp.co.uk/hs-fs/hubfs/App%20Page%202.jpg?width=2217&height=1057&name=App%20Page%202.jpg)

## Adding the AI Vector Search

To enable the AI processing, I need to add a column to the DEL_SLOTS table to store the vector details. If you are building your application from scratch, you would do this as part of the initial table creation, but I want to show you how easy it is to implement this feature into an existing page. So, switching to the SQL Commands, let's run the following command:

`ALTER TABLE del_slots ADD delivery_search   VECTOR;`

[![Create_vector_column](https://content.dsp.co.uk/hs-fs/hubfs/Create_vector_column.png?width=752&height=620&name=Create_vector_column.png)](https://content.dsp.co.uk/hubfs/Create_vector_column.png)

Now we need to populate the Vector embeddings. For this demo, I have already set up a Vector Provider using Cohere, as they provide a free API service (with usage limits), but you can use the service that is right for you. To see how to set up a Vector Provider, [click here](https://content.dsp.co.uk/hubfs/populate_del_slots_vector.sql).

To populate the entries, we need to reference the APEX_AI package and use the GET_VECTOR_EMBEDDINGS function, passing in the columns you want the embedding to be created around. This is the code I have used with the p_service_static_id being the name of the Vector Provider, so substitute this for your own.

[![vector_embedding](https://content.dsp.co.uk/hs-fs/hubfs/vector_embedding.jpg?width=1007&height=748&name=vector_embedding.jpg)](https://content.dsp.co.uk/hubfs/vector_embedding.jpg)

We now need to set up a search configuration. These contain information about the searchable data source.

Go to App Builder, select the application you are working on, and then go to the Shared Components. Within the Navigation section, click the Search Configurations link and then the Create button.

Enter a meaningful name for the Search Configuration and select Oracle Vector Search before clicking Next.

[![search_configuration_1](https://content.dsp.co.uk/hs-fs/hubfs/search_configuration_1.jpg?width=820&height=527&name=search_configuration_1.jpg)](https://content.dsp.co.uk/hubfs/search_configuration_1.jpg)

Select the Vector Provider you have previously set up, and then select the table you have used to store the embeddings. In my case, this would be DEL_SLOTS. Then click on Next.

[![search_configuration_2](https://content.dsp.co.uk/hs-fs/hubfs/search_configuration_2.png?width=752&height=476&name=search_configuration_2.png)](https://content.dsp.co.uk/hubfs/search_configuration_2.png)

The final screen is where you need to state the details about the table, such as the Primary Key and the column where the vector embeddings are stored, etc. Once you have set these, click the Create Search Configuration button.

[![search_configuration_3](https://content.dsp.co.uk/hs-fs/hubfs/search_configuration_3.jpg?width=816&height=515&name=search_configuration_3.jpg)](https://content.dsp.co.uk/hubfs/search_configuration_3.jpg)

Once created, we need to amend the search to restrict the returned slots to only those which have not already been booked. Go back into the Search Configuration by clicking on it and scroll down to the Source section to find the Where Clause. In here, add the following:

`DELIVERY_BOOKED IS NULL`

[![Add Where Caluse](https://content.dsp.co.uk/hs-fs/hubfs/Add%20Where%20Caluse.jpg?width=1592&height=1032&name=Add%20Where%20Caluse.jpg)](https://content.dsp.co.uk/hubfs/Add%20Where%20Caluse.jpg)

Now we have the search set up, let's add it to the application.

Return to the App Builder and navigate to the page you created to show the results. In my example, this is page 2. Amend the Type of the Available Slots region from Classic Report to Search.

The first thing we need to add is a search field for the end user to type into, so add a text field to the Available Slots region. I've called this P2_SEARCH.

You will see that APEX has automatically created a search item on the page. I've amended the name to be more meaningful, and within the attributes, you will need to set the Search Configuration to the name of the configuration we set up earlier.

The final piece is to add the name of the search text field item in the attributes of the Search Region.

[![Search Page Item](https://content.dsp.co.uk/hs-fs/hubfs/Search%20Page%20Item.jpg?width=352&height=577&name=Search%20Page%20Item.jpg)](https://content.dsp.co.uk/hubfs/Search%20Page%20Item.jpg)

So let's try it out.

Execute Page 1, and we are shown the initial screen. I've entered a random name as the customer and selected the location where this customer resides. Lastly, I've chosen a sofa as the product the customer is buying, and I know that this requires two people to deliver it.

[![Running Page 1](https://content.dsp.co.uk/hs-fs/hubfs/Running%20Page%201.jpg?width=588&height=400&name=Running%20Page%201.jpg)](https://content.dsp.co.uk/hubfs/Running%20Page%201.jpg)Clicking on Save takes me to page 2, where the AI vector search will perform its magic. In the search box, I typed Tuesday to show all the delivery slots that are on a Tuesday. Note that the search doesn't restrict to only those records that match; it is simply reordering based on how well the AI has matched the records.

[![Running Page 2 Tuesday](https://content.dsp.co.uk/hs-fs/hubfs/Running%20Page%202%20Tuesday.jpg?width=741&height=690&name=Running%20Page%202%20Tuesday.jpg)](https://content.dsp.co.uk/hubfs/Running%20Page%202%20Tuesday.jpg)

Now let's try something a little more taxing. I'm now going to ask for a specific date, so I've entered Tuesday, 16th. Note that in the above screenshot, these records were further down the list.

[![Running Page 2 Tuesday 16](https://content.dsp.co.uk/hs-fs/hubfs/Running%20Page%202%20Tuesday%2016.jpg?width=628&height=681&name=Running%20Page%202%20Tuesday%2016.jpg)](https://content.dsp.co.uk/hubfs/Running%20Page%202%20Tuesday%2016.jpg)

Now that's better. I wonder what would happen if I entered a time, as I'm sure I'm busy most of the day, and only free around 11 am. So let's enter Tuesday, 16th, at 11 am.

[![Running Page 2 Tuesday 16 11](https://content.dsp.co.uk/hs-fs/hubfs/Running%20Page%202%20Tuesday%2016%2011.jpg?width=572&height=603&name=Running%20Page%202%20Tuesday%2016%2011.jpg)](https://content.dsp.co.uk/hubfs/Running%20Page%202%20Tuesday%2016%2011.jpg)

Now the time slot I wanted has magically appeared at the top of the list!

I would then need to implement the procedure to book the delivery slot and link that to clicking on the row on the screen.

 

## Conclusion

AI is forming a greater part of our lives; however, we are not restricted to chatbots. As the technology becomes more understood, the boundaries are being pushed back. AI is a great help behind the scenes, but, as proven here, it can also enhance the customer experience by quickly and easily filtering data based on typed instructions instead of select boxes, radio buttons or check boxes.

With each new version of the Oracle database and of APEX itself, new AI features are created and existing features are streamlined, making the developer's job easier as well as enhancing the customer experience.

For more information, check out our [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services) and [AI Services](https://www.dsp.co.uk/ai-services), or [contact us](https://www.dsp.co.uk/contact-us) today, and one of our expert developers will be in touch.

[Oracle](https://content.dsp.co.uk/topic/oracle) [AI](https://content.dsp.co.uk/topic/ai) [APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [23ai](https://content.dsp.co.uk/topic/23ai) [APEX 24.2](https://content.dsp.co.uk/topic/apex-24-2)

[15-Jul-2025 15:02:43

Enhance User Experience with AI Vector Search in APEX

](https://content.dsp.co.uk/enhance-user-experience-with-ai-vector-search-in-apex) [19-Feb-2025 12:51:03

Oracle APEX 24.2 General Builder Enhancements

](https://content.dsp.co.uk/oracle-apex-24.2-general-builder-enhancements) [31-Jul-2024 14:21:23

AI-Powered Apps

](https://content.dsp.co.uk/ai-powered-apps)

[Previous

Oracle Licensing in 2025

](https://content.dsp.co.uk/oracle-licensing-in-2025)

[Next

Reduce Cost and Complexity by Shifting from MongoDB to Oracle Database 23ai

](https://content.dsp.co.uk/reduce-cost-and-complexity-by-shifting-from-mongodb-to-oracle-database-23ai)

#### Contact

Sales Enquiries  
[+44 (0) 203 880 1686](tel:+4420%2038801686)

Technical Support  
+44 (0) 330 058 8367

[enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk)

#### Follow us

<https://www.linkedin.com/company/dsp-explorer> <https://twitter.com/dspexplorer> <https://www.facebook.com/DSPcloud>

#### Office Locations

[**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D)  
[Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)

[**Leeds**  
Richmond House,  
Lawnswood Business Park,  
Leeds,  
LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842)

[**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
**  
[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)**  
[Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)<https://www.google.com/maps/place/70+Gracechurch+St,+Langbourn,+London+EC3V+0XL/@51.512117,-0.0869173,17z/data=!3m1!4b1!4m5!3m4!1s0x4876035256ab55cb:0x1f93b337c0190cf0!8m2!3d51.512117!4d-0.0847286><https://www.google.com/maps/place/Devonshire+House/@51.2797714,-1.0679275,15z/data=!4m5!3m4!1s0x0:0x4f204507edd15263!8m2!3d51.2797718!4d-1.0679748>

#### About Us

DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies.

![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png)

![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png)

![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg)

Registered Office: 30 City Road, London, EC1Y 2AB.  
Company Registration Number: 03898451

<https://content.dsp.co.uk/a-practical-use-for-ai-in-apex-delivery-bookings#>

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "dateModified" : "2024-10-01",
  "datePublished" : "2024-10-01",
  "headline" : "A Practical Use for AI in APEX – Delivery Bookings",
  "image" : [ "https://www.dsp.co.uk/hubfs/A%20Practical%20Use%20for%20AI%20in%20APEX%20%E2%80%93%20Delivery%20Bookings.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://content.dsp.co.uk/a-practical-use-for-ai-in-apex-delivery-bookings",
    "@type" : "WebPage"
  }
}
```