*Popup LOV search in 26.1 — did we lose wildcard % for good?* Hi all :wave: Hoping someone can tell me I'm missing an option, because right now this feels like a real step backwards. Up to 24.1, users could type % in a Popup LOV search and it worked as a genuine LIKE wildcard. Ours use it deliberately (not randomly) to match several substrings within one entry, e.g. A%B%C to find rows containing A, then B, then C. Fast, powerful, and completely muscle-memory for them. In 26.1 the unified LOV search escapes %/_ as literals. I get the consistency goal with Select One/Many and Combobox, and Match Type / Case Sensitive are nice. But Match Type = Contains only does a single contiguous substring match, so the multi-token search is just… gone. No replacement, no compatibility toggle, and no bind for the search term either. Compatibility Mode set to 24.1 doesn't bring it back. So the removed capability wasn't swapped for something better — it was removed outright, and now recovering it means per-item plugins + hand-written predicates. In our case that's hundreds of SQL LOVs, which is not realistic. My question: *is there any reasonable, supported way to get wildcard/multi-token LOV search back that doesn't rely on third-party plugins?* Anything declarative, a documented bind for the search term, a setting I've overlooked? To me the obvious fix would be to extend the existing *Tokenize Row Search* parameter (which already exists for IR/IG) to the LOV item types — same behaviour, consistent with where APEX is heading. I've added this to FR-3800 in the Ideas App, but I'd love to know if there's something usable _today_. Thanks :pray:

HI, How to add column collapse and expand in IG/IR report like

Has Oracle APEX's Statement of Direction been moved? The link below which use to give a roadmap of features planned to implemented in future versions of APEX now just goes to the APEX home page apex.oracle.com/sod

I have an OCI Autonomous Database (free tier) where Planned Maintenance run (ADBS-26.8.1.2 from Aug 8, 2026, 9:00:00 PM UTC) got stuck In Progress; The DB is up but the ORDS connections keep failing making the applications unusable. I tried Shutdown and Restart But there doesn't seem to be much I can do. What is the correct forum to get help? What other options could I try?

Requirement is that a (privileged) user of an APEX Application can define URL endpoints and the corresponding credentials. Identical as “Web Credentials” in the APEX Builder, but then for end users. However calling apex_credential.create_credential from the applications, returns an error that the user is not an (APEX) Administrator. Running the same code in SQL Dev as schema owner works fine. Doing the same via a scheduled job, returns an error that APEX_PUBLIC_USER is not and APEX Administrator. Redefining the code that is executed in the job with “authid current_user”, returns the error that “g_security_group_id must be set” - although apex_util.set_workspace is the very first statement in the procedure. Can apex_credential.create_credential only be used in a SQL script during deployment? Any other great ideas how I can solve this issue - using a Web Credentials solution? Storing client Id/client secret in my own table is easy but from a security perspective not the best solution as I need to use these values unencrypted…

During an OCI APEX upgrade , is there anyway to track from the backend how far through the process it is? Would be useful when we are patching our Prod envs. Thanks!

I was wondering if anyone else has a forever free instance in Toronto-1? I'm getting a lot of very weird stuff. My theory at the moment is that the network path from my computer to the data center is passing through 2 load balancers, or edge devices that are confused about which one is in charge. Malformed pages, HTTP 400 errors when i select things in the APEX builder and other weirdness. Does anyone know anything about this?

Just a general question.. How 508 compliant is APEX 26.x out of the box? Customer I work for now is a gov't agency and our apps need to meet Federal Gov't 508 compliance for web sites..

Hi All, In APEX 26.1, in rich text editor, when I try to change font-size, it shows me small, tiny, large, etc but I want to make it numeric. When I try the following logic which used to work in APEX 20.2, is not working in APEX 26.1

window.configCKE5 = function(options){
	options.editorOptions.toolbar.push('insertImageViaUrl');

    options.editorOptions.link = {
        addTargetToExternalLinks: true
    };

    // added numeric support for fontsize
	options.editorOptions.fontSize = {
		options: [
                9,
                11,
                13,
                'default',
                17,
                19,
                21
            ],
		supportAllValues: true
	};

    return options;
}

Am I doing something wrong?

i've been tasked with creating some interface for merging two given child rows. the children have about 10 columns each, and the users want to be able to contribute to the columns (think merging 2 descriptions or sets of notes on a record). ideally, I can use as much OOTB APEX stuff as possible. My first thought was to output a table with the children, and a set of page items as the "output". Clicking the table cells would set the corresponding output page item to that child's value. if additional edits need to be made, they can edit the page item directly. Clicking save inserts a new child row and updates any tables where the children were FK targets to the new ID. has anybody done this type of "merging" before and have a better UI?

Is anyone using https://github.com/antonscheffer/excel2collections with apex 26.1? I'm getting an error 'Storage type "" not handled'. That's double-quotes around an empty string.

