Skip to Main Content

Build AI-powered apps with Oracle APEX

The ability to effectively parse and extract meaningful insights from a diverse data landscape has become paramount for apps across various domains. Oracle Cloud Infrastructure (OCI) offers a comprehensive suite of AI services that streamline this process and empower developers to unlock the full potential of their cloud apps. 

This session covers how to leverage Oracle APEX’s robust and powerful Web service capabilities to effectively integrate OCI AI services into your enterprise apps. Let’s empower Oracle APEX apps with cutting-edge AI-driven data analysis, opening up new possibilities for intelligent decision-making and enhanced user experiences.

Question And Answer

  • #SELECTION#
    #ICON_HTML#

    Are these apps available somewhere?

    we have blog post https://blogs.oracle.com/apex/post/building-innovative-qa-experiences-oracle-apex-meets-oci-generative-ai we are working on a hands-on lab and will have a downloadable app with that

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Are these services also accessible via REST API from an on-prem db when I don't have an OCI console?

    The OCI AI services require you to acquire and set up a tenancy on OCI - then these services can be made available to your apps onprem or in OCI
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    As far as I understand, you can use the Vision REST service passing image data as BASE64. Is that also available for the Document Understanding or should we always use Object Srorage Buckets for the files and responses?

    Yes, object storage. see the architecture: https://www.oracle.com/in/artificial-intelligence/document-understanding/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can I upload PDF files and AI will answer based on info from PDF? Can I add some tags with PDF files and then narrow question based on that?

    yes, that's what is happening in this demo - however the behind the scenes is the pdfs are prepared as json for the prompt
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can I use any of the AI Services on OCI Free Tier?

    yes! https://www.oracle.com/in/artificial-intelligence/vision/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can digital assistant be used to answer questions about insights into a database? For example could I ask it to tell me which product in my DB has the highest list price?

    You can consider using the Select AI feature of ADB Toufiq is going to cover that shortly.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can this features be using for face recognition to apply in a security system for example?

    Yes, that's one of the use cases. https://www.oracle.com/in/artificial-intelligence/vision/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can we use GenAI features of oracle database through APEX? If yes, is there any documentation I can refer to?

    Absolutely! Please read these two blog posts:

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can you can make REST calls to OCI Vision using a local on-premise APEX instance?

    yes - as long as your network connectivity permits that traffic - it's just https REST requests
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Does ODA work with the Spanish language?

    Yes, ODA comes with Spanish as Natively-supported Languages https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/languages-and-skills1.html#GUID-63ECE745-F2B6-464A-A656-40B60F3B07E2

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Does chat bot support Arabic?

    Natively-Supported Languages are listed here: https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/languages-and-skills1.html#GUID-63ECE745-F2B6-464A-A656-40B60F3B07E2

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    For legacy applications which use images to be stored in DB, v are looking at moving thse to file system.Can we migrate such apps to cloud and make use of CI vision ?

    you should look into OCI Object Storage and learn more about that - there are many tools available to make the migration possible
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Hi, Does Oracle provide OCI service to process scanned paper forms to convert the information to structured data, for instance in order to process filled in health care forms, tax forms, membership applications etc? Thanks

    I guess that is Document Understanding. Please see https://www.oracle.com/in/artificial-intelligence/document-understanding/
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Hi, which languages are supported by Gen AI Services?

    Hi - Natively-Supported Languages (for this service) https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/languages-and-skills1.html#GUID-63ECE745-F2B6-464A-A656-40B60F3B07E2

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    How is the use of the OCI AI services charged?

    Each of the OCI Service has a pricing page. For example https://www.oracle.com/in/artificial-intelligence/speech/pricing/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    I'm looking for an engine where I can define forward and/or backward chaining rules to define 'traditional' expert systems and then invoke rule execution using an API call. Thanks

    Sounds like something that you could use the new APEX Visual Workflow to manage? We have a tutorial that might give you some insight on this and may even give you some good ideas. https://apex.oracle.com/en/learn/tutorials/ (see the workflow lab)

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    If I have a "help" set of data tables, can it analyze that text and answer user questions based on it?

    Yes, absolutely
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is ODA using LLM at backend?

    Hi Rajeev - Oracle Digital Assistant's integration of large language models (LLMs) enables you to enhance your skills with generative AI capabilities. https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/llm-blocks-skills.html#GUID-A197357D-BB8C-4558-8A02-DF471AF12E9A

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is any version of OCI Vision available to test with the Oracle Cloud Always Free version?

    See https://www.oracle.com/in/artificial-intelligence/vision/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is it possible that AI will create unit test cases based my PL/SQL procedure?

    We think that most anything like this will eventually be possible with AI. Since APEX doesn't perform unit test cases itself, this would be a question of the unit test tool that you choose to use, today.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is it possible to use AI features without OCI?

    As far as OCI AI Services are concerned, you can consume them from your APEX On-Premise environment. You will need to create an API key for the user on OCI Console and provide access to the desired AI Services through OCI IAM Policies. Once this is done, you can consume these OCI AI Services via REST on APEX instances installed anywhere, On prem or Cloud. The Select AI, however, is a feature of Oracle Autonomous Database and is available only on APEX instances hosted on ADB.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is select AI part of ADB implicitly or is there a cost associated with it ?

    Yes, select AI is part of ADB. Please see https://blogs.oracle.com/machinelearning/post/introducing-natural-language-to-sql-generation-on-autonomous-database

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the Bot-UI done by the uploaded JS files?

    Yes, Bot-UI is coming from the Web-sdk and Settings.js files we have uploaded
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the image search shown initially language limited? Can we search in any other language and still get the results?

    The Search I have showed is coming from a DB column. If you are reading a text with different language from Image, You can search that too
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the on-premise setup possible for Gen AI?

    Oracle Gen AI is an Oracle Cloud Infrastructure offering. You can also use this On-Premises via an OCI Dedicated Region over REST (as demonstrated) but there are no plans to release the technology of Oracle Gen AI services to run exclusively on-premises.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the response and request has to be always in JSON format only?

    generally yes - but REST supports XML too etc, so it would depend on the API you want to use
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the “select ai” feature planned in a future release of Oracle DB 23c?

    Select AI is already available on ADB today.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is there access to this demo app?

    There is no demo app, but a blog post that you can refer to https://blogs.oracle.com/apex/post/integrating-an-oracle-digital-assistant-chatbot-in-to-your-oracle-apex-app

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is there also a interface to openAI?

    You mean for example, Azure OpenAI service? This should help https://blogs.oracle.com/machinelearning/post/announcing-select-ai-with-azure-openai-service

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is there service to read barcode? uploading image where is barcode and will get the number back or I should use image recognise what reads numbers?

    there are plugins on https://apex.world that can do this - they are just using generally available JavaScript libraries to make it work.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is these AI services available in OCI free account?

    yes for limited. see the page https://www.oracle.com/in/artificial-intelligence/vision/
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    OCI Vision API has some free tier? for creating a simple MVP

    Yes - please review this page https://www.oracle.com/in/artificial-intelligence/vision/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Our team is working on a customer project using APEX and would ideally like to integrate with Hugging Face. Do you have documentation or resources that we can look into? Any guidance that you could provide would be greatly appreciated.

    This is simply going to be an exercise in configuring your apps to use the hugging face REST API's - take a look at our Hands On lab that features AI vision - it'll give you a solid primer on what is needed
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Regarding Select AI, do we need to expose the DB to outside third parties like ChatGPT, etc.

    No. It is ADB feature
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Skills and Intents are connected to an LLM?

    Hi Mario, ODA does support Generative AI. Please refer to the below blog for more details. https://blogs.oracle.com/emeapartnerweblogic/post/oracle-digital-assistant-conversational-ai-generative-ai-at-cloudworld-2023

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    So there will be separate infrastructure for Oracle AI Stack than Oracle APEX Infrastructure , if that is on-site?

    APEX can consume any AI service via REST, and these services are just some examples
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    The chatbot did not appear, the one Mr. Roopesh was explaning. Only the login-page was appearing again and again

    Hi, Chatbot was available in the login Page too. In the bottom right part of the page. I have asked the Chat bot some questions like “Hi and What is APEX”
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    There will be soon available a sample APEX appliction with all this features?

    We are working on a Hands-on lab and will make sure to have a downloadable app. Definitely we will consider this suggestion and try to bring in a sample app some time soon
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    This blog mentions APEX Assistant: https://blogs.oracle.com/apex/post/generative-ai-apex-1 That’s not available yet is it?

    Coming to a future release of APEX
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    What our users are looking for is a replacement of the report interface with a simple text box, e.g. "Show me the invoices from Acme Ltd and its subsidiaries which are past due", with maybe an "escape" to the original interface.

    this will certainly be possible!
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    When I send a Data Profile just with table names does it also sends the column names? Does it also use Domains?

    Yes, it does. Select AI gathers all the metadata about the tables and sends it across to LLMs
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Where do I train my custom model? In OCI or do I have to bring it already?

    In OCI
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Which languages can be used with ODA?

    Please find the languages supported here: https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/languages-and-digital-assistants.html#GUID-FBD8550A-B532-442B-BB76-A1241EC1C6B9

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Will the AI features be made available on apex.oracle.com?

    yes, in a future release of APEX
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Will these demos be available as live labs?

    yes to an extent - our vision AI example is an HOL on our website apex.oracle.com/hols

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Will this recording be posted on your Oracle APEX YouTube channel?

    yes and via apex.oracle.com/officehours when published

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Would it be possible to do a POC with Select AI?

    Yes, Please check out this blog for more details https://blogs.oracle.com/apex/post/configuring-generative-ai-in-oracle-apex-using-select-ai

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    can I integrate something like machine learning and fuzzy system, then apply interpretability to show in APEX results?

    Yes - you can bring any of that technology to life in an APEX app.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    can OCI AI services, ex. Vision, also TAG an image?

    This process will not be updating the image itself by way of EXIF, if that's what you mean - your app will have to update your local table/column with the results that the VISION API will return, and then use those tags as your search source
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    can i check out ai services in free tier

    A bunch of these AI Services are available with the Free Tier. You can check out the included offerings in the below link https://www.oracle.com/in/cloud/free/#free-cloud-trial

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    chatBot pricing is not mentioned?

    Please review this page https://www.oracle.com/chatbots/pricing/

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    how wold be possible to fine tune LLM models as per customer data?

    https://docs.oracle.com/en-us/iaas/Content/generative-ai/fine-tune-models.htm

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    on ODAssistant, any link to get details on SQL Dialog?

    The below link talks about using ODA SQL dialog. Use can use the appropriate Web-sdks and implement this. https://docs.oracle.com/en/cloud/paas/digital-assistant/use-chatbot/sql-dialog-skills.html#GUID-A300FC76-5395-4404-8CE5-C16CA11DDD82

    #MISC#
    #ACTIONS#

