I am configuring OCI Email Delivery for an APEX application I am developing in my Always-Free Autonomous Database. I am using a Custom Authentication scheme and the users in my APEX application are defined in a *database table only* with authorization schemes also running from there. I am following the guidelines from Configure OCI Email Delivery. Looking at creating SMTP credentials, it seems as if I will need to create a User in the OCI console for every user in my application that needs the ability to send an email. 1. Am I reading this correctly? Is there a way to avoid this? 2. If this is the only way to go about this, what other privileges will this OCI user be granted in my application / OCI interface etc. that I need to look out for. Thanks!

Hello, can someone please guide if there is a way to have a date-picker for months and years only in Apex 21.2?

Do folks use apex_util.set_session_state or apex_session_state.set_value? for a simple varchar2 it seems the same, and has always confused me why there's two options

I have an APEX question that will open up a LOT of cans of worms.. Its to possible move towards using APEX to build a CI/CD process to replace a rather convoluted manual process when migrating objects (APEX apps, pl/sql scripts, PL/Sql Packages) from SVN (possible git-lab in future) into higher environments (Devl => Test => Formal Test => Prod).. This I know would entail at a minimum using Jenkins and other software which is why I am asking here.. Has anyone every tried build an APP to handle this with a workflow to handle user approval when required?

OK this should be easy. I have a button that I want to use to take me to another website. Let's just say it's https://google.com I have that URL in another field and I want my button to take me there in a new browser tab. the button is in a modal dialog page and when I hit that button I get https://google.com in my modal dialog page not in a new tab of my browser. Is there some secret sauce ting this to work?

APEX 24.2 Page Item of type Popup LOV, multiple values, ':' delimited and trying to use DA associated with a Button to cause all possible matches to be selected in the Page Item. The DA does a select into the Page Item using the same criteria as the Popup LOV, generates a ':' delimited list into the Page Item but then errors with "ORA-01722:invalid number". Tried using Debug but not enough information in the error detail to nail the problem down, same with reviewing the console. It seems to error after exiting the PL/SQL DA code. SQL is below. Can I assign multiple values to the Popup LOV like that? Debugging shows the resulting value looks like 2152:3450, which are correct.

Select 	ListAgg(Ben_Group.SY_Associations_ID, ':') Within Group (Order By Ben_Group.SY_Associations_ID)
  	  	Into 	:P109_BEN_GROUP_SY_ASSOCIATIONS_ID_LIST
        From VW_EPRPlan_Benefit_Groups Ben_Group
        Where     Ben_Group.EPRPlanLink_ID = :P109_EPRPLANLINK_ID
             And :P109_EXPIRE_AS_OF < BG_Expires
        Order By BG_Expires Desc, BG_Effective Desc        ; 

Apex 23.2 I exported a single page with an Interactive Report with public "Saved Reports". On importing into another environment the Saved Reports were not included. I don't see an option to include saved reports when exporting individual components or when exporting the page from directly within the page, unlike when you export the entire app where that is an option. Is there some way to do this?

Hello fellow APEX people. Looking for some advice on Tasks if possible. In particular, I am wrestling with Business Administrators. We are anticipating a shuffling of responsibilities internally and need to re assign Business Administrator participants for all of our open task instances. Can't send to find any way of doing this in the documentation, nothing mentioned in the APIs. Does anyone have any ideas? Or, is this a matter of cancelling and recreating all the in-flight task instances after updating all the participants in the task definitions. Any help would be greatly appreciated.

Hello everyone, please help me clear the certification in apex developer.

Hello, guys. Martyn from Brazil. I'm looking for a solid long-term entry-level/mid Oracle Apex developer role to work remotely. I'm higly commited and with good references and 15+ years of experience with IT. If someone has a place to me in your team, would be good. https://linkedin.com/in/martynf- Thank you.

Does anyone have model exam questions for Apex Professional Developer?

I'm new to Apex, so why am I having this problem?

Hi all, first time here, apex newbie.. I've a page with editable field (i saw on page designer something releated to dynamic actions). After upgrade from 4.2 to latest 24.2 when i insert a new value (280€ in picture) and i click on "apply changes" nothing happend.. Or better, there is a window with an OK that indicates that the action was successful. I tried to debug behavior but i don't see any obvious errors. Where can I begin to figure out what action isn't being taken? Could it be some instance-level ACL? Thanks.