Another APEXLang question … We experience that an import of a medium size (around 150 pages) APEXLang application using the command line takes about 2 minutes. For a deployment to a Test environment that is fine. For development, where you quickly want to change something and see / test what the result is … not so much. Then I can do it faster in the builder. Is our setup just slow? Or is this just an average response time?

When I try to import an APEXLang file (using the “run” icon in VSCode), I get an error message : “Multiple workspaces available, use the workspaceId or the workspace option.” I can provide a workspaceId when I execute the import on the command line. But is there also a setting in one of the json files that would work? And why do I need to add that anyway - the only (two) other workspaces are INTERNAL and the oracle repository …

At present, users communicate with the ERP support team via WhatsApp. To streamline support and centralize communication, we plan to implement an in-app messaging feature within the ERP that enables users to send voice notes, images, and videos, similar to WhatsApp.

It really depends on your requirements, I remember a couple of blogposts covering this though

or any resources you can share with me??

can anyone tell me how can i buld a chat box like whats app on apex??

hi anyone here??

APEX 26.1.2 deployment using SQLcl Project (v26.1.2) runs into and error : ERROR at line 1: ORA-20987: APEX - Plug-in with APEXlang Name "psiPdfJsViewer" can not be found in the application 9999. Please ensure a plug-in with the same APEXlang Name exists in the master application and try again. Alternatively, you can set the "Subscription Mode" as "Ignore Errors", to ignore invalid master component references. Same is described here : forums.oracle.com/ords/apexds/post/sqlcl-project-deploy-fails-after-apex-26-1-upgrade-8818 We also have our shared components in one “master” app that is not deployed. This looks like a (undocumented?) change of behavior. What would be the solution? How can I set that “Subscription Mode”? is that something I can define in the “default.json” file? How? Or do I need to deploy that master application - and if that is the case, I probably need to deploy that one first?

In APEX 26.1.1 I get an error using an Interactive Grid and entering a search term in the search bar. It tries to generate a filter for all text columns … but comes up empty. I generated the page with APEXlang. Might not matter. Do you guys experience that as well? Row column search.

After upgrade to APEX 26.1 we encounter an error “APEXDEV.TEMPLATE_DIRECTIVE.TEMPLATE_NOT_FOUND”. It shows in multiple forms. E.g. : _Template Component “THEME_142$BUTTON” not found_. Our Theme 142 is an up to date subscription of Theme 42. An Action template is referencing “THEME$BUTTON” with {apply THEME$BUTTON/} I cannot change this template without unsubscribing from the Oracle UT. I would love to replace our theme 142 with the original “42", but it looks that is no option. Anyone seen - and solved - this? (maybe with another theme number than 142…)

Hi all, is anyone else finding APEX 26.1 unavailable on paid OCI instances? I had the announcement email for London and successfully upgraded one of our "always free" instances, but the update isn't showing on any of our paid instances, or on a newly provisioned one. Wondering if others are seeing the same.

I'm on the new APEX and one thing is really bugging me, the constant highlighting on the screen. If I try to click and drag a field from one position to another position the whole region turns yellow. It's really hard to see the field I'm moving or where is will land when I take my finger off the mouse button. Is there a way to turn that nonsense off?

Has anyone found a good workflow for one team of 5+ developers working on a single application with APEXLang? It looks like it's whole app imports currently, which seems prone to conflicts if multiple devs are trying to import their changes. I've thought of two approaches: • Everyone commits to git, which has a workflow to deploy on push. This solves the merge but slows the development process. It also overwrites any manual changes in the app builder. • Everyone creates a working copy branch of the application they want to work on. They import over that app instead of the main, then merge when they're finished with their feature.

My experience upgrading from 24.2 to 26.1.1 on OCI ADB-S 26ai Started upgrade @ 09:48 Client app unavailable @ 09:59 Client app available @ 10:00 APEX login available 26.1.0 @ 10:01 APEX still upgrading to 26.1.1 @ 10:30 APEX login available 26.1.1 @ 11:06 Upgrade Complete email @ 11:07 I had a curl fire every 5 seconds to the client app to monitor total downtime. The client app was down for roughly a minute while going from 24.2 to 26.1.0, then <5s (if any) from 26.1.0 to 26.1.1. To anyone on the APEX team, this is phenomenal work :saluting_face:

Has anyone used Generic (Open AI compatible) option in AI service in New APEX 26.1? Our requirement is that, we want to create a proxy url and use that directly as a base path so the input can be received from client's conversation/input and then want to call OpenAI or Claude or Copilot based on client's requirement. Not all client wants to use single AI. Is this possible in new Oracle APEX 26.1? @Jayson Hanes - Oracle APEX PM @Scott Spendolini?

Hey all you shiny humans out there in APEX land. I thought I'd pass this along. In APEX 26 if you use HTML coding in your tab titles, for example like this 'My Tab<br>Title' then APEX 26 will not escape that <br> in the middle. I had to go through my app to yank them all out of there.

#orclapex 26.1: Menu-type button works great on regular pages, but on the Global Page (Page 0) the button renders everywhere yet the menu never opens on click. Supported? More Details: forums.oracle.com/ords/apexds/post/recommended-way-to-build-a-user-menu-with-avatar-in-the-nav-2382

