Skip to Main Content

What's new in Oracle APEX 24.1 - Part 1

Question And Answer

  • #SELECTION#
    #ICON_HTML#

    AI Assistant for creating application will give suggestion to any type of application or any limitations are there?

    AI Assistant for app creation assumes that you have some data model in your database that it can use as source for the app.

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

    AI assistant is not available in my workspace apex.oracle.com why?

    Before using APEX Assistant, You need to configure the Generative AI Service under Workspace Utilities. Please check out the blog below for more details. https://blogs.oracle.com/apex/post/coding-with-the-ai-powered-apex-assistant-on-oracle-apex

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

    APEX 24.1 introduces a new DB user called APEX_PUBLIC_ROUTER that was not present before - what is the purpose of this new database user?

    The use of APEX_PUBLIC_ROUTER user is related to the new functionaility of modernized Friendly URLs based on ORDS REST service.

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

    About "The Assistant DA is not associated to the customer DB schema in any way.". In the Highschool lab you set the context of a specific school using the SCHOOL_ID. I was looking for a way to set that context a little bit further down the chat. I will look in the API.

    Yes, you can use the APEX_AI.CHAT procedure to implement your own experience

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

    Are AI capabilities also available on-premises? if yes, what are the requirements?

    Yes, It is available for APEX installations on On-Premise databases. You should get a Generative AI Key from an AI provider like Open AI, Cohere

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

    Are all this AI new functionality available on apex.oracle.com or apex.oraclecorp.com?

    Yes. It is available.;you must configure your AI service in your workspace(s) manually

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

    Are there any plans to include code formatting rules for the code generated by the APEX AI?

    Sounds like a good idea :) https://apex.oracle.com/ideas

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

    Are these AI services available for locally hosted APEX installations? Or only for OCI?

    Yes, It is available for APEX installations on On-Premise databases.

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

    Can AI write code for API of oracle EBS to post and update data from Oracle APEX?

    That's a good question for the AI engine you're using. If it's trained on that topic, you would get the proper code to consume EBS APIs.

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

    Can I apply AI in our running APEX app by upgrading the APEX version. because schema is already created

    yes - get upgraded to APEX 24.1 and configure your AI service

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

    Can I make it respond to things from knowledge base only?

    Certainly! You can instruct the AI Assistant to not answer questions outside the context by specifying this instruction in the system prompt.

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

    Can a data model from SQL Modeler be used for the default schema?

    APEX is a feature of the Database, and any database objects in your application parsing schema are available to APEX.

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

    Can the AI generate Oracle SQL or only ANSI SQL?

    The Text to SQL Assistant is configured to favor Oracle SQL

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

    Can the AI perform more general tasks eg. autofill tables with sample data?

    Not at the moment. For your specific use case we have a Data Generator feature in APEX that supports filling tables with sample data

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

    Can the assistant look into a table to found the information? like agenda for doctors

    APEX AI Assistant, Query Builder, sends information about your table, column, PK and FK information only. It does not send information about your data, so AI cannot look into your table. However, you can design your own Chat dialog in your app to augment this to send information about your table data, so AI can reply using those data.

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

    Can the user side or developer side AI generate Selenium code for load testing APEX applications - especially via front end?

    Not really. Perhaps you can submit this as an Idea at https://apex.oracle.com/ideas and provide additional details about your desired use case (And for load testing you would probably use Locust or K6 rather than Selenium.)

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

    Can we Integrate it on local system which is not connected with internet. For intranet of organization. And can it provide help for EBS tables?

    Using Gen AI capabilities requires network connectivity to the AI provider. In most cases this means it requires an internet connection.

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

    Can we make it call an API?

    You can use the APEX_AI package's CHAT() procedure to create a custom chat experience. The aim of the "Open (the) AI Assistant" dynamic action is to make configuring a simple chatbot very easy for low-code developers.

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

    Can we replace Oracle Reports now?

    The Oracle Document Generator pre-built function provides a set of basic functionality for using Word Document templates to generate PDF results. It does not currently cover all the rich functionality that Oracle Reports offers. So some Oracle Reports might be replaceable by Oracle DocGen reports, but more complex ones may require the functionality available in Oracle BI Publisher (recently renamed to Oracle Analytics Publisher). APEX supports using them both for remote printing, along with other remote printing options.

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

    Can you generate a PLSQL Package based on a table?

    There is an utility inside APEX builder to do this. APEX Builder > SQL Workshop > Utilities > Methods on Tables

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

    Can you send me some url link how to configure workspace manually? Is it available also on OCI Free-Tier to use AI functionality in APEX?

    Please go to choose your environment: https://apex.oracle.com/en/learn/getting-started/ Then you can start using APEX

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

    Can you use the Open AI Assistant DA to "break in" the chat? Like "What is the status of my order?" - "What is the order number?" - "It's 12345" - and then use order 12345 to set the context.

    No, there is no automatic execution whatsoever happening. The Assistant DA is not associated to the customer DB schema in any way. Only the Text to SQL Assistant in the SQL Code Editor has knowledge of the customer metadata BUT not data. But even here the developer has to actively insert the generated SQL into the Code Editor and then verify and test it there

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

    Classic report Interactive report Interactive Grid ..... AI Report?

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

    Do AI assistant use token?

    We track the token usage for those Generative AI services that expose this information. The token usage is logged to the Web Service log. We do not restrict token usage on a workspace/user level though at the moment.

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

    Do APEX assistant accept hint to use approches like analitycs view or graph?

    In general, providing additional instructions and context in your prompt will significantly improve the quality of the responses generated by the AI. This helps the Generative AI service understand your question better and deliver a more accurate and relevant answer.

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

    Do I have to pay to get a API Key?

    yes.. AI services are not free of cost - you might be able to find a trial service.

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

    Do we have any Data Protection Assurance that data will not be made available for further training?

    That is for you to review with YOUR AI provider and their terms of service.

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

    Do you already have it in the pipeline or shall I create a new Idea for allowing additional AI providers in Generative AI Services?

    Wait for the roadmap at the end, support for other AI providers is on the roadmap. Doesn’t hurt to add this to the ideas app also for us to prioritize

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

    Do you have integration with the Vector Search capabilities of Oracle 23ai? For example using the Assistant with some bigger context (apart from the page items)?

    You can post this as an idea on the ideas app. https://apex.oracle.com/go/ideas You can expand more on this and explain what kind of integration you expect to see with Vector Search in 23ai. We do have it on the roadmap to integrate the AI Assistant with the Vector Search capabilities to build RAG-based chat solutions.

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

    Do you have observations which of the 3 AI Providers perform best when creating an app or helping with SQL and debugging in APEX?

    In 24.1.0 we support using Cohere or Open AI for the "Use in Builder?" switch on AI services. The Oracle OCI AI service can be defined and used via the APEX_AI package and in the future it will also support the "Use in Builder?" option.

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

    Does AI write queries in oracle SQL? as I saw is only ANSI SQL

    The Text to SQL Assistant is configured to favor Oracle SQL. Are you referring to the JOIN syntax? That has become Oracle SQL too;In the prompt to APEX assistant, you can specify to return the query using Oracle SQL JOIN syntax instead of ANSI join

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

    Does APEX have a feature to hide page item names and values from the URL? Like URL mask?

    Instead of page redirect, you can use page submit and branch approach, if you like to hide page item names from URL. But, this comes at the cost of additional submit to the server. If you have any further questions, can you post them to Oracle Forums? In forums it is possible to provide more detailed answers

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

    Does OCI Generative AI support Application Builder?

    Extending support to OCI Gen AI chat operation is in our roadmap and we are currently focusing on this.

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

    Does assistant assume I'm using UT? 99% of people are, but I was surprised to see a CSS variable in the response

    The demo you watched happen to be asking CSS variable related to UT. AI used the variable and composed the CSS for me. AI does not know about your app theme. You need to give information to AI to give you answer related to it.

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

    Does document generator use an internal PDF engine ? Can we make a PDF with a signature?

    The DocGen pre-built OCI function has a built-in PDF engine. You can reference the Word document generator tags it supports here: https://docs.oracle.com/en-us/iaas/Content/Functions/non-dita/DocGenPBF-doc/markdown/DocGen-Template-Tags.htm An image is one of the things it supports, so presuming the signature is an image, that would be possible.

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

    Does exist a way to mix an APEX Application with a Flutter Web App without an iframe? (Any suggestion)

    Perhaps you can ask the APEX community this question at https://apex.oracle.com/forum

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

    Does the AI conversation behave in similar manner if I opt openai or cohere ? Possible to share default for gen AI to start with.

    Yes.

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

    Does the assistant help creating new pages in an existing application, or is it new apps only for now?

    For now it's only creating new apps; but APEX Assistant in the code editor DOES help you create new pages with regions that have data sources that you can interact with your AI for creating new SQL queries and such (such as chart series, etc)

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

    Does the new OCI print function support formats such as docx, xlsx and pptx? Or is it just PDF. If only PDF are there plans to extend the service to support these formats?

    The OCI Document Generator Function currently supports only PDFs. Yes, the Document Generator team plans to support multiple formats in the future releases.

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

    For chat function demoed by Stefan, does APEX send anything else than the promt and context to the external provider? ie. not sending any table info, if not used for query generatioin?

    Just what you have configured in the dynamic action.

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

    For the Document Generator, can you print multiple region types and items together on the same pdf?

    Oracle DocGen pre-built function is a PDF reporting engine that combines a Word template with JSON data to produce a PDF output. Your Report Query can include the JSON representation of data from multiple sources (which could be from multiple regions on a page), and then the Word report template can format the data in this JSON document comprised of data from multiple SQL queries in a single report.

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

    How can I connect between APEX interface and Document understanding AI for upload Invoices?

    Please refer to this livelab: https://apex.oracle.com/go/du-lab

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

    How can I create the credentials in open ai to use in the APEX ai?

    Please follow the steps described in this tutorial: https://apex.oracle.com/go/nyc-genai Lab 3, Task 1

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

    How can we set up the AI Widget so it only answers questions based on the content or functionality of an specific application? Is this possible?

    You can use the System Prompt Attribute to provide the LLM with specific instructions/context. You can learn more about it in the APEX+AI course : https://apex.oracle.com/go/ai-learn

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

    How could i use my AI to access on-premise database like ERP Databse( EBS) ?

    If you are asking about AI service to access your EBS tables and to provide custom answers, at present it is not possible. I think it will be a good candidate to post it at apex ideas website https://apex.oracle.com/ideas

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

    How does these new features related to JSON and AI work on 19c database?

    Vector Search is a feature that is specific to 23ai database, but all of the AI functionality that will be discussed today works with an 19c database. If by JSON you are referring to JSON Relational Duality Views, then that is also specific to 23ai database.

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

    How to delete all tables simultaneously when I delete an APEX test APP. Often I have problems because certain tables still exist in my database even after deleting the application?

    The "Supporting Objects" scripts for your application allow you to create a Deinstallation script that can drop all the schema objects you want to be dropped.

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

    How to enable Create App using AI feature?

    In Workspace Utilities > All Workspace Utilities > Gen AI Services page, you can define an AI service of type Cohere or Open AI and set the "Use in Builder?" switch to on for that AI Service. It will be possible in the future to also use OCI AI for the Use in Builder? but in the initial 24.1.0 release the Open AI and Cohere are the two that support this role.

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

    I am in apex.oracle.com with APEX 24, but I am not seeing the APEX assistance. Is there anything I need to do to enable that?

    Yes, you need to configure Generative AI Service in your workspace. Please refer to this livelab: https://apex.oracle.com/go/nyc-genai Lab 3 > Task 1

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

    I get “APEX.AI.UNKNOWN_BUILTIN_PROMPT - Contact your application administrator. ” when trying to use apex_ai.generate (using an already configured AI Service).

    If you are trying this from the SQL Commands window, then that is expected. The APEX_AI depends on running in the context of an APEX session for an application that is not the APEX Builder.

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

    I used it and its complex and not a scalable solution as it stores output in tables before displaying data in chat widget hence the question

    Guess that was regarding Select AI? As said, we’re not using Select AI for the Gen AI features in APEX 24.1, we’re making direct REST calls to the providers

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

    I want to make score card of EURO cup card name as group name and in each card(group) country with other detail available in table format dynamically.

    It is difficult to answer this question with the information provided. Can you please post a question at https://apex.oracle.com/forum with all the details? Thank you.

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

    I want to use new AI Chat widget to query oracle database using Select AI. Is it possible?

    No, APEX 24.1 does not make use of Select AI. The Chat Widget requires a chat experience with a backend AI service where the context is kept. In APEX 24.1 this is supported by OpenAI and Cohere with OCI Generative AI on the roadmap.;Having said that, you can of course integrate APEX with Select AI, see this blog post for example https://blogs.oracle.com/apex/post/configuring-generative-ai-in-oracle-apex-using-select-ai

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

    I'm aware of this utility but I want to use AI to give me something more tailored. is this possible?

    Yes, it is possible. For example, in SQL Commands page, keep APEX assistant in "General Assistant" mode and ask a question like below. "Can you create a package on EMP table to create, update and delete data?"

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

    If one wish to keep history of assistant responses is that possible

    We don’t support this currently.

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

    In AI chat window if we can speak and it will write, this feature is also available in most of the apps. this will help for fast typing.

    We suggest creating an APEX Ideas suggestion for this to get it onto the radar of ideas the community can vote on. Thanks.

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

    In enterprise environment: Where to set proxy server for internet access to Gen-AI provider

    You can configure a proxy on APEX instance level or for a particular application.

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

    In this case to say that the user is using the AI to draft a blog post for a BLOB that is focussed on Oracle APEX- for instance

    Yes. The use of system prompt is to set a “mission statement”, that applies during the whole engagement between the user and the assistant. In your specific example, you can tell the assistant to “focus on Oralce APEX” in the system prompt.

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

    Is AI able to get tables through database link of other scema like EBS schema?

    No, right now, AI only gets tables from the local workspace schema at this time

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

    Is SQL authoring extended to JavaScript MLE as well?

    APEX Assistant supports helping developers with everything that an APEX developer needs. When launched in a context where both "Query Building" and "General Assistance" type of help is relevant, there is a switch at the top of the assistant to choose between query building and general assistance. Use the general assistance mode to ask it questions about JavaScript.

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

    Is all of this supported on DB19c, 21c, or only 23ai?

    If by "this" you mean the AI functionality (which relies on AI services), then yes. If you mean DocGen report printing, then it requires installing DBMS_CLOUD package on your 19c database (if not already running in ADB). If by "this" you mean vector search or JSON relational duality views, then those are specific to 23ai.

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

    Is it possible to use AI to analyse stored data in the database, for example, sales data?

    We don’t support this functionality yet in APEX 24.1. Wondering if you can add this to the ideas app at apex.oracle.com/ideas

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

    Is the APEX 24.1 documentation completed for download as of today?

    The APEX 24.1 docs are live and ready to use for reference now. Google appears to have already indexed it so searches for "APEX_EXEC 24.1" find doc topics on the APEX_EXEC package in the APEX 24.1 docs already.

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

    Is the connection to Gen-AI provider done server side or client side?

    Server side.

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

    Is there a free option for the AI or can you use a local running llama3 for example?

    It's all about bringing your OWN AI service - if that is free for you already, then you can configure it in APEX 24.1 - Oracle does not offer an AI service for free

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

    Is there an option to build data model with tables creation for the project if we provide the project details?

    APEX Assistant (in "General Assistance" mode) can generate SQL scripts for candidate tables based on natural language. For example, something like "Create a SQL script for tables to support a conference management app that manages sessions, speakers, rooms, attendees, and conference editions".

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

    Is there any Oracle AI which can be used with APEX?

    Yes, Oracle Cloud Infrastructure GenAI is supported by APEX. Please see https://www.oracle.com/artificial-intelligence/generative-ai/generative-ai-service/ for details.

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

    Is there anything for End User ?

    There is a lot for the end-user. The developer can use the new AI Chatbot dynamic action to open an end-user AI assistant chat window to answer questions relevant to your particular company or app (as defined by the System Prompt you provide that gives the chatbot its "mission statement"). Stefan is about to demo this. Another use case, is using the APEX_AI.GENERATE() and APEX_AI.CHAT() methods to utilize AI services in a custom way to perform text generation or question answering to use in any way that makes sense for your application.;Check out this new workshop to find out: apex.oracle.com/go/nyc-genai

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

    Is this AI help (documentation tips) based on the same APEX version which we are using?

    I'm not sure I understand this question, but, it only works in APEX 24.1 right now, so, yes?;The answers are fetched using the LLM that you have chosen. So for instance if you are using Open AI chat gpt 3.5, it will provide you with answers that it has been trained on. We are not training the AI with custom models here.

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

    It is guaranteed that the information that passes through the AI ​​is not saved or used in training the models or in any way?

    That’s something you will have to clarify with your Generative AI provider.

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

    Multiple tables also can we used and complex queries ?

    Yes. The APEX Assistant is aware of all the tables in your workspace parsing schema(s), their column and data types, and relationships between them.

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

    My brand new installations of APEX 24.1 have the old setting in the SYSTEM_HELP_URL parameter (I usually check from SQL Plus using apex_instance_admin). I opened a discussion on forums.oracle.com about this as this Q&A chat will be lost.

    I'll take a look on the forums. Thanks for raising this with us

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

    Re: AI-Powered Applications with APEX which talks about using OCI services with APEX. However if we compare these videos with older ones (e.g. Step-by-Step Guide: Integrate AI Powered Image Search into an APEX app, there is no difference. We are still setting up Credential Store and then writing PL/SQL code.

    Integrating OCI AI Services like Vision,ODA is the same in 24.1 as in older versions, creating REST Data Source, Invoke that using Invoke API process type. In 24.1, we have made integrating Generative AI Services, like OCI Generative AI Service, a lot easier. This new approach is covered in the course.

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

    Re: DocGen documentation. We have mostly some text und may images... a few with charts but maybe we can precompile them if needed?

    You can reference the DocGen documentation here. https://docs.oracle.com/en-us/iaas/Content/Functions/non-dita/DocGenPBF-doc/markdown/DocGen-Template-Tags.htm It does support images and text.

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

    Should the system prompt be used to provide context to the AI provider - in terms of the purpose of the application and the "field" that the user is using the AI to generate content for?

    Correct. Think of it as the "mission statement" that gives the AI Chatbot it's "rules of engagement" for any questions the end user might ask.

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

    So Gen AI in APEX will not cost anything from either of the vendors? Is that really a correct statement?

    USING your AI in APEX will cost whatever your AI service charges you - nothing additional in that regard when using with APEX

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

    Thanks for the answer about APEX_PUBLIC_ROUTER. Follow-up, the account_status for this user is "OPEN" and authentication_type = "NONE". Can it be LOCKED or does it need to stay this way?

    I can't speak for the particular account, but in the general case, a no-auth open database account is more secure than a locked account. A locked account reveals information to an intruder that a non-auth account will not.;Yes, this is a no-authentication account as Connor says. It must remain OPEN in order to support Friendly URL capability.;In addition, our 24.1 Installation Guide will be updated with more information on APEX_PUBLIC_ROUTER in our first doc refresh soon

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

    The "View Documentation" buttons within APEX 24.1 (for the small handful I have tested - specifically including the ones in any of the question mark icons on the "Generative AI Services" screen) all link to 23.2 online documentation. Is this a bug or links that will be updated?

    This sounds like a potential bug. In Administration Services, Manage Instance, Instance Settings, the Help URL should be set to https://apex.oracle.com/doc241. If your instance is referencing doc232, please update the URL to https://apex.oracle.com/doc241 and we'll ensure a bug is logged to address this

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

    The AI Assistance can able to create only page and design of Page or Authentication ,Authorization also will be created based on the prompt we give?

    You can enable the features that are provided in the Create App wizard such as PWA, Push Notifications, Access Control, etc

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

    The AI assist build app is for use only in English?

    You can configure (using System Prompt) the AI Assistant to respond in a particular language;You can send the prompt in the language of your choice. As long as the AI provider you are using is trained on this language, it works.

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

    The AI assistant can speak diferentes languages?

    You can input with your language so long as the Generative AI service you selected is trained with the language. You can also set which language the responses are in.

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

    The AI model is external, correct. How does a customer train the initial model with their own data? Is the data stored once the model is generated. Does Oracle have a AI service in OCI or on premise that I can try

    Yes - such would be an exercise with your chosen AI provider

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

    The DocGen pre-built OCI function has a built-in PDF engine.". I have tried this, but the template is missing an IF option to conditionally print content. Are there any plans to improve the service? Or maybe it's already available, I checked a few weeks ago.

    I'm not intimately familiar with the product roadmap of the OCI team's DocGen pre-built function, but I think it's a fair assumption that the DocGen version 1.0 is exactly that, a first version of many to come. I also encountered the lack of conditional "template directive" type features in the current version. At the moment you would need to think in terms of conditionally generating that content into the JSON document that is supplied to the template. So the conditionality is possible, but needs to be achieved via conditional data properties in the JSON.

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

    There are IG ideas in the Ideas app on the roadmap for a long time. E.g. easier IGs for developers and unified IG/IR UX for end users. Can we expect this any time soon?

    At this time, I wouldn't say "soon". We are really doing our best to prioritize roadmapped items effectively, but with this 24.1 release, the cycle was a bit longer, and for the next, it'll be a bit shorter in terms of time.

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

    This AI Assistant Stefan showed, is this JS thing that was already available? How far can I change the look and feel and functionality of it?

    The "Open (the) AI Assistant" dynamic action is new in 24.1. It provides some options to configure the prompts that drive the assistant, the initial message, whether it shows as a dialog or a region on the page, and supports basic UT styling, but the developer does not have arbitrary control over how it looks and works. That said, the APEX_AI.CHAT() API would allow you to design a custom chat experience with arbitrary UX. The aim of the "Open (the) AI Assitant" dynamic action is making a basic chatbot very simple to achieve.;This new feature is not based on the Oracle Digital Assistant, if that's what you meant.

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

    To deploy APEX apps from gitlab and oci database, which steps or docs do I need to follow?

    The Understanding Oracle APEX Application Development Lifecycle technical paper explains what is possible and how to do it. https://apex.oracle.com/go/lifecycle-technical-paper

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

    We can't copy any page from the same workspace from one server to another. we are getting following error:Execution of the statement was unsuccessfull. ORA-02091: transaction rolled back begin wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false)); commit; end;

    That will be hard to answer here. Best is to raise the question on the APEX forum: https://apex.oracle.com/forum

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

    What LLM are you using for the APEX Assistant?

    24.1.0 supports defining AI Services for Oracle OCI AI, Cohere, and Open AI. In this initial release the Cohere and Open AI both support the "Use in Builder?" switch that identifies the AI service that the APEX Builder's APEX Assistant will use. In the future, the Oracle OCI AI service will also support being "Use(d) in Builder", too.

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

    What do I do for my data model that AI actually understands it? Comments, Domains, Annotations, proper table and column names?

    Proper table and column names help a lot. Foreign keys are also important if you want to join information. If you can’t influence table or column names, you can go to SQL Workshop -> Utilities -> UI Defaults to provide friendly names that can be picked up by GenAI.

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

    What is the minimum DB version for APEX 24.1? Also in case I don't need the AI functions

    APEX 24.1 requires Oracle DB 19c or higher

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

    When APEX 24.x will be available on Ashburn ATP databases? as of now only the ATP database on Chicago region has got updated to APEX 24.

    APEX 24.1 roll-out in Ashburn is in progress and should complete today, likely in the next couple of hours.

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

    When will APEX 24.1 be available in ADB-S? Will customer instances automatically get upgraded to 24.1 or do they have an option to keep their applications on their current version to allow testing? The early-release approach of 1 week is too short.

    APEX 24.1 is available in Autonomous Database Serverless in all commercial regions as of today. The upgrade is opt-in, see https://apex.oracle.com/adb-upgrade

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

    Which AI models offer best experience for use with APEX Assistant? Is gpt-4o sufficient for use with all features? Is there a currently recommended model (or provider such as Cohere vs OpenAI)?

    The choice of model really depends on the use cases I’d say. gpt-4o is certainly a good general purpose LLM that even does Text to SQL quite well.

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

    Which languages are available on AI?

    Generative AI in Oracle APEX leverages external AI Providers like Open AI, Cohere, OCI Gen AI (Cohere, Llama2). So the languages supported depends on the AI Provider you choose.;For example, if you want to interact with Open AI in German, you can. Or configure (using System Prompt) the AI Assistant to respond in a particular language.

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

    Why Using OCI gen AI does not support “Use in App Builder” setting?

    That is because till 10-14 days ago, OCI Generative AI did not support ‘chat’ operation which we need in App Builder. Having said that, since about 10 days this has become available on OCI Generative AI side and we’re having this on our roadmap

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

    Will there be an option for a drawer instead of a dialog or inline for display of AI Assistant?

    You can put it in a drawer region and use the “Inline” option of the “Open AI Assistant” dynamic action.

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

    Would it be possible to talk a little of what is availble in the AI-features if internet access is not OK as well as what is working if not paying for it is approved?

    APEX does not charge you for using Generative AI. If you have a Generative AI API key, you can use the key in APEX. APEX Generative AI features do require Internet access so that APEX can communicate with the Generative AI services.

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

    apex_ai API is not available at apex.oracle.com. What is the reason for that?

    What kind of error are you getting. The apex_ai PL/SQL api is available on apex.oracle.com

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

    is it possible to use AI in an on-premise environment?

    Yes, you can configure AI endpoints / services under workspace utilities of your workspace.  All you need to do is to configure Generative AI Service at the workspace level and provide valid credentials.

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

    is there a specific planning when to upgrade Oracle REST Data Services Docker to APEX 24.1?

    Oracle APEX 24.1 requires ORDS 20.x or later. The use of Quick SQL requires ORDS 23.3 or later. You can decide when to upgrade based on the current version of your ORDS

    #MISC#
    #ACTIONS#

Featured Speakers

Workshop Info

Session Has Completed - 20 June 2024
1 Hour
English
Oracle APEX Service

Other Upcoming Sessions

Hidden Translations

Join
Share
Register
English
Unregister
Outline
Objectives
Resources
20 June 2024
Session Has Completed - 20 June 2024
You Are A Speaker/Panelist
1 Hour
Pending
Prerequisites
Waitlisted
Rejected
Question And Answer
Register And Join
Add To Calendar
Registration Status
Series Name
Session Time
Log In To Register
You Are Registered. You Will Be Able To Join The Session 15 Minutes Before It Starts.
You Are Signed Up for the Lab
Sign Up for Lab
Remove Lab Sign Up