Just curious but I'm trying to duplicate my application. On the source side (where I developed it) I'm generating a DLL for everything. My thinking is that this one DLL script will create every table, sequence, procedure, function, etc. in the new schema. The problem appears to be that the resulting script it too big to work with. When I do manage to generate the DLL and copy it to my new workspace I get an error that it's past the 500K limit. I know i can cut it into pieces, and I'm doing that, but i wondered if there was a better method out there. I'd have to admit that I find the "Generate DLL" function pretty flakey. Sometimes it works, sometimes it doesn't. Sometimes it follows my selections and sometimes it does not. That or I completely suck at using it.

I had a fellow developer ask me.. Is there something we can ADD the the APEX builder to designate what ARE the developer is working in? We have a number of development areas and on occasion someone flubs up and thinks they are working in one environment when they are really in another..

I have form which has only EMP_ID page item but on that page item I set value dynamic action and set other page items for display but when I switch pages it loads the data so is there anyway to get data on emp_id quickly without loading others items because it is not good UI

Hi everyone :slightly_smiling_face: I'm wanting to implement automated tests in my frontend. I've found some alternatives like cypress, but it will help me very much to know your experiences and what do you recommend to achieve that in a comfortable way. Thanks in advance :slightly_smiling_face:

I am trying to get the error message to only display once either by the applicable page item or as a popup message. For some reason "Inline_with_Field" is showing up twice, and inline_in_notification shows the message twice in the upper right corner. Thoughts?

Happy to be here! ... I have a very Basic Setup , it is our favorite ACME Shop , I am trying too Display The CART content in Same Page as Product , the Cat Item I made a Classic Report , On Click of Add To cart , How I can refresh the Classic Report ?

Any other things I could try or ways I could see what the issue is?

In the past I've used some combination of hints like /*+ parallel(n) no_merge first_rows */ with some success. Or wrapping the query in a "select * from (x)" with the no_merge hint. I see the new "Optimizer Hint" field and have tried putting the hints there or using the suggested hints from the help text (APEX$USE_NO_PAGINATION as discussed here: https://blogs.oracle.com/apex/post/application-express-18-and-report-pagination)

I'm trying to troubleshoot some report queries that are very slow within apex. They return within seconds in SQLDeveloper but as a Interactive Report run for multiple minutes or hit some server side timeout before they can return.

Hello APEX experts. I have a question about multi tenant/customer deployments. If I want to deliver a single application to multiple customers should I 1. Deploy each customer in a separate instance so I can set build options by customer? 2. Deploy all customers in a single instance, storing the customer ID in key tables to control data access? it seems to me the issues with #2 are: 1. The lack of ability to utilize build options per customer 2. The lack of ability to utilize different URLs for each customer 3. The additional complexity of having to store and retrieve data by customer ID With #1 the issues would be: 1. The need to create a separate schema and workspace for each customer 2. No easy way to aggregate data and app usage statistics across all customers Is there a recommended APEX deployment model? What have others done? TYIA.

General question that doesn’t show up in the Docs. When configuring the Maximum Web Service Requests at the WORKSPACE level, I’m assuming that leaving it blank will revert to the limit as defined at the INSTANCE level. But what if the INSTANCE level is left (or set to) blank. Does that give an unlimited number of web service calls? This would be my desired result, but I don’t want to make a false assumption

I recently began learning Oracle Apex; any advice, suggestions, or tips are always appreciated.

Hello everyone i have an issue with this test-code:

-- Setze globale Parameter-Variable
var params CLOB;

begin
  :params := '
  {
    "provider"       : "openai",
    "credential_name": "litellm",
    "url"            : "http://litellm.devki.com:4000/v1/embeddings",
    "model"          : "text-embedding-3-large"
  }';
end;
/

-- Test per PL/SQL
declare
  input clob;
  v vector;
begin
  input := 'Hello world';

  v := dbms_vector_chain.utl_to_embedding(input, json(:params));
  dbms_output.put_line(vector_serialize(v));
end;
/

-- Test per SQL
select vector_serialize(
  dbms_vector_chain.utl_to_embedding('Hello world', json(:params))) from dual;

it always said credential not exists but in my remote-server credentials it’s exists. Is there a problem with own hosted LLMs. I’m in a closed network without internet access!

I've heard that APEX Autonomous Database has limits per CPU for # of concurrent users. Does anyone know what those limits are? If I have 2000 users, how many extra CPU's do I need?

Hello Everyone, If we are hosting python application on OCI, then how to use Devops with the SCM and CI/CD pipeline applicable between OCI and APEX. Does anyone implemented this in your projects?? Kindly suggest!

How can i force CSV downloads to be UTF-8? Apex 23.2

