I don't suppose anyone has figured out a way to make a select list stop functioning (intentionally)? I want my drop to still look like a drop down, but no matter what you do it won't work, you cannot change the contents. I've managed to get the field to not be tab-able, and I can of course disable it. But if I disable it then the contents get erased on page close. I have managed to make it "hard to get to it" but with the right mouse clicks and tab keys I can manage to get to the field, then an up or down arrow will make it change. I want it dead, like that plant over there in the corner of my office, or that bicycle I ran over. I've tried: pointer-events : none cursor: not allowed user-select: none tabindex="-1" This works, you can't tab to it, but you can still change the value with an up or down. document.getElementById("P126_SELECTOR_LIST").readOnly = true; And none of these work Is the only way to do this is by creating an alternative field that is not a select list and it only appears when I want it to, (and when the actual select list field does not appear. So you get one or the other.)? Is this how other people do this sort of thing? Is there really no CSS variable or style, or whatever that will switch off a select list while not changing the appearance of it?

APEX_APPLICATION_PAGE_IR or APEX_APPLICATION_PAGE_IR_RPT looked most likely to me

Is there an apex view that has the Interactive Reports "Optimizer Hint"? Apex 23.2. I can't seem to find it.

A happy morning/afternoon to all! What channel would be the best to ask about Oracle Apex sign on authentication (like social sign in, etc)

Good morning, All! Is there an APEX channel I can subscribe to get more understanding and information on leveraging GenAI for APEX Reports? Thank you!

I'd to implement a multi-step login process like the new one at Oracle Support where you first enter the username then, on a new page, the password. I think there is more going on in the background than simply showing a different form (ie. checking if the username is registered somewhere) but APEX login process scares me. Any suggestions on where to start? Thanks all!

Hi all, general question about Oracle Reports. Doing an evaluation project of migrating existing Oracle Reports reports to other technologies. Really old stuff, they are developing them on Solaris with Reports 10.1.2.3 (from 2005 I believe :wink:). Does anybody still have install files for 10g lying around? Download is only available from 11g onwards, and they all require this huge setup. Once I am done, Report Builder always crashes silently in ca.dll. Been fighting this for two days now. Would be a great help, thanks all.

I am currently planning to upgrade APEX and ORDS to the latest versions for our on-prem environment. I have all the instructions that are needed to upgrade each individually, but which upgrade should be performed first? ORDS or APEX? Versions in our current environment: APEX: 23.2.2 ORDS: 23.4.0

Hi All, I posted this recently, but no replies. I want to investigate more fully migrating our APEx application to the Oracle cloud (paid version), Until now, Ive been using Always Free OCI Tier and APEX to test. At the beginning of October I started getting *Database Connection Error HTTP Status Code: 571* when I try and log into the Database using either APEX or SQL. Its been permanently like this now since then, so my APEX environment is unusable.. I can get into the database using desktop SQL Developer, so the database is running. I've asked on the Oracle community, but haven't got a response. As its a free tier I can't contact Oracle support. Does anyone have any ideas on how I can fix this?

Howdy folks. We are looking for an infrastructure heavy, Senior Systems Engineer. US only & W2 only. - Fully Remote Use "Matt McGee" under Current Employee as how you heard about the role if applying. https://fullsteam.wd1.myworkdayjobs.com/en-US/External/details/Senior-Systems-Engineer_JR101876-1

Hi, I am using Oracle account to access forums - https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex?tags=apex-discussions -- However when I log in now, I get - *Your 2-Step Verification methods are no longer valid. Contact your system administrator.* I have an individual account, NO System Admin, No Cloud accounts.. How to reset MFA.. Please suggest.

:newspaper: *The December 2025 APEX Newsletter is out now!* Featuring 23K+ APEX certified devs, VAN group success story, and much more!

For the debug messages in utilities -> debug messages (or APEX_DEBUG_MESSAGES), is any session state also captured? eg page item values.

Hello, someone working on a logistics app. I need some references like UI and UX. And features

