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.

greetings everyone, does anyone have a reliable resource on how to upload many files or attachments into Apex forms (I have an attachments table, but I am facing errors on the page designer level and processes when inserting into the table ) ?

Just a tech question, When we deploy custom APEX application on a client onprem, how do we make sure the code base is not available for customers to make changes. I would like to package it and install with a customer than sharing the code base to the client. Any thoughts?

Hi: There is this requirement for a specific app I wrote in APEX 24.1 where the user password can never expire. I set it here but it still prompts the user periodically. Have I missed something?:

Hi APEX team, I've read here https://www.linkedin.com/pulse/oracle-apex-centralize-your-app-messages-text-mauro-martins-pagnez-h36vf that we can use use &APP_TEXT$Message_Name*$Lang*. Do you use this *$Lang* parameter and does it work ? Thanks for advices

Error when saving subscriptions in Interactive Reports. 'Strip Richtext' setting is not saved and is also not saved in WWV_FLOW_WORKSHEET_NOTIFY. If you manually set the value in WWV_FLOW_WORKSHEET_NOTIFY, it is displayed correctly in the dialog, but as soon as you save again, the value is set to NULL in the table. Can someone tell the development team about this? Many thanks!

Got another one I hope someone can help me with. I'm on page 295 and I want to add a new customer contact, so I hit a button on P295 that takes me to page 41 where I enter the details of the new contact and once I'm done it returns me to page 295, so far so good. On dialog close I refresh the select list and then do a set value using the dialog return value of P41_ID but I am not getting the name of the person I just created. I use a dialog return to bring back the ID of the record I just made and it gets inserted into my Select List field on P295_CONTACT_ID, but the name of the person I just created on P41 does not come up. The select list does contain the name of the new person, but i have to choose it. is there a way to make it populate properly?

Hi all, I am receiving this string from another system. *ARMANDO AVENDAñO.* When calling our Application, the item P0_CRM_USER is set that way in the URL: It's supposed to be *ARMANDO AVENDAÑO* Is there any decoding function in oracle I can apply to the first string to get the second one, the right one? I know you might say the calling system should handle this, but it would be more complex for them to do that change in CRM. Just checking if I can find a way locally. But of course if this is not easy to do on our side, then I will have to let them do it... Beside that I am learning as well....

What is currently to best way to do multi-language applications with APEX? I am looking for the best workflow, lessons learned and what might have changed since APEX 21.2? Who is known in the community to use translations in their applications? Any blogs / presentations you can point me to? We are looking at the following languages: German, English, French, Polish, and Russian. Thanks :slightly_smiling_face:

Hello! I'm trying to adjust the width of a Popup LOV item (Inline Popup), but I can't get it to work. Is it possible?

Hi, i am having this issue with Interactive grid. As soon i change the value of coloumn from dropdown then click Save button then it works fine but the row for changed value is dissappeared, when i manually refresh the page then the Grid shows that value again. If someone has any clue what could be doing it? Thanks.

Something weird with Radio Group fields.... I have a simple Radio Group where I'm putting some text in the POST TEXT field but I can't get it to move over to the left. Here is what it looks like. I want the text to be right beside the two radio buttons. I've also included what my POST TEXT actually contains. Is there some secret to getting that text to slide over to the left?

Hello dear Community, I’m an experienced Oracle APEX and PL/SQL developer with 7+ years of experience, but until now, I’ve only worked on projects for companies. I want to take the next step and build my own software product using APEX, targeting small businesses as customers. However, since this is my first time creating a product for sale, I’d love to get advice from those who have done it before. Here are some key questions I have: 1. *Product Development:* What should I consider when building an APEX-based product for multiple clients? 2. *Hosting & Deployment:* Should I host the application myself, use Oracle Cloud, or offer on-premises installations? 3. *Licensing & Pricing:* How do I handle Oracle licensing when selling an APEX-based solution? What pricing models work best for small businesses? 4. *Marketing & Sales:* How do I attract customers and sell an APEX-based solution successfully? 5. *Support & Maintenance:* What’s the best approach for handling updates, bug fixes, and customer support? If anyone has experience selling APEX applications, I’d really appreciate your insights! Thanks in advance.

I don't know if any of you did that, but since we're talking about APEX, let's help this person by sharing what you think. https://docs.google.com/forms/d/e/1FAIpQLSeZ6ArySlRRF2CW60xQUmDYkspmgjGJC4mqsi-OSRwje0lqCA/viewform

What are people using for automated UI/browser testing for APEX? I've taken a look at Selenium in the past and it seemed not obvious how to locate cells in reports. I've seen references to Cypress, from 2019, that look but are there others? FREE options only please - no budget for this.

I will attempt to use threads in the future..

why do you all refuse to use threads - makes it hard to see new unrelated posts as well as see what is new vs old

If I remove the blob column and the value for it, the insert works.. So something in the hextoraw function call is upsetting sql developer..

SQL Error:

could you also share the error message you're getting?

SQL Developer has issues with inserting this row.. Can anyone shine a light on what is wrong with it?