Oracle APEX 24.1 Known Issues

Patch Set Bundle for Oracle APEX 24.1 (36695709)

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

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 October 7, 2024, and its PATCH_VERSION is 5. When this patch is applied, the APEX product version will be updated to 24.1.5. 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 = 36695709 order by installed_on;

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

Patch Version: 1

Note: All bug fixes from the previous patch versions are included.
Version 1 is a Cloud-only release.

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

• 36748606 - REGRESSION: REPORT LAYOUT CORRUPTED AFTER IMPORT / EXPORT
• 36420655 - INLINE DIALOG WITH AUTO HEIGHT PROPERTY SET FLICKERING WHEN OPENED
• 36763086 - GENERATIVE AI: ENABLE OCI GENERATIVE AI FOR USE BY APP BUILDER
• 36749611 - REGRESSION: ITEM.JS - WEBCOMPONENT BASE CLASS - ISCHANGED RETURN ALWAYS TRUE WHEN ITEM HAS NO VALUE
• 36753968 - ADB: SETTING ALLOW_HOSTING_EXTENSIONS THROUGH API THROWS ERROR
• 36739847 - EMPTY PDF WHEN TESTING REPORT QUERY WITH AOP AS PRINT SERVER
• 36737461 - COPY CHILD PAGE PROC TO OTHER PAGE LEADS TO WWV_PROCESS_DISPPOINT_CHILD_CK FAILURE
• 36725087 - TEMPLATE COMPONENT: ACTION MENU DOES NOT WORK WITH REGION ONLY TYPE
• 36758595 - REGRESSION: CREATE OR EDIT AUTOMATION ON REST SOURCE FAILS WITH "TABLE REQUIRED" MESSAGE
• 36741268 - IMPROVE CREATE APP ASSISTANT TO SEND TABLE AND PLURAL LABELS WITH INCREASED MAX TABLE COUNT LIMIT
• 36761481 - REGRESSION: APP EXPORT FAILS WITH ORA-06502 IF REGION CONTAINS COLUMNS WITH SINGLE QUOTE
• 36769667 - GENERATIVE AI: NEED AN OPTION TO PASS QUERY PARAMETERS TO GENERATIVE AI SERVICE
• 36744761 - PAGE DESIGNER: LAZY LOADING PROPERTY IS NOT VISIBLE FOR DYNAMIC CONTENT REGION
• 36765547 - APP IMPORT CONTAINING GEN AI SERVICE MARKED USED BY APP BUILDER FAILS IF ANOTHER ALREADY EXISTS
• 36754240 - SYSTEM_HELP_URL PARAMETER POINTING TO OLDER RELEASE DOCUMENTATION LINK
• 36754481 - CREATE APP ASSISTANT DATA DICTIONARY CACHE REFRESH SLOW AND BLOCKS FROM USING
• 36775283 - REST SOURCE CATALOG IMPORT FAILS ON APEX.ORACLE.COM
• 36745622 - REGRESSION: INSTALLING APP WITH WRAPPED PL/SQL IN SUPPORTING OBJECTS GIVES ERROR
• 36741229 - PROVIDE TABLE AND COLUMN LABELS IN THE SYSTEM PROMPT USED FOR THE NL2SQL APEX ASSISTANT
• 36789782 - ADB: ERROR ORA-20987: THE DBMS_CLOUD PACKAGE IS NOT AVAILABLE ON THIS SYSTEM WHILE IMPLEMENTING DOCUMENT GENERATOR
• 36745943 - UNABLE TO UNSET WORKSPACE_EMAIL_MAXIMUM PARAMETER USING API
• 36715586 - ADVISOR THROWS ORA-20555 ERROR WHEN RUNNING ON SAMPLE INTERACTIVE GRID APP
• 36797702 - ORACLE_APEX_DICTIONARY_CACHE JOB FAILED WITH ORA-01031: INSUFFICIENT PRIVILEGE

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

• 36748606 - REGRESSION: REPORT LAYOUT CORRUPTED AFTER IMPORT / EXPORT
• 36739676 - ORTHOGONAL DEFAULT ROUTING NOT PASSED AS EXPECTED TO DIAGRAM REGION
• 36705205 - WORKFLOW DIAGRAM REGION DISPLAYS NO DIAGRAM WHEN A ROUTE WITH MULTIPLE CYCLE-ITERATIONS IS PASSED
• 36791307 - ORA-29261: BAD ARGUMENT ORA-06512: AT "SYS.UTL_ENCODE - SSO OAUTH2
• 36833834 - IMPORTING AN APP USING A REPORT QUERY ON REST SOURCE WITH ARRAY COLUMN FAILS
• 36829992 - REGRESSION: NETWORK ACCESS DENIED MESSAGE IS NOT DISPLAYED FOR CREATION OF REST ENABLED SQL SERVICE IN A WORKSPACE WHERE ACL IS NOT GRANTED
• 36840880 - DATABASE CREDENTIAL WITHIN WEB CREDENTIAL DOES NOT WORK WHEN NAME CONTAINS SPECIAL CHARACTERS
• 36576188 - BUILDER ACCOUNT MENU DOES NOT SHOW "CHANGE WORKSPACE" LINK FOR SSO IN APP 4100
• 36814996 - APEX_HUMAN_TASK.SET_INITIATOR_CAN_COMPLETE API THROWS ORA-06592: CASE NOT FOUND EXCEPTION
• 36834702 - NO EASY WAY TO IDENTIFY WHICH APEX VIEWS ARE EXTENSION ENABLED
• 36874563 - DROP ORACLE.SODA.PRIVILEGE.DEVELOPER PRIVILEGE FROM APEX_PUBLIC_ROUTER ORDS CONFIG
• 36830590 - INTERACTIVE REPORT ACTIONS DIALOG INLINE PICKER DOES NOT DISPLAY IF THERE IS ANOTHER REGION ABOVE IT
• 36886566 - OUT PARAM DEFINED BY WEB SOURCE PLUG-IN CREATED AS IN UNEXPECTEDLY
• 36595944 - DATA PROFILE COLUMNS OF THE "JSON DOCUMENT" AND "ARRAY" TYPES ARE PASSED TO PLUG-IN CODE AS VARCHAR2 COLUMNS
• 36847892 - PACKAGE COMPILE ERROR FROM SUPPORTING OBJECT AND SQL WORKSHOP IF TABLE TYPE DECLARED
• 36887132 - INTERACTIVE REPORT BUILT-IN SINGLE ROW VIEW IMAGE ICON MISSING

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