Hi all, can someone please tell me how to set up an API call to our stored procedure to get the list of available products. I already have the Json format of the function to call, but how to make the configuration at ORDS level? And which URL to call? Someone has an example? Our database: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

Quick poll. Is anyone (still) using PL-jrxml2pdf ? > :+1: Yes > :-1: No

I hope this message isn't against the rules but I really need to get this sending emais thing working. I'm on a new OCI account and I need to be able to send emails. I'll pay for the help, so if you're willing to do a Zoom or whatever and you can get it working ( I don't own a domain, and I don't care what the senders email address is ) then I'll pay you.

Hi All, Ive been using Always Free OCI Tier and APEX. At the beginning of October I started getting *Database Connection Error HTTP Status Code: 571* when I try and log into the Database using either APEX or SQL. Its been permanently like this now since then, so my APEX environment is unusable.. I can get into the database using desktop SQL Developer, so the database is running. I've asked on the Oracle community, but haven't got a response. As its a free tier I can't contact Oracle support. Does anyone have any ideas on how I can fix this?

UC – Interactive Grid Add Button (Selection Action). How to hide/unhide based on column value? Hi, I am using the *UC – Interactive Grid Add Button* plugin to add a button inside the *Selection Actions* menu of an IG. I need to *hide or unhide this button* depending on selected rows. Condition: *if one or more selected rows have COLUMN_NAME = 1*, then hide (or disable) the button. If none of the selected rows have that value, show the button. The issue is that Selection Action menu items are created dynamically by the IG, so I cannot find a stable static ID and normal jQuery selectors like:

$("#documents_ig_selection_actions_menu_4i").hide();

do not work. What is the correct way to dynamically *hide/show a Selection Action button* created by the UC plugin based on IG selected row values? Thanks.

I'm building a semi-large application for both customers and employees with a single login point (using a custom authentication provider, but APEX authorization). Lets pretend i have 3 apps: • Login • Customer Portal • Employee Portal How can I dynamically read and re-write the "post login url"? I found some references to FSP_AFTER_LOGIN_URL but they're pretty old

I hate being the dumbest person in the room, but here goes. (try not to laugh) Is it possible to get sending emails from APEX working when I do not own a domain? I don't care if the emails are coming from or any sender at all. It doesn't matter. I just need it to work. I'm only sending emails to myself for now anyway.

