Hi all, We are still on Apex 19.2 for now. How can I use the Carousel region but display the slides dynamically. The videos to display are stored in the DB. Presently, one has to create the slides on the page builder one by one. The real problem is that we want to be able to enable/disable videos from the DB, by doing something like select videos from table where enable = 'Y'

:spiral_calendar_pad: Oracle has extended the support period for Oracle APEX versions 23.2 through 24.2 from 18 months to two years. This revision ensures continued support for the current and two preceding releases and acknowledges the delayed availability of versions 24.1 and 24.2. Refer: www.oracle.com/database/technologies/appdev/apex/collateral/#assistance

Hello everyone, I'm using below javascript to set selected invoice_numbers in hidden page item using dynamic action selection change(interactive grid). But multiple invoices are not setting in hidden page item seperated by comma, only one invoice is getting set. What can be the issue? var invoiceNumbers = ""; var receiptNumbers = ""; var model = this.data.model; var model = this.data.model; if (this.data.selectedRecords.length > 0) { for (var i = 0; i < this.data.selectedRecords.length; i++) { var invoice_no = model.getValue(this.data.selectedRecords[i], "INVOICE_NUMBER"); invoiceNumbers += invoice_no + ","; var receipt_no = model.getValue(this.data.selectedRecords[i], "RECEIPT_NUMBER"); receiptNumbers += receipt_no + ","; } invoiceNumbers = invoiceNumbers.slice(0, -1); receiptNumbers = receiptNumbers.slice(0, -1); } apex.item("P340_INVOICE_NUMBER").setValue(invoiceNumbers); apex.item("P340_RECEIPT_NUMBER").setValue(receiptNumbers);

:bulb:Build next-gen chat experiences with ease! Discover how to integrate OCI Generative AI Agents with Oracle APEX for powerful, RAG-powered conversations. Learn more: social.ora.cl/60184H3dY

Hello All, In the interactive report, I need to add a hyperlink to the column based on a condition. Previously, a SUM aggregate function was added to the OCT column, and now the conditional hyperlink logic is causing an error. I also tested using TO_NUMBER instead of TO_CHAR, but the issue still persists. CASE WHEN NATURAL_ACCOUNT_DESCRIPTION = 'Adjustment' THEN '<a href="' || apex_page.get_url( p_page => 174, p_items => 'P174_GL_AP_CODE,P174_FY_YEAR,P174_GL_NATURAL_ACCOUNT,P174_ENTERED_PERIOD_NAME', p_values => AP_CODE || ',' || FY_YEAR || ',' || GL_NATURAL_ACCOUNT || ',' || 'OCT' ) || '">' || TO_char(OCT) || '</a>' ELSE TO_char(OCT)) END AS OCT,

Hi all. I am having some issue with inserting the content in a zip file selected in this File Upload page item. Somehow this table *apex_application_temp_files* doesn't contain the information when i select the file in this page item. Earlier version of Apex this was working totally fine, is it something to do with the apex versions? Or something different? If someone can guide with this? In the session the page item value is updated fine.

We have been using "input method 3" described by Jon Snyders in this post to pass data into a modal dialogue: https://hardlikesoftware.com/weblog/2017/01/05/passing-data-in-and-out-of-apex-dialogs/ In Apex 24.2 (I don't know if it started with this version, we are testing a migration from version 5.1 to 24.2) this no longer seems to function. The result of the call to apex_util.prepare_url within the prepare_dialog_url function has changed. The app is set to use "Friendly URLS" so i changed the regexp_substr to look for that instead of "f?p=" but the URL created still results in a 404 error when we try to open the dialogue. Is there a better way to do this in 24.2?

