Is there an APEX View that exposes the Developer Activity for an instance? We've used the internal WWV_FLOW_BUILDER_AUDIT_TRAIL table before, but we'd like to stick to an APEX View if possible

Hi, I want to insert an additional class in the t-Header section of an APEX application between t-Header-logo and t-Header-navBar, like i.e. t-Header-center. Is there a native apex way to do that? Has anyone experiences? I would appreciate recommendations.

Does anyone know what might make APEX not remember your Dark/Light mode selection? I’m on 22.2.1 and every time I log in, the login page starts in Light mode but as soon get past that, it switches to DARK mode. Once I switch it back to Light mode, it stays that way for the duration of the session. It doesn’t matter which browser I’m using. I’ve cleared domain, session and path cookies. I’ve cleared the Site Data Cache. Nothing seems to affect this behavior. It’s very frustrating. And for those of you who are going to say “Just embrace Dark Mode” - Yeah --- Can’t do that .. It’s not a preference thing - It’s a readability thing. My dyslexia makes it extremely difficult to work on ANY app in Dark Mode.

how to make Cards smaller, so more cards fit on the screen e.g in the below picture 5 cards are shown per row, i want to make then smaller so that 10 or more cards can be shown in a row

Are there any hints about the 25.1 release date? :innocent:

Apex 23.2.15 I put "Fetched #ROWS_FETCHED# rows of #TOTAL_ROWS# in #TIMING# seconds" in the Footer Text of a Interactive Report and got the output string "Fetched rows of in 28.39 seconds". So it looks like #ROWS_FETCHED# and #TOTAL_ROWS# are not being set. Is there something else I need to do to get them to work?

I have created table based on standard oracle view. On page load I'm inserting data in table based on suppose invoice number. Now based on that table I have editable IG where I perform insert and update process. How do I use collection on grid to send updated or inserted Data to package. Is there any other option like Apex$row_status?

I need help generating an OCI Private Key / Fingerprint to enable Generative AI Service in APEX, please. Hoping this is all doable from within my Oracle Cloud dashboard. Currently running Oracle Always Free I'm reading through multiple docs, trying to translate it to English ;-) https://docs.oracle.com/en-us/iaas/Content/API/Concepts/apisigningkey.htm

Hello everyone, I have created editable IG with 6 column having read only attribute on and 2 are editable for existing records. I have created dynamic action on column when I select value in column value should be set in another column, But it should only work when adding new row in grid. Because when i try to edit existing row dynamic action runs and gives js bug item not found. How to run dynamic action for new rows only?

Hi All, I need CSS expert's help: I have different classes on different elements but they all start with the string "cart" for ex. .cart-wireline .cart-wireless .cart-voice, etc... I want the same dynamic action applied on all of them,... something like: onClick jQuery selector _.cart*,_ trigger a certain behavior. I know another way would be to add another class to all those items and put the DA on that class, but that's not an option for now; we have too many items... Is there a way to refer to all those classes in one syntax?

Oracle APEX Modal Dialog Issue – Problem with Chained = No and Data Submission Hi everyone, We are experiencing an issue in Oracle APEX while implementing a nested modal dialog structure. Here’s the setup: • On our main page (Page 2), we have a calendar. When a user clicks on an event, Page 905 opens as a modal dialog (Event Edit Form). • On this Page 905, there’s a “Add Sponsor” button. When clicked, it opens another modal dialog, Page 33 (Sponsor Add Form). • Our goal is: When Page 33 opens, Page 905 should remain open, and once Page 33 is closed, the Interactive Grid on Page 905 should automatically refresh. To achieve this, we set Chained = No for Page 33. This works as expected — Page 905 stays open. However, this leads to a serious issue: • The form on Page 33 fails to submit data correctly. • Especially items like P33_ETKINLIK_ID (Event ID, passed from Page 905) are not properly submitted or retained. • As a result, fields such as contribution type, explanation, or sponsor budget are lost or inserted as null. All dynamic actions and submit settings are properly configured. Even though P33_ETKINLIK_ID is included in the “Items to Submit” list, the data is not inserted reliably when Chained is set to No. :bulb: Is this nested modal dialog scenario fully supported in APEX? Or is there a more reliable way to handle child-to-parent communication and form submission when Chained is disabled? Any insights or workarounds from the community would be greatly appreciated :pray:

Ever wanted to build a smart chatbot that actually understands your documents? Check out this hands-on workshop on Enhancing your #orclAPEX App with Document-Aware Generative AI Agents. Learn how to bring intelligence into your apps using OCI Generative AI Agents. Try it now social.ora.cl/60114TpkZ

I'm trying to set value in customer_name column of editable interactive grid when changing customer_number column which is popup lov. I have created dynamic action for above on change column action. so when i change customer_number popup column value doesn't set and gives bug. My set value sql query is this SELECT hp.PARTY_NAME d, hp.PARTY_NAME r FROM apps.HZ_PARTIES HP, apps.HZ_CUST_ACCOUNTS HCA WHERE HP.PARTY_ID = HCA.PARTY_ID and hca.ACCOUNT_NUMBER = :CUSTOMER_NUMBER how do i use condition for account number = "my_customer_number column value" i.e. :CUSTOMER_NUMBER

:rocket:*Introducing the APEX Newsletter!* This is the first issue of the monthly APEX Newsletter, where you can find new content, success stories, events, resources and much more! Bookmark this shortcut and don't miss the upcoming issues! *apex.oracle.com/go/newsletter*

how to update Navigation Bar (Badge Value) Dynamically , when Dialog box closes , or by Dynamic action, on page refresh value is updated properly but how to refresh in with Dynamic action or by Dialog box closes

in a text item , "Submit when Enter pressed" is False, still when i press enter , page is submitted ? APEX 24.2, is there a way to stop it

yes i displayed as pill butoon , but button sizes are not equal , also button sizes are small, not very mobile friendly

you could display them as pill button (using the template option for it)

or can we use Card Region for this purpose ? and how ?

how to make apex Radio Group Mobile friendly ?

how to add validation to number field page item it doesn't accept value greater than certain amount? Tried using this but not worked function validateInputAgainstMax() { var inputItem = apex.item("P344_AMOUNT_APPLIED"); var maxValueItem = apex.item("P344_MAX_AMOUNT_ALLOWED"); var inputVal = parseFloat(inputItem.getValue()); var maxVal = parseFloat(maxValueItem.getValue()); if (!isNaN(inputVal) && !isNaN(maxVal) && inputVal >= maxVal) { inputItem.showError("Value must be less than " + maxVal); apex.message.showErrors(); // Display the error } }

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?