We have Oracle APEX with some RESTFUL webservices that expose data. Any document on steps/guidence to expose RESTFUL webservices to EXTERNAl? • We only want RESTFUL webservices to be exposed and not APEX application • Want to make sure APEX-database and applications are not accessible Thanks

Hi. In APEX 24.1.5, I am calling a PUT REST API for a Page Process, and am having trouble displaying the returned error text. e.g. in the attached screenshots: The Page Process uses "Invoke API" (1) of a REST Source (2), which returns an OUT parameter "errmsg" (4), which it stores in page item P431_ERRMSG. (5) The Error Message for the Page Process is configured to be &P431_ERRMSG. In testing, when the REST API returns an error (status_code=400, errmsg='some error text"), the apex page doesnt display the expected error, but rather show shows this error: *1 error has occurred* • undefined I believe this is because P431_ERRMSG is not in the session state. What is the proper way to return and show a custom errormessage from the PUT REST API for a Page Process? Kind Regards, Alister

Hello friends, any one had faced before the issue in creating interactive grids when uprgared into APEX 24 and ords 24: Unable to create the Interactive Grid page. ORA-20001: call=wwv_flow_imp_page.create_interactive_grid, id=[NULL], component=1860007786505768, sqlerrm=ORA-01400: cannot insert NULL into ("APEX_240200"."WWV_FLOW_IG_REPORTS"."ID")

Hello everybody, I have installed APEX with ORDS 24.4 with db 19c, everything went OK, if I run it as stand alone it works, but if I run it using weblogic, I got the below screen, app unavailable, the logs says that : INFO No pools configured yet, any ideas?

Related, is there a way to only fire a page 0 DA on page change? That is, going from page 1 -> 2, fire DA. Going page 1 -> 1, don't fire.

apex.event.trigger( "#P0_MYITEM", "apexrefresh" ); Item loses it's current value. Any way to keep the value?

Hello folks, I don't see a dedicated channel for Generative AI in APEX, should I create a new one?

Interactive Grid doesn’t show all rows when pagination=scroll APEX 24.2.0; Modal page The funny thing is when I change the page from modal to normal, it works. How can I fix this in a modal dialog?

and when i select a region in region selector 1 the selected regions in regions selector 2 are gone

greetings everyone , in oracle apex page designer , when I make more than 1 region display selector , the tabs of each region display selectors are shared in both region display selectors

I’m about to reach my wit’s end. I’m using a static content region to try and render some HTML that includes handlebars style markup. However, when the region renders, it looks to be parsing the content of my HTML Region and trying to be smart about Closing the tags. This is causing it to move tags and content around. Details in :thread:

I can't remember if I ever asked this here, but has anyone ever implemented a wiki with Oracle Apex?

I have a form that is collecting files, the file upload item is optional, but suddenly, the form started to change when a file is attempted to be uploaded. No error is displayed; the form just does not submit. Has anyone had this issue?

Hoping someone can help me out. I'm looking to change the label and the colour of a button on a form without having to close and re-open the form. The button is P297_BUTTON and it's using a hidden field for the label meaning the label of the button is *&P297_BUTTON_LABEL.* The colour of the button is P297_BUTTON_COLOUR. I'm using a CSS class in the button attributes to set the colour of the button. The P297_BUTTON_LABEL and the P297_BUTTON_COLOUR variables are hidden fields and they get refreshed / changed on a dialog close or cancel. What I want is to get the new value of *P297_BUTTON_LABEL* into the button and the colour of the button to change as well if the value of P297_BUTTON_COLOUR changed. There is no DA that will refresh a button, as far as I know anyway, so I'll have to assume that a JavaScript can do it. Could someone please help me figure out how to do this? I suck at JS scripting so a little hand holding would sure be awesome.

How to Allow multiple search patterns in Popup LOV for automatic search i.e. %email, %email%, email% Starts with, contains. Currently using apex version 22.1.7

I am currently using BI Publisher Desktop for reporting purposes in Oracle APEX. However, after upgrading to version 24.1, it appears that HTML tags, such as the <table> tag, are no longer being accepted or rendered properly. Could you please advise if there is a known fix or recommended workaround for this issue?

Just a heads up to anyone looking for an APEX Gig.. stellentit.com is recruiting for a Dept of Interior position, and claiming to be the prime contractor.. They are NOT the Prime.. The prime is a company called Teksynap... Teksynap has a BAD reputation due to the way they treat their IT staff.. I would recommend staying away from them due to this fact..

Hello, how is the best way to compare 2 Apex Applications? I have 2 Apps: 111 and 140. They were same, but changes have been made in both recently. I am no longer sure what features are included in each of them. The export files are hard to compare because of many different internal IDs. We are still on Apex 19.2

For those that may have missed it, the new version of APEX-SERT is now available. Have a look at my blog for more details: https://spendolini.blog/apex-sert-now-available

I'm working on prepping my applications to move to 24.2. We had some initialization javascript in our TinyMCE rich text editors that basically enabled the browser's baked in spellcheck. ORTL (the primary rich text editor now) is based on ckeditor5, which only has a paid plugin to do spellcheck. I've been searching for the right method or option to set to re-enable the browser's spellcheck, but can't find anything. Has anybody uncovered this yet?

So here's a quiz for your Thursday... I've never been able to figure out what this region setting does exactly. I can't see any change at all on my page. If the header is "accessible" then how does a user actually see that header? This is just a simple region on a form.

Best way to allow multiple users to update same data? We have an app that has organization level data where we allow users to enter data that will calculate based on those inputs. This works on the overall organization level, but there is a case where two different users might want to enter two different values. This obviously overwrites anything someone already entered. I thought I could get around this by using collections, where the user can use the collections to 'test' out their changes before the organization decides on the final, but I am under the impression that these are only for the session state. The users want their values to stay, and even be able to have multiple versions. Is there a good way to do this? I am thinking maybe use collections, and then allow them to click a button that saves that collection as new rows so they stay there?

Hello all, I have a question regarding the autonomous_transaction. In the following situation, the function DUMP_CSV_STG is declared as autonomous_transaction. Will the main code continue running (here block1, block 2, block 3), while the DUMP_CSV_STG is executing, or the block 2 waits until the the procedure DUMP_CSV_STG finishes, before continuing running: block 2, block 3? Hope question is clear. The reason for knowing this is that, we are logging the time the main code takes to run the 3 blocks. So if we add that procedure and this takes a lot of time, it might affect the execution time of the main code.

declare 
	........
begin
	--CODE BLOCK 1
	
	if get_enabled_stg('MED_STAGING') = 'Y' then 
		v_filename_stg := p_filename || '_STG';  			
		v_rows_stg := DUMP_CSV_STG (v_filename_stg,....., v_rows);
		DBMS_OUTPUT.put_line (TO_CHAR (v_rows_stg) || ' rows extracted to '|| v_filename_stg|| '.TMP');
	end if;
	
	--CODE BLOCK 2
	
	--CODE BLOCK 3
	
	.........
end;

delicious tacos :rocket: Oracle APEX Nordic Tour 2025 is coming to you in Spring! Last year, the Oracle APEX Nordic Tour 2024 was a great success. We want to continue this positive trend and make it even more incredible for your customers by learning directly from members of the Oracle APEX Team and other APEX professionals! :calendar: | *Schedule* | :calendar: May 5: Helsinki, Finland RVSP button May 7: Copenhagen, Denmark RVSP button May 9: Stockholm, Sweden RVSP button :pushpin: Please invite your customers and partners by sharing this blog post. Blog Post button

Hello colleagues, I’m currently working on integrating *Oracle APEX* with *ADFS* for SSO authentication. Our environment consists of *WebLogic 14* and *Oracle Database 19c*. After extensive investigation and configuration, we’ve successfully reached the stage where the ADFS login page is displayed and authentication completes successfully. However, upon redirection back to the APEX application, we are encountering a *403 Forbidden error*. Has anyone faced a similar issue or can offer insight into what might be causing this behavior? Any guidance would be greatly appreciated.

If your field is surrounded by double quotes, APEX will treat it as a single field.

SELECT * FROM TABLE (apex_data_parser.parse (p_content => utl_raw.cast_to_raw ('FirstName,LastName,FullName
John,Doe,"Doe, John"'), p_file_type => 2));

Hi all, How can I import a .txt file into Oracle APEX without splitting values at commas? For example, if a line has a value like "John, Doe", I don't want it to be cut in half at the comma during the import process. How can I keep the entire value intact when importing, considering the separator is a new line?

Apex 23.2 patch set has entries like "37239579 - Fix for bug 37239579" but with no description of the bug. Is there somewhere to see the details?

Has anyone seen a case of a column in a classic report that's set to be sortable, but it does not sort? The symptoms I'm seeing are: I click on the column heading and the page blinks but nothing changes I hit F5 and now I see my report sorted in the right order. It's like sorting does what it's supposed to do but the refresh action never happens. What's so weird is that this is only happening on columns that have only one character in them. Longer contents work, or columns with words in them work. The ones that do not work (at least that I've found so far) just have a 1, 2, or a 3 in them. I click on the column heading, the screen blinks and nothing changes, I then hit F5 and I see my new sorted report.

OCI has always free machines if you just want to do DEV/Testing

Could anyone suggest me cheapest hosting for Apex?

Hi all! When copying a page from my Stage environment to Dev I am losing some style templates. In the target env the under Appearance -> Template dropdown settings I see a string of numbers '143835892923 (invalid)'. Any ideas why this is?

Apologies upfront. This has undoubtedly been asked before: where can I find the OCI upgrade/update time schedules. 24.2 has just been made available, but there are 4 patch sets already. I need to know when these will be applied... wasn't there a website for this?

Hi, How to display HTML error message from process? In SUBMIT Process assigned ERROR message to Page Item. But it is displayed as TEXT instead of HTML. Appreciate any help.

I have a question, has anyone noticed a problem with PGA memory after upgrading to Apex 24. We are using Oracle database 19c, ORDS 20.3 and now Apex 24.1. We come from Apex 20.2. We never had problems with PGA memory before.

Got an easy one. I have a classic report and I want the column headings to be at the top of the cell. I have some fairly long column headings, some are a few words, some are longer. I want them to show at the top of the cell, not at the bottom. The usual style="vertical-align:top;" does not work.

(OCI in frankfurt region, performance degradation before 24.2 upgrade btw)

I've had user reports that my app on OCI (I'm on a free tier account) is performing badly lately. Even developer login page is loading like it's waiting for coffee first before willing to give me page. I can respect that, but I 'd rather have that login page, you know? I have no idea how to debug this. Anyone else experiencing degraded performance in general?

Hello everyone, how are you? I have a problem with my application regarding webservice requests. If anyone has experienced this, could you help me?

Created a hidden item with html text that should appear in a region title line. Then put the item in the region title, i..e P76_PERSON_HEADING. Title appears in the Region title, but does not render HTML. It does render the html "words", i.e. "<b>Sam Jones</b>". Region attributes set to HTML, not escape HTML. Since the title value appears with the HTML codes I know the value is set properly. It is set with a PL/SQL Process Before Header. Checked Page Item and process and did not find anything explicitly escaping HTML. Ideas?

It's just a question from a curious guy. How do you guys use Working Copies? One per sprint or per issue? Thanks.

When we were running "on-prem" apex vsn 23.1, We could export a page or other component from apex in one environment (eg dev) and import the component into another apex env (eg uat), just fine. This no longer works after we upgraded to apex vsn 24.1 When importing the single component (eg a single page) we get the error:

Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=60603573849455298, component=Search Approval, sqlerrm=ORA-00001: unique constraint (APEX_240100.WWV_TASK_DEF_NAME_UK) violated.

We try both with without original id option... Does anyone have any ideas? Kind Regards, Alister

Hi all, I have a question about Oracle DB. It seems that we don't have a channel dedicated to Oracle DB questions. My request is simple: I use TOAD to connect to our DB in the Office. Now I am working remotely. How to connect from my laptop to my office database using Toad? We have a VPN to connect to our Network. I also installed Toad 12.8.0.49 on my Laptop. Any idea?

Hello everyone i got this error when i try to create a Workflow console page... Its Apex 24.2 I tried it in my cloud Instace too i get the same error

Hi All, Our application is cloud hosted. What's the easiest way to force user logout when an account is closed? We use social sign-on for authentication, and once authentication is done, the users get an apex session instead. If you keep extending the session, they could still have access for a good amount of time after their social account (corp azure/MS login) is disabled. I've seen the APEX_SESSION.DELETE_SESSION command, but there is a precaution "If the session is currently attached, call the application's Cleanup PL/SQL Code and reset the environment." I am not really sure what that is implying that I might need to do. Isn't all data stored in the session, including collection data? Thank you!

Hi Oracle Apex Experts , I have a page process that uses *Automatic Row Processing (DML) [Legacy]*, with the _Return Key into Item_ field set to *P52_ID*. I’ve noticed that when this field is populated, the process automatically commits the transaction when a new row is created. This behavior makes it impossible to implement certain validation checks on processing. In some cases, newly created data should be rolled back if processing validations fail, but due to the automatic commit, this is currently not possible. Does anyone have a solution or workaround to handle this issue effectively? Apex Version : 23.2.5 Thanks in advance!

Where can I find any more advanced sample applications dealing with the built-in APEX trees like highlighting the current node, searching within the tree using javascript and some other interesting things you typically need to do? Or are most of you reverting to tree plugins?

Hi all, i have a question related to modal dialogs. I have two modal dialogs, From the 1st modal dialog i want to open the second modal dialog but i don't want that the window of first modal dialog gets closed. I tried different settings but somehow it get's closed when i open second modal dialog. If someone can help out here? Thanks

I have implemented Single Sign-On (SSO) in Oracle APEX, and I noticed that there doesn’t seem to be a built-in way to restrict access for specific users. Once authentication is successful, APEX grants access without any additional checks. I know about Authorization Schemes but it is too late, user has valid session (not public session), I would like to block user on log-in process. How is this scenario intended to be handled in APEX? If I need to block a certain user from accessing the system, what would be the recommended approach?

Hi team, I'm working on requirement below for payment_account column suppose first 2 rows value is negative. When i press release button i want to minus 1 row payment_account value with last row and set 1 row value to 0 and store updated value in last row column and do same to 2 row column until value on last row column becomes zero. I have tried using cursor for loop but didn't work. Instead of using process if i want to do this using javascript based on selecting APEX$ROW_SELECTOR how can i achieve that Any suggestion or help will be appreciated. Thank you.