Hello friends! It's been a while since I stopped by here, and I'd like to present a situation I'm facing, which you've likely encountered before. I have an ERP system developed with APEX, and users often open multiple tabs in the same browser—meaning multiple tabs that share the same session. In the forms I use, many items are stored at the server level because dynamic PLSQL processes are required, and although users know they "shouldn't open the same form in different tabs," the reality is that they don't always follow that rule. This results in data "collisions" that cause very annoying and potentially dangerous issues. So, my first question is whether there is a "native" way to prevent value collisions on the server, and if it's not possible natively, how could I solve the problem I'm describing? I'm using APEX 24.1 on a self-managed server. I look forward to your feedback and appreciate your help. Kind regards.

Hi Everyone, I have 2 tables one of them is Child IG and other is Master IG. I noticed that If I quickly select one row then another in Master IG, Child IG starts to don't fetch any records, It looks just blank without throwing any error message. I'm not sure how to fix this issue, do I need to make selection change slower or something ? Or just remove the Master Detail structure, I'll just refresh the child IG manually with a Page Item. Apex Version is 23.2.5

:mega: Get ready to meet the #orclAPEX team at the APEX Bootcamp @ ODTUG #kscope25! You will have access to technical sessions, amazing hands-on training, symposiums, and networking with Oracle experts, industry thought leaders and friends. :admission_tickets: Tickets: apex.oracle.com/go/kscope25-bootcamp

I have an issue on pop-up lov + multiple select + cascading. As an example I have 3 values on Lov and when I save the interactive grid, all 3 of display values are combined and shown as first value, while the other two are displayed as technical IDs. Apex Version: 23.2.5

Hi, Does anyone know how to add border-radius to tabs of tabs container region. In custom css have use follow css, is anything wrong in my approach. .t-Tabs-link { border-radius: 10px; }

Hi, Does anyone know whether it is possible to create a Map Background with an URL and api key that is configurable at runtime? I'd like to allow customers to be able to choose their own map. Thanks

How to prevent deselecting already selected rows in an IG when clicking on row? Im using row selector

Is there a way to see the content of the code UTL_FILE.put?

Hi just a quick question: Is there any difference between these 2 queries? _select '' as d from dual;_ _select null as d from dual;_

I have a shuttle that has some values longer than the width of the shuttle window. Does anyone if the values can be wrapped? or a horizontal scroll bar added?

:mega: Save your seat for the Ascend 2025! :white_check_mark: Build AI-Powered, Mission-Critical Apps Faster Using APEX :white_check_mark: Oracle APEX Generative Development :white_check_mark: Extending Oracle E-Business Suite Using Oracle APEX :white_check_mark: Oracle APEX Latest Features Overview :white_check_mark: Cooking with E-Business Suite and APEX: You Won't get chopped! Subscribe now social.ora.cl/6010NvzKp

I have a question related to jasperServer Integration

does anyone here tried to integrate oracle apex with jasperserver for reports ?

Please vote for APEX Idea to have Page Items sorted, and allow multi-select when choosing Page Items in APEX Builder. For example when choosing items to submit and return. https://apex.oracle.com/ideas/FR-4467 Simple idea to save alot of annoyance and work.

There are already five batches released for APEX 24.2, but the version available on OCI still doesn’t include any of them (still 24.2.0). What Oracle’s general approach or policy is regarding this? Is there any way to accelerate the availability of new APEX batches on OCI?

:hourglass_flowing_sand: TWO more days before the promo ends! Claim your FREE certification attempt now and join the expert community of Certified APEX Developers. :point_right: apex.oracle.com/go/professional-ai-lp

Hi, I'm using the Image Upload component in Apex 23.2 to allow users to upload images. Ideally I'd like the maximum image height, width and file size to be configurable at run-time. I was intending to hold these values in the database and retrieve them into page items, but it doesn't look like this is possible as you can only enter numbers into the properties in the Designer, not page items. Does anyone know of a way around this? Thanks.

Want to add smarter image search to your Oracle APEX apps? :frame_with_picture: With Oracle Database 23ai and support for ONNX models like CLIP, you can enhance your APEX applications by combining image and text search through vector embeddings. This boosts search accuracy, making it easier for users to find relevant results and improving their overall experience. Read the blog to learn how: https://t.co/6oKWuXfFvg

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.