• 36830843 - APEX UNIVERSAL THEME INTERACTIVE GRID FILTER CHIPS UNEXPECTED STYLES WHEN COLLAPSED
• 36740367 - LAYOUT ISSUES WITH TIMELINE TEMPLATE WHEN SELECTION IS NOT ENABLED
• 36831664 - APEX UNIVERSAL THEME REDWOOD LIGHT WIZARD/TRAIN DISPLAY WITHOUT LABELS MISALIGNED
• 36929684 - SOCIAL SIGN-IN: IDENTITY PROVIDER RETURNS ERROR "INVALID_CLIENT" AFTER UPGRADE TO 24.1
• 36909105 - INVALID POSITIONS IN REGIONS NOT SHOWING ANYMORE IN 24.1
• 36740019 - IMPORT APP WITH REPORT QUERY SOURCE HAS WRONG TABLE OWNER
• 36918538 - UNABLE TO SET RESOURCE CONSUMER GROUP USING APEX_INSTANCE_ADMIN API
• 36925895 - USE PUBLIC ORDS API TO REST ENABLE APEX_PUBLIC_ROUTER
• 36935641 - REGRESSION: OUTPUT REPORT QUERY DOESN'T DISPLAY VALUES ENCAPSULATED BY < AND > CHARACTERS
• 36973301 - THE SELECT LIST TO CHOOSE A REPORT LAYOUT FOR A REPORT QUERIES SHOWS ADDITIONAL AOP REPORT LAYOUTS
• 36974113 - REGRESSION: CUSTOM BRANCH_TO_PAGE_ACCEPT URL LOGIN FAILS IN 24.1 W/ CHECKSUM ERR
• 36893406 - ERROR MERGING WORKING COPY THAT ADDS REST DATA SOURCE ARRAY COLUMN
• 36878639 - WEB_SRC_UTILS.PROCESS_SINGLE_ROW_RESPONSE ENCOUNTERS ERROR W/ ARRAYS
• 36898028 - APEX_APPL_DATA_PROFILE_COLS MISSING PARENT_COLUMN FOR ARRAY COLUMNS
• 36993869 - SETTING BATCH/BULK DML TO OFF CLEARS ROOT RESOURCE NAME UNEXPECTEDLY
• 36998634 - CLASSIC REPORT WITH "CARDS TEMPLATE" DOES NOT ADD CHECKSUMS TO URLS IN #CARD_LINK# PLACEHOLDER
• 37004925 - JSON ORDER BYS DOC PASSED TO WEB SRC PLUGIN EXT ORDER BY W/ FACETED SEARCH COUNTS
• 36911806 - APPROVAL COMPONENT: T_TASK_EVENT.ACTION_STATUS TOO SMALL FOR OTHER LANGUAGES
• 37011365 - UNABLE TO DISPLAY THE TOTAL CONTENT STORED CLOB COLUMN OF A TABLE ONTO THE REPORT
• 37049174 - ERROR MESSAGE WHEN RECOMPILING OBJECTS AFTER 24.1.4 UPGRADE

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

• 36926831 - DEPRECATE TINYMCE IN FAVOR OF ORTL
• 37084087 - TEMPLATE COMPONENTS: STATIC FILES ARE NOT LOADED DURING PAGE RENDERING IN TRANSLATED APPLICATIONS
• 37090373 - DATEPICKER DOESN'T SIGNAL CHANGED IF VALUE IS CLEARED
• 37015157 - NOT POSSIBLE TO CHANGE AN APP ICON FROM CREATE APP WIZARD IF CREATE APP USING GENERATIVE AI USED
• 37106535 - REGRESSION DATE PICKER: APEX.ITEM.SETVALUE API DOES NOT UPDATE THE CALENDAR VIEW
• 37102294 - NON-ASCII CHARACTERS IN REGION PLUG-IN ATTRIBUTES CAUSE QUESTION MARKS IN APPLICATION EXPORT OUTPUT
• 37095401 - XSL-FO FILE IS NOT DEEMED A VALID TEMPLATE TYPE FOR PRINT SERVER

Bugs

• 36673163 - APEX SQL DEVELOPER WEB INTEGRATION ISSUE WHEN USING ORDS 24.1.0 WITH AN UPGRADED APEX 24.1 INSTANCE

  When using ORDS version 24.1.0 with an upgraded APEX 24.1 instance, if you click the link from APEX App Builder to SQL Developer Web, an error message ("Method Not Allowed") appears.

  This bug has been fixed in ORDS version 24.1.2.

APEX 24.1 Content Delivery Network (CDN)

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