Anyone in the *Denver, Colorado area* (or willing to travel on your own dime) *interested in attending Kscope26 with a full pass?* .. let me know ASAP, today is the LAST day to register, and, I might have a pass to share :nerd_face: - note, government employees are not eligible... Oracle Emps, Customers and general public on the other hand are okay.

I need to move a large number of PL/SQL packages (related to a APEX app) from one database to another. The _only_ access I have to each database is via APEX SQL Workshop. What's the best way to export/import all these packages?

Next question.. Has anyone ever attempted an APEX upgrade from APEX 3.x to APEX 24.2? I might have a chance at a project doing this and I know there are needed steps (from Ver 3 to 5 and then I bet 18.1 before going to 24.2).. Just wondering anyone has experience with it?

Hi everyone, I’m an Oracle APEX Developer based in Stuttgart with experience in Oracle APEX, PL/SQL, Oracle Database, ORDS REST APIs, and Forms-to-APEX migration. Currently open to new opportunities in Germany related to Oracle APEX / Oracle Database development. Happy to connect if anyone knows suitable openings. Thanks!

Hello friends, We are trying to isolate a problem affecting ONLY a migrated PDB after upgrading from Oracle 21c XE to Oracle AI Database 26ai. A completely fresh PDB created directly in 26ai works perfectly with the exact same ORDS standalone configuration, Java version and server environment. The issue appears ONLY when using the migrated PDB. Title: ORDS standalone returns HTTP 404 for all APEX apps only on migrated PDB (21c XE -> 26ai) Environment: • Source database: Oracle 21c XE multitenant • Source PDB: ORCLPDB • Target database: Oracle AI Database 26ai • Migration method: AutoUpgrade (PDB migration into existing CDB26) • ORDS version: 26.1.1.r1321130 • APEX upgraded from 24.1.5 to 26.1 • Testing ONLY in ORDS standalone mode (Jetty) • No Apache, Tomcat, reverse proxy or SSL involved • Java 17 and Java 21 both tested with identical results Current issue: After migrating the PDB from Oracle 21c XE to Oracle 26ai using AutoUpgrade, ORDS standalone starts correctly and reports the pool as VALID: Mapped local pools from ...: /ords/ => default => VALID ORDS landing page works correctly: http://127.0.0.1:8080/ords/ However, ANY APEX request fails: http://127.0.0.1:8080/ords/f?p=4550:1 http://127.0.0.1:8080/ords/f?p=331:101 Result: • HTTP 404 NotFound Earlier during troubleshooting we also saw: ORA-01017 during openProxySession(APEX_PUBLIC_USER) Important findings: The issue ONLY occurs with the migrated PDB. If a completely NEW clean PDB is created directly inside Oracle 26ai: • APEX 26.1 installs correctly • ORDS standalone works immediately • APEX login page opens normally • Same ORDS configuration • Same Java • Same server • Same ORDS binaries Therefore: • ORDS standalone itself is confirmed working • Java environment is confirmed working • ORDS configuration is confirmed working • The problem is isolated to the migrated PDB What has already been verified: • APEX 26.1 status VALID in dba_registry • No invalid objects remain in APEX_260100 • apex_rest_config.sql executed successfully • plsql.gateway.mode=proxied • security.requestValidationFunction=ords_util.authorize_plsql_gateway • ORDS_PUBLIC_USER password reset multiple times • ORDS configuration recreated from scratch multiple times • Proxy connections manually tested successfully: connect ORDS_PUBLIC_USER[APEX_PUBLIC_USER] Question: Has anyone seen ORDS/APEX runtime inconsistencies, proxy issues or PL/SQL gateway failures specifically affecting migrated PDBs after AutoUpgrade migration from 21c XE to 26ai, while the exact same ORDS standalone configuration works perfectly against a newly created clean PDB in the same target CDB? Thanks in advance for any ideas or suggestions.

Is there a link to the recorded session for Part 1: What's new in Oracle APEX 26.1? @marc @Scott Spendolini Thank you!

https://blogs.oracle.com/apex/announcing-oracle-apex-261 Looks like it's all in on AI

i want to do my apex application url to be user freindly so that any unethical person can not access application

Anybody knows how can I download patch from Oracle Support website? I want to download APEX patchset (https://www.oracle.com/tools/downloads/apex-downloads/) but the download button is disabled.

I have a URL from an email that links to a page with a Form. We have a Form - Initialization process that does not seem to work. I can see in the DEBUG that the P3_ID (the PK of the form source table) is being set before the Form - Initialization process fires. I can expose this field and verify it is being set. I created a Classic Report using this value and it returns the expected data. I can do a manual form initialization PL/SQL and it works as expected. Any insights as to why the OOTB Form - Initialization process is not working as expected?

Just seeing if ANYONE is out there.. Seems really quiet up here...

Hello everyone, I’m wondering if it’s possible to activate the average aggregate in an interactive report when defining a PIVOT. Instead of having the sum of all the lines, I want to have the average of all the lines.

https://oracleapex.com/ords/r/apex_pm/ut/migration-guide says "create a new theme using UT, then switch". The method to create the new theme says to hit "create theme" and then select "From the Repository", but this option doesn't exist.

So, we have a very large, old APEX application that was using one of the old themes and has at some stage been moved to UT but it is "unsubscribed". I want to re-subscribe it and get it all working again.

We have some code around the APEX feedback functionality. It's uses the apex feedback types and statuses. I see there is a synonym for apex_240200.WWV_FLOW_FEEDBACK_TYPES (APEX_FEEDBACK_TYPES), but I don't see anything for APEX_240200.WWV_FLOW_FEEDBACK_STATUS. Am i missing something?

I started noticing a bunch of DEPSCAN$ procedures cluttering up my object browser. anybody have any insight into how those are supposed to get cleaned up? https://forums.oracle.com/ords/apexds/post/depscan-clutter-building-up-4039

Updating from apex 23.2 to 24.2. Have a bunch of non-css "APP_IMAGE" files that we had been serving for an app using the "CSS" files list in App -> User Interface. After updating UT, Chrome is throwing an error "Refused to apply style from '<URL>' because its MIME type ('application/octet-stream') is not a supported stylesheet MIME type, and strict MIME checking is enabled." Can i disable this check or what is the "right" way to serve these files in 24.2?

Hey everyone :wave: I’m working as an Oracle APEX developer with 2+ years of experience, strong in PL/SQL, and have handled complete application development and client interaction independently. Currently exploring remote or contract roles involving APEX, REST integrations, or Oracle-based systems. Would love to connect if there are any opportunities or collaborations.

Is anyone seeing Oracle APEX charts not render today out of nowhere? All of our charts are showing as blank spots on our application pages today.