One more dumbass question. Is there some reason I can't change the password on a Workspace Administrator account? I've tried it as that user (it's my second account for testing). I've tried changing it as a different administrator account inside the workspace, I've tried it from the admin console, and I looked for a way to do it in the OCI console. There must be some secret way to change these passwords. I do see a "*reset"* in the Admin console but only for regular users. That option is not there for Workspace Administrator accounts. So how is it done?

I'm wondering if anyone has had challenges with the data packager? I have an App that I'm trying to move to a different OCI account The workspace has maybe 75 tables with as many as a few hundred rows in some of the tables. When I try the Data Packager it looks like I get a script that will create all my tables, but it won't move the data. Nowhere in the resulting script do I see any "*insert into*..." lines so I don't see how that data would be included in that script. I'm wondering if the Data Packager has some sort of a limit on size or something like that. Is there some other way to pull an entire workspace from one OCI account to another? Every application, every table, all data? Preferably as one large digestible clump.

Hello everyone, I need help with the editable interactive grid. I have DOB and gender columns in grid, I want to store them in encrypted format for which I'm using custom function before inserting. I'm using decrypt function to show data. The problem is I have to use same grid to edit column to update data in encrypted form and show decrypted data at same time. How can I resolve this?

Good morning! I request your help to update to the latest version of APEX in my local installation. I’m trying to upgrade APEX from 24.1 to 24.2. I have performed the standard installation procedure, and it completed successfully without errors. After installation, I usually update the Universal Theme in the applications. Before updating it, the applications seemed to work fine, but once I update to the Universal Theme, issues occur — ranging from the theme not being recognized as "current," which causes me to lose access to the application, to certain templates not being updated. Previously, when upgrading to a higher version of APEX, this was never a problem, but I must be missing something now. Has anyone else experienced this same issue I’m describing? How can I upgrade without encountering these kinds of errors? I appreciate your help in advance. Best regards.

I've been struggling with modal dialog stretching & zooming. A user likes to run the app on 1/2 of their screen and complains about how words start escaping their bounds. Like the words in buttons spilling out of the button, or adding a line-feed. I have told them to shrink the size of the window running the app on their desktop and then zoom in or out with the Chrome zoom function. That works just fine for me but I was wonder what other developers do to address this? I'm totally guessing, but is it common practice to put the *col-xxs-12* on an entire modal dialog, or on every one of the regions (assuming that all are 12 columns wide) inside the form? Is there some setting that tells Chrome to change the font size based on the screen size, or something like that? I'm not using any fixed font sizes. I'm just using default, larger, x-large and xx-large all over my app. What is common practice in this regard?

After 10 years I couldn't find anything @maxime_tremblay coulnd't fix, I'm running out of time :grimacing::relieved::sweat_smile:

We are back in business @maxime_tremblay fixed it. We ran out of space, because the Audit Trail reached 6+ Gig. He moved the data file, changed the location of the config. Deleted the old file and reclaimed the space of the new table space. Or something like that :smile:

We have issues with apex.world, we are working on it, it's a new error, didn't go away even after restarting everything. We let you know. Slack is not affected though

Greetings everyone , have anyone tried to integrate OpenAI API with oracle apex workspace for Ai assistant chat to help in Sql builder and page designer ?

Hi all, Is there a way to add a timeout to HTTP request from PL/SQL? Oracle 10g Enterprise Edition. I googled, and it said I should use UTL_HTTP.set_transfer_timeout(l_req, 15); but it doesn't work..

Is there a setting someplace where I can tell my application to record the size of my modal dialog pages? So if I open a modal dialog and i resize it I'd like that to be the same the next time I open that same modal dialog page. There must be a global setting for this somewhere, right? if not then how is that done for every modal dialog in my app? Especially since the majority of my pages are Modal Dialog.

Hoping someone has a clue on this one. I have an App that I've been developing for quite a while. I stood up a new schema the other day and I built a copy of my app. I built all the tables with a DDL script in the new schema and populated the tables I need for the app to run in a "brand new deployment" manner. It runs just fine and the setup was pretty uneventful. So then I returned to my development schema and made some changes to a page that didn't work out so well. So I thought I'd just pull back the page from my fresh schema I created just two days ago. So I logged into my dev schema and I deleted the page in question. (Yea, I know, I should have made a copy). From my new schema I exported the page I need and now I'm attempting to import it into my dev schema, and I get a pretty hard error. I'm not expecting anyone to fix this, but I have no clue where to even look for the error that's causing it. My Oracle APEX programming interface completely freaks out. It's the same app, and I'm just pulling back a single page. Does anyone have a clue why that might not work, it sure seems like a basic thing for me to do, no?

does it bug anybody else that ideas get closed and probably never looked at again? I've seen several with "good idea, but we can't right now". just feels like it's getting thrown in the recycling bin with the rest of the failures

Apex 23.2. A classic report with a blob download. Was working under 5.1, I can't be sure anyone has used this since we upgraded to 23.2, but now some of the links work and some don't, instead I see the following in the "downloads" in chrome:

QCI specific question. Anyone have any insight on a Always Free DB That is failing to start up again?

Hummm interesting. OK I'll ignore that one. Thanks so much.

I'm hoping someone can get me pointed in the right direction here. I am seeing JS errors about a deprecated feature being used, looks like an unload listener, but I have no idea what I'm talking about here. Is this a known thing and is there a fix for it?

Have you ever created a Heat Map in APEX? How feasible is this using Oracle JET? I’ve been trying to do it by modifying a Scatter Chart, but without success. Thank you. https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataCollections&demo=heatmapGrid

When I create a workspace on OCI, it creates 2 schemas (eg: WS and WKSP_WS) and wksp_ws becomes the parsing schema with all the privileges and objects. The WS does not have any privileges or objects. What is the purpose of this WS schema, is ti required and can it be dropped without breaking anything? What is the role of APEX_PUBLIC_USER and APEX_PUBLIC_ROUTER? Are these used for impersonation in the 3-tier architecture and routing requests? Which schema gets used at runtime for DML? Is wksp_ws used only at design time in the builder for DML and DDL?

Is there a way to make a typical text field un-editable but not disable the double click DA on the field. I've tried setting the field to read-only and I've tried : document.getElementById("P126_CREATED_DATE").readOnly = true; as page load JS code. These do prevent editing, but they also make the double click DA I have on the field not work as well. So I'm wondering if there is some other option I could use?

I was wondering, I have a page where I'm calling other pages using a button. All that works perfectly but when I close the called page I execute some DAS's. Is there any way to know which page I'm returning from? So I hit one button and I open Page 7 and then return. I hit a different button and I that opens page 41. Is there a way to trigger a DA based on the page I returned from? So if I come back from P7 a DA fires, but if i come back from P41 a different DA fires. Is this possible? Is there some hidden variable that contains the page I just returned from?

Hi team, I’m currently in a pickle. 1)I need to take a screenshot of the entire screen and convert it to a PDF. 2)Store the PDF in a table and send it as an email attachment. In one process or say on click of one button I can handle the second part, but does anyone have an idea how to achieve the first part?

