Oracle APEX 24.2 Known Issues

Patch Set Bundle for Oracle APEX 24.2 (37366599)

The Patch Set Bundle for Oracle APEX 24.2 is available for download from My Oracle Support, via the following path: https://support.oracle.com/epmos/faces/PatchDetail?patchId=37366599. Navigate to Patches & Updates and search for patch number 37366599.

This patch may be updated numerous times when new fixes are added to the bundle, and can be reapplied as needed. The patch was last updated on June 9, 2025, and its PATCH_VERSION is 6. When this patch is applied, the APEX product version will be updated to 24.2.6. To verify the version currently installed, in your workspace open the Help > About dialog to inspect the values of Product Build and Patch Version. Alternatively, query the APEX_PATCHES view using the following SQL statement:

select patch_version, installed_on from apex_patches where patch_number = 37366599 order by installed_on;

This cumulative patch includes the following bug fixes, grouped by patch version:

Patch Version: 1

• 37403215 - VALIDATION ON LINK ATTRIBUTE IN EDIT MANAGE EXTENSION LINKS PAGE DOES NOT ALLOW RELATIVE PATHS
• 37377364 - TEXT MESSAGES > GRID EDIT ALWAYS THROWS ERROR DURING SAVE
• 37439882 - REGRESSION: ORA-922: MISSING OR INVALID OPTION IN SUPPORTING OBJ SCRIPT WITH );
• 37381826 - ERROR USING SELECT ONE WITH SHARED COMP LOV HAVING SAME RETURN/DISPLAY COL
• 37469753 - REGRESSION: UNABLE TO CREATE APP FROM SCRIPT CONTAINING CREATE TABLE STATEMENTS
• 37477049 - RICH TEXT EDITOR CANNOT RESIZE WHEN CONTENT SECURITY POLICY IS ENABLED
• 37474087 - FACETED SEARCH: WRONG WITDTH OF COMBOBOX IN ADD FILTER DIALOG IN UT
• 37481595 - APEX UNIVERSAL THEME SIDE NAVIGATION TREEVIEW TOGGLE ICON VISIBLE WHEN COLLAPSED
• 37480254 - GENERATIVE AI: SQL VIEWS ARE NOT CONSIDERED IN NL2SQL AI ASSISTANT
• 37477575 - POST-LOGOUT URL ATTRIBUTE DOES NOT SUPPORT AUTHENTICATION SUBSTITUTIONS
• 37459803 - INLINE CSS CONTENT SECURITY POLICY VIOLATION IN SMART FILTER CONTROLS

Patch Version: 2
Note: All bug fixes from the previous patch versions are included.

• 37484172 - APEX PATCHES SHOULD UPDATE EMAIL_IMAGES_URL IF USING CDN
• 37376213 - BIND VAR DOES NOT EXIST + ROW NOT INSERTED UPDATING NESTED ARRAY IN JSON SOURCE
• 37472949 - ORA-40597: JSON PATH EXPRESSION SYNTAX ERROR ('$.1') FOR GETPAGEDATA FOR ITEM TYPE PLUGINS
• 37382369 - INCREASE DEFAULT MAX TOKENS FOR OCI GENAI TO 4000
• 37502501 - REGRESSION: ORA-03048 IF CREATE VIEW STATEMENT CONTAINS COLUMN NAMED "TYPE"
• 37512460 - SAVING GENERIC COLUMNS REPORT LAYOUT SETS PAGE TEMPLATE TO NULL
• 37356338 - ACCESSIBILITY OF ACTION/DIALOG LINKS BREAKS ACCESSIBILITY OF QUICK PICK LINKS
• 37356737 - ACCESSIBLE ACTION/DIALOG LINKS BREAKS ACCESSIBLE HEADINGS ON SOME PAGES
• 37503457 - REGRESSION: WORKFLOW PARAM PASSED AS STATIC VALUE EVALS TO NULL
• 37489550 - JSON SOURCES: DML ON ARRAY OF SCALAR VALUES THROWS ORA-40597 ERROR
• 37348464 - GENERATE DDL : CANNOT SAVE AS SCRIPT IF OBJECT TYPE IS SYNONYM
• 37512596 - PAGINATION NOT WORKING PROPERLY IN "SIMPLE HTTP" RDS WHEN "HAS MORE ROWS ATTRIBUTE VALUE" IS NOT IN LOWER CASE
• 37519977 - RUNTIME ERROR USING POLYMORPHIC COMPOSITE TYPE USED FOR FLEX FIELDS IN BOSS