Featured Speakers

  • Speaker

    Jayson Hanes


    Oracle APEX PM

  • Speaker

    Chaitanya Koratamaddi


    Director of Product Management, Oracle APEX - Database Tools | Server Technologies

  • Speaker

    Roopesh Thokala


    Senior Product Manager

  • Speaker

    Toufiq Mohammed


    Senior Product Manager

Workshop Info

Session Has Completed - 22 February 2024
1 Hour
APEX Office Hours
English
Oracle APEX Service, Oracle APEX

Other Upcoming Sessions

  • APEX Office Hours

    APEX Office Hours

    15 May 2025 10:00 AM America/New_York

    Seats Available
    Marc Sewtz, Alexis Galdamez, Paige Hanssen, Roopesh Thokala, Toufiq Mohammed
    English
    1 Hour
    Login to Register
  • APEX Office Hours

    APEX Office Hours

    19 June 2025 10:00 AM America/New_York

    Seats Available
    Marc Sewtz, Alexis Galdamez, Paige Hanssen, Roopesh Thokala, Toufiq Mohammed
    English
    1 Hour
    Login to Register
  • APEX Office Hours

    APEX Office Hours

    17 July 2025 10:00 AM America/New_York

    Seats Available
    Marc Sewtz, Alexis Galdamez, Paige Hanssen, Roopesh Thokala, Toufiq Mohammed
    English
    1 Hour
    Login to Register