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 February 5, 2025, and its PATCH_VERSION is 2. When this patch is applied, the APEX product version will be updated to 24.2.2. 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:

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

• 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

• 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

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.