Hi guys, I'm working on excel upload functionality. But I have 2 tabs in my excel, how do I upload data from both tabs?

Post Calculation Computation - I used this in apex 5 to update a "Display Only" item to change a user ID to a Display Name (via function call in an expression). Now it's deprecated and not available for new items in Apex. I see a recommendation to replace it with a computation, but I can't get it to update the displayed value on page load no matter what execution point i use. It seems to me the only way to replicate the PCC functionality is to have two items, one hidden that has the value sourced from the database, and the other a Display Only item with the value calculated from the first item. This is obliviously worse then using a single item with PCC. Is there a better way to do this?

hello All, Can someone please tell me what is wrong with this reference to the page item P600_COLUMN_TO_SHOW in this code? The query is for a simple classic report region, PLSQL function body returning SQL. That Item contains the columns to use in the query. If I hardcode it works but if I use v() function it doesn't work. Apex 19.2

@Jayson Hanes - Oracle APEX PM thx for the hint seems good :slightly_smiling_face:

note from Dev on this

There is no reason for it. You can workaround this bug by using apex_application_admin.set_remote_server(). bug # 37689711

Cloud databases cannot make HTTP requests, only HTTPS ones

Yes

Hi @Andi Oberhauser , your database is probably autonomous transaction from cloud right?

Hello everyone - I have a simple bug. When I create a Vector Provider I always get the error that the base url have to start with HTTP or HTTPS. When I use https it works with http not. But in my environment I need HTTP! Any ideas?

:rocket: Introducing MC CHATBOT - AskAssist for Oracle APEX :brain::speech_balloon: I’m excited to share my latest APEX plugin: MC CHATBOT - AskAssist – a smart, predefined Q&A chatbot built for Oracle APEX with a modern UI/UX. :small_blue_diamond: Key Features: Predefined main questions, sub-questions, and answers Dynamic Ajax-powered response system Seamless integration with Oracle APEX Clean, responsive UI for great user experience Ideal for FAQs, onboarding, lead qualification, and guided user flows :link: GitHub Repository: :point_right: https://github.com/mishab424/MC-CHATBOT---AskAssist :dart: Live Demo: :point_right: Launch Demo :wrench: Easy to install and customize – just import the plugin, create tables, and plug it into your APEX page! Feel free to try it out and let me know your thoughts or suggestions! :envelope_with_arrow: For customization or enterprise use, contact me on or at

:newspaper:The August issue of APEX Newsletter is live! Read the latest updates, new ACE series, community posts, and much more! apex.oracle.com/go/august-2025 #orclAPEX #LowCode

Hi, hello everyone! I look forward to learning Oracle APEX. Please guide me in learning it and suggest some free online resources

:wave: Hi everyone, I'm Richard, an Oracle APEX developer from Slovakia. I work mainly with APEX and PL/SQL, and lately I've been trying to be more active in the community. Looking forward to learning from you all and contributing where I can!

Is there any plug-in or process or way to compress images before upload ?

In OCI, does anybody know if ATP (APEX workload type) can be used with Oracle Data Safe?

clicking "Publish" for MLS Translate receiving below error. Where can I see the log in *autonomous* for the issue? Uploaded XLF file and "Apply checked". Next when clicked "Publish" getting error. This is working on simple application with one page. But failing on our real client application. Appreciate any clue.

Hi, With Interactive Grid is there a way to toggle row selection behaviour from multiple (checkbox) and single (radio field) at runtime? Thanks

Hello We need to update our authentication method to use *OpenID Connect (OIDC)* with *Proof Key for Code Exchange (PKCE)* to enhance security and compliance. Has anyone implemented this already or explored potential workarounds? I'd love to hear your thoughts or experiences on: • Integrating OIDC with PKCE into APEX apps • Handling token exchange securely • Tips or resources to get started Any ideas, documentation links, or working examples would be greatly appreciated. Let’s collaborate to get this set up smoothly! :raised_hands: Thx

I have APEX version 22.2 and I'm working with SQLcl to deploy applications. **Problem**: When I deploy an APEX application using SQLcl and run the fXXX.sql file, I have no way to programmatically set the Parsing Schema. The application always defaults to the first schema in the workspace schema list, but I need it to use a specific schema. Is there an API or installation parameter that controls this setting? Thanks! ????

Hi, has anyone also had the problem that the icons in APEX disappeared? It looks like this for me, also in different browsers.

Hi guys, is it possible to expand collapse the desktop navigation entry by clicking the whole label, I am able to do that only by clicking the small arrow, but not the whole row or label. It’s Universal Theme.