Please let me know about UI/UX resources.

I'm sure it's just me, right? But I want a button that floats over my page that has a bunch of tabs in it. So, like a normal human I ask Copilot how to do that. I ask "How do I create a floating button in Oracle APEX?" and Copilot responds with this... So I try it and there is no position of "Floating or Inline with template" that I can place my button into anywhere in the APEX application builder. Sometimes I really have to wonder about these research services that claim to be so wonderful. It just tells me what it thinks I want, the fact that what it tells me is absolute non-sense doesn't seem to matter much. Was this option EVER true? I want a button on the side of my page that will show no matter what tab I'm on, I hit that button and it opens a region while passing the tab name I was on when I hit the button. Both questions I asked of Copilot came back with useless and fundamentally wrong answers. The bots will be the last thing left alive after the robot invasion. Skynet has arrived. Earlier I asked Copilot for how to tell which tab the user is on and it said "Sure just use the *:TAB_NAME* variable". The fact that the :TAB_NAME variable does not exist seems to be irrelevant.

Apex 23.2 We have a bunch of interactive reports that have grown and gotten to slow to be run in real time. We have done various things to speed up the run time but I think some of them need to be turned into a background job with a download of the resultant data somewhere. Is there are "shortcut" to turning a IR into a background job?

I was wondering about something. I have an on-screen variable that is a file upload type. It is set to use the APEX_APPLICATION_TEMP_FILES as the storage. But I have a feeling that some action needs to take place to get it actually written into that table. I never see my file in there. Is there a DA of some sort that I need to run to actually store the file in there?

Hello everyone, I am trying to change the decimal separator from a comma to a period in a translated French application (fr-ca). I am using the following code in an application process _On Load: Before Header_:

DBMS_SESSION.SET_NLS('NLS_NUMERIC_CHARACTERS', '''.,''');

However, I receive an error when running the French version of the application (see image below). Does anyone have an idea of how I can resolve this issue? _Note: It works correctly when French is set as the application’s primary language, but not when it is a translated application._ Apex Version: 24.1.3

Is there a way to set a name on these columns? I mean, to display a name inside the bars. I’ve been experimenting with the Custom Column attributes and the Initialization JavaScript Function, but without success, but the way the name of the serie is the text that I want inside the bar. select ..... '{"customText":" '|| name || '"}' as custom_column from table ....

Hello, I'm trying to get a session ID in OCI AUtonomous Database environnement but I don't have enough privilege Any idea how i can do that ? select * from APEX_240200.wwv_flow_sessions$ ; grant select on apex_240200.wwv_flow_sessions$ to myuser;