Patch Version: 3
Note: All bug fixes from the previous patch versions are included.

• 37538056 - CREATE DUALITY VIEW SOURCE THROWS ORA-6503 ON DB 23.6
• 37514003 - NEW PADDING UTILITY CLASSES DON'T WORK
• 37564420 - ERROR WHILE DOWNLOADING PDF ON IR:ORA-01476: DIVISOR IS EQUAL TO ZERO
• 36774907- GENERATIVE AI: ADDITIONAL ATTRIBUTES OVERWRITTEN WITH DEFAULT VALUES
• 37553867 - DML ON JSON SOURCES FAILS IF COLUMNS HAVE SQL EXPRESSIONS OR "SEQUENCE" IS USED AS DEFAULT
• 37541560 - APEX-EXT: APEX JOB ORACLE_APEX_PURGE_SESSIONS FAILED WITH ORA-01858
• 37549559 - CHAT CLIENT DIALOG HAS DOUBLE SCROLLBARS
• 37553042 - REGRESSION: ORA-6550 RAISED ON EDIT VECTOR PROVIDER PAGE
• 37563223 - DML ON "TABLE WITH JSON COLUMNS" JSON SOURCE RAISES ORA-3083 IF ONLY RELATIONAL COLUMNS ARE UPDATED
• 37473871 - ERR OPENING COPIED PAGE FROM DECOUPLED UT THEME APP IN NON-DECOUPLED THEME APP
• 37512743- OPEN TELEMETRY SPANS CONTAIN UNSUBSTITUTED STRINGS UNEXPECTEDLY
• 37575481- IMPORT SWAGGER 2.0 FILE AS REST CATALOG LEADS TO PARAMETER NAMES MISSING
• 37588311 - UNEXPECTED ERROR SAVING AUTOMATION WITH FUNCTION BODY RETURNING SQL
• 37590624 - BUILD OPTION UTILIZATION PAGE THROWING ORA-00903: INVALID TABLE NAME ERROR
• 37586431 - LIST DETAILS PAGE THROWING ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR: CHARACTER STRING BUFFER TOO SMALL ERROR
• 37564624 - PE.SELECT PLACEHOLDER TEXT MESSAGE LISTED FOR CARDS REGIONS
• 37474511 - FACETED SEARCH: DATEPICKER INPUT IS NOT CLEARED CORRECTLY BECAUSE WRAPPEDELEMENT IS NOT SET
• 37512644 - REGRESSION: CLASSIC REPORT COLUMN WIDTH IGNORED AFTER DYNAMIC ACTION REFRESH
• 37568470 - REGRESSION: CLASSIC REPORT PERCENT GRAPH COLUMN BROKEN AFTER DYNAMIC ACTION REFRESH
• 37579661 - DAILY METRICS JOBS FAIL TO COLLECT INSTANCE METRICS ON 23AI DATABASES
• 37489539 - ADB-S: UNABLE TO SET PATH_PREFIX WORKSPACE PARAMETER
• 37250346 - APEX SENDS BACK CROSS ORIGIN HEADERS EVEN WITH HTTP_TRUSTED_ORIGINS
• 37365511 - FACETED SEARCH: ADD FILTER BUTTON DISABLED AFTER CLOSING DIALOGUE WITHOUT CLICKING APPLY
• 37634998 - DBMS_INSTANCE_ADMIN.DROP_CLOUD_CREDENTIAL THROWS ERROR "INSTANCE PARAMETER NOT FOUND" ON ADB

Patch Version: 4
Note: All bug fixes from the previous patch versions are included.