Which Oracle fella has said wont fix in 24.2

Looks related to this; https://forums.oracle.com/ords/apexds/post/corrupted-theme-when-copying-page-with-template-component-7195

Apex 24.4.16. Exported application, re-imported with different appid. Re-subscribed theme to UT 42. When I go to Shared Components -> User Interface Attributes, i get a "ORA-01422: exact fetch returns more than requested number of rows" error.

Has anyone gotten the built-in data loading (hosted apex v24.2x) to work? I’ve tried to set it up but anytime I load a file it doesn’t recognize the headers on my .csv? I have the “first line contains headers” checked in the data profile on the data definition.

Thought i might be able to use the provided wget script instead, but it asks for a "token", and, of course, there is no indication of what or where this "token" might be.

Error trying to download patch set for apex 24.2.17

Does anyone else is having sporadic Error: 571 on the app builder?

Hi, does anyone know if Oracle has announced a planned rollout date for APEX 26.1 on OCI-managed APEX services?

Good evening everyone, is there a guide/best practice how to upgrade from: Apex 24.2 - 21c XE Database To: Apex 26.1 - 26ai XE Database I tried it today in our Lab Environment and it fails.

Hello everyone, I have a quick question. I'm sending an email from the Apex page for which I'm using the text area page item to write e-mails and then I send them. Wherever I add url in e-mail, it appears as a hyperlink in Outlook. But if I'm sending a predefined email temple from an email package which has url in text format it's not acting as hyperlink in Outlook. I tried using apex_escape.html but it didn't. Do you have any ideas?

When wil the frontier LLM's be trained to generate APEXlang from natural language descriptions of what we want the APEX app to look like and do?

Got a quick question hopefully someone can answer. My development and production environment are both on APEX 24.2.11. I want to patch my development environment to 24.2.17. Prod will get updated eventually, but I want to test in my development environment first. Will I be able to import my applications into my production environment from my development environment even though they are not on the same patch level?

*What I'm Seeing After 4 Months of Trying to Find My Next Oracle APEX Developer Role:* After four months of searching for a new remote Oracle APEX developer position, I've noticed a few frustrating trends. Recruiters seem to be sending mass emails to anyone whose profile happens to mention "APEX," rather than taking the time to find candidates who are actually a good fit for the role they're trying to fill. When I do respond, the pattern is often the same: they ask for my résumé, then... nothing. No follow-up. No feedback. They simply disappear. Here's what makes this especially frustrating: I'm not new to Oracle APEX. I've been developing with it since the HTML DB 1.5/1.6 days and have continued to learn and stay current with the many enhancements Oracle has introduced over the years. Most of my career has been supporting Federal Government agencies, so while I have deep experience building and maintaining enterprise applications, I haven't had the opportunity to use every new feature that has been added. That doesn't mean I can't learn or adopt them—it simply reflects the needs of the projects I've worked on. So I'm looking for advice from the community. If you were an experienced Oracle APEX developer with 20+ years of experience, where would you focus your job search today? How are people finding legitimate remote opportunities that value experience instead of keyword matching? I'm hoping to find a position where I can continue building great applications, contribute to a strong team, and work toward retirement over the next 6–8 years. I'd genuinely appreciate any suggestions, referrals, or insights from others who have navigated today's job market successfully.

Hi everyone, I'm using the *Working Copy* feature in Oracle APEX for the first time, and I've noticed something that I'm not sure is expected behavior. Whenever I create a working copy and make changes, the comparison with *MAIN* shows modifications on pages that I never touched. For example, in the screenshot below, it says that Pages *1* and *21* were modified, but I'm absolutely sure I only worked on *Page 110*. Does anyone know why this happens? Is there something that automatically updates other pages when creating or editing a working copy? I haven't merged the changes yet because I want to understand what's causing this first. Thanks in advance!

APEX 24.2.17

how to centralize text of display item. e.g below text. also hide the border Pharmacy & Grocery delivered to your door

Anybody is facing login issue after changing password in oracleapex workspace

When I try to add dynamic action Show AI Assistant, in my application it gives me this error. I don't get any error on Oracle APEX free tier, and both configurations are same, ACL and wallet done as well. AI feature works fine in interactive report in my app but Show AI Assistant dynamic action gives me error. Does anyone faced such issue or could someone suggest how to find the root cause of this issue?

Anybody experienced performance problems when upgrading from APEX 24.2 to 26.1.1? Everything is super slow now ORDS_VERSION = 26.1.2.r1401916 Database version: 19.19 The appserver team still uses APEX_PUBLIC_USER as the main connection pool. Not sure whether this is relevant here. We seem to be good on the requirements side.

getting this error while installing sample data set in oracle APEX in OCI

i have created APEX instance in oracle cloud how to change its timezone, so that when i do select sysdate from dual. its shows pakistan time not dubai time?

Any opportunities exclusive for Oracle Apex Developers certified by Oracle?