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

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

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

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

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

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

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

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

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.

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

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

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

The Text to SQL Assistant is configured to favor Oracle SQL

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

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.

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

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

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.

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.

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

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

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

https://apex.oracle.com/ideas

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.

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.

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

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

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

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.

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.

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

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

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

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.

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.

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

Yes.

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)

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

Just what you have configured in the dynamic action.

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.

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

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

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

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

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.

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.

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.

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

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.

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

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.

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

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?"

We don’t support this currently.

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

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

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.

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

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.

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.

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

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.

Server side.

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

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

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

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

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.

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

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.

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

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.

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.

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.

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

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

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

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

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.

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.

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

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.

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.

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.

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

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

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.

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.

APEX 24.1 requires Oracle DB 19c or higher

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

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

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.

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.

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

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

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.

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

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.

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