• 37651139 - IMPORT REPORT LAYOUT RAISES PLS-00123: PROGRAM TOO LARGE
• 37517405 - REGRESSION: ERROR OPENING MODAL PAGE W/ REDIRECT & SET VALUE RADIO GROUP
• 37365329 - FACETED SEARCH: DOUBLE ESCAPING WHEN RE-ADD VALUE TO SELECT ONE IN FILTER DIALOGS
• 37662593- REGRESSION: CALENDAR EVENT LINKS CANNOT BE OPENED USING BROWSERS "OPEN IN NEW TAB" FUNCTION
• 37704247 - EDITING THEME FILES WHEN A THEME HAS APPLICATION SUBSCRIBERS RAISE NO DATA FOUND
• 37684930 - REGRESSION: WHEN UPDATING THEME TO LATEST VERSION CUSTOMIZED TEMPLATES ARE REMOVED
• 37693733 - REGRESSION: LIST MANAGER IS BROKEN WHEN USING IN OTHER LANGUAGES THEN ENGLISH
• 37740250 - ADB-S: DOCGEN CLOUD CREDENTIAL MISSING AFTER UPGRADE TO 24.2
• 37558869 - ORACLE_APEX_DICTIONARY_CACHE FAILS JOB FAILS IF ANY WORKSPACE NAME IS NUMBER

Patch Version: 5
Note: All bug fixes from the previous patch versions are included.

• 37794173 - JSON SOURCES: ORA-1008 THROWS WHEN INSERTING NEW CHILD INTO NESTED ARRAY OF SECOND OR DEEPER LEVEL
• 37794425 - PARENT COL NULL IN DATA PROFILE ARRAY COL FOR GRANDCHILD DUALITY VIEW COLLECTION
• 37787406 - ORA-20001 ERROR REPORTED IN APEX INSTALLATION LOG WHEN APEX 24.2
• 37810345 - Fix for bug 37810345
• 37756039 - ORACLE_APEX_DAILY_METRICS JOB FAILING RANDOMLY
• 37809911 - AN AUDIT RECORD IS NOT STORED DUE TO HANDLED EXCEPTION IN TRIGGER DURING WORKING COPY MERGE
• 37785000 - BAIL OUT OF JOBS ON LOGICAL STANDBY

Patch Version: 6
Note: All bug fixes from the previous patch versions are included.

• 37751502 - PLUGIN COMPONENT TYPES AT ATTRIBUTE LEVEL ARE NOT SET CORRECTLY
• 37859249 - UNABLE TO CREATE OR DELETE DEFAULT INTERACTIVE REPORT SUBSCRIPTION DURING PHASE 2 OF APEX UPGRADE
• 37859062 - UNABLE TO SIGN IN TO APP BUILDER DURING PHASE 2 OF APEX UPGRADE
• 37858190 - DON'T LOG EVENTS FOR USER PREFERENCES
• 37967372- GLOBAL INSTANCE PARAMETER FOR THEME ASSETS
• 37830514 - UNABLE TO LOG IN TO APEX WORKSPACE ON DBFIPS-ENABLED 23AI DB
• 37970639 - SUSPENDING WORKFLOWS MUST USE DBA_SCHEDULER_JOBS, RESUME SHOULD ABORT DANGLING JOB
• 37952347 - REGRESSION: REUSING TASK DETAILS PAGE NUMBER GIVES PAGE ALREADY EXISTS ERROR
• 38029863- SOAP WEB SERVICE CALLS FAIL WITH LARGE ENVELOPES WHEN DEBUGGING IS ENABLED
• 38043213 - PATCH SET 24.2.5 ENABLES DEBUG AT WARN LEVEL FOR ALL JOBS

Bugs

• 37467375 - PHASED UPGRADE IS BROKEN IN 24.2

  When attempting a phased installation using APEX 24.2 zip files downloaded prior to January 23rd, 2025, executing the script apexins2.sql will prompt for 'Enter value for sharing:'.

  Solution: Clean up the failed installation following the instructions outlined in section C.3 Cleaning Up After a Failed Installation in the APEX 24.2 Installation Guide. Then re-download the APEX 24.2 zip file and retry the phased installation.

APEX 24.2 Content Delivery Network (CDN)

• APEX 24.2 static resources are available on a CDN.
• The table below provides the CDN URL to use for each Patch Set Bundle for APEX 24.2. Please refer to documentation or included README for instructions to update the CDN.