Oracle APEX 23.1 Known Issues

Patch Set Bundle for Oracle APEX 23.1 (35283657)

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

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 March 6th, 2024, and its PATCH_VERSION is 9. When this patch is applied, the APEX product version will be updated to 23.1.9. 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:

• 35075104 - APP RE-IMPORT CHANGES OFFSETS WHEN EXPORTED WITH ORIGINAL IDS AND IMPORT OCCURS WITH SET_OFFSET();
• 35217899 - APEX EXPORT WITH -EXPORIGINALIDS DOES NOT SEEM TO PRESERVE THE ORIGINAL IDS
• 35354010 - REGRESSION: PAGE DESIGNER HANGS ON LOADING IF AN APP HAS MANY EMAIL TEMPLATES
• 35244986 - TEMPLATE COMPONENTS: MISSING LINK ATTRIBUTE GROUP AFTER CHANGING PAGES
• 35381042 -ORA-06502 WHEN THE APEX_MAIL PACKAGE IS EXECUTED (WORK AROUND PL/SQL BUG 35072180)
• 35418396 - BACKGROUND PROCESSING DOES NOT COPY SESSION CREDENTIALS TO WORKING SESSION
• 35410651 - REGRESSION: SQL WORKSHOP / SUPPORTING OBJECTS THROW ERROR WHEN SCRIPT CONTAINS COLONS
• 35354354 - REGRESSION: SQL WORKSHOP EDITORS SPLIT LONG LINES AT 4000 CHARACTERS
• 35396560 - REGRESSION: SWITCH CURRENT THEME FAILS WITH AN ERROR
• 35464016 - REGRESSION: CANNOT CREATE INTERACTIVE GRIDS AFTER APEX 23.1 UPGRADE
• 34844898 - CUSTOMERS ARE UNABLE TO UNLOCK INSTANCE ADMINISTRATOR ACCOUNT
• 35474788 - PUSH SUBCRIPTIONS ARE REMOVED AFTER REIMPORTING THE APP

• 35501357 - APP_SAML_AUTH_METADATA NOT COMMITED IN POST-AUTHENTICATION PROCEDURE LOGIC

• 35378812 - REST MODULE FULL URL INCORRECTLY INCLUDES MODULE NAME
• 35381729 - REGRESSION: PERCENT GRAPH COLUMN IS ESCAPED IN HTML EXPRESSION OF INTERACTIVE REPORT
• 35340435 - DB POOL NAME IS MISSING IN AUTOREST OBJECT URL
• 35532402 - REGRESSION: INTERACTIVE GRID WITH RICH TEXT TYPE COLUMN ESCAPES OUTPUT IN HTML DOWNLOAD
• 35579586 - MENU ENTRIES OF TEMPLATE COMPONENTS ARE DUPLICATED IF THE APP GETS TRANSLATED
• 35501357 - APP_SAML_AUTH_METADATA NOT COMMITTED IN POST-AUTHENTICATION PROCEDURE LOGIC
• 35536832 - AVATAR TEMPLATE PARTIAL RAISES ERROR IN INTERACTIVE REPORT
• 35482969 - WWV_FLOW.SHOW POST REQUESTS SHOULD ALWAYS CONTAIN P_CONTEXT QUERY PARAMETER
• 35522369 - TEMPLATE COMPONENT REPORT: REMOVE PRE-FETCHING OF DATA
• 35531933 - SAML AUTH: INVALID VALUE FOR PARAMETER: /RESPONSE/SIGNATURE (CANONICALIZATION)
• 35542652 - APEX_APP_BUILDER_API: MISC ERRORS LIKE ORA-01403 AND ORA-00060 IN OLD DATA REPORTER PACKAGED APP
• 35526692 - APPROVAL COMPONENT: TASK PARAMETER VALUE IS LIMITED TO 255 CHARACTERS IN APEX_TASK_PARAMETERS
• 35510125 - FOOTER FROM EMAIL TEMPLATE IS NOT BEING DISPLAYED IN EMAIL
• 35504868 - REPLACING AN APP WITH BACKGROUND EXECS RAISES "ACCESS TO SESSION STATE IS DISABLED" ERROR

• 35658705 - IMPORT PAGE FAILS WITH PARENT KEY NOT FOUND ERROR
• 35679690 - TEMPLATE COMPONENT REGION ATTRIBUTES DO NOT GET TRANSLATED
• 35527585 - P_CONTEXT PARAMETER IS MISSING IN WWV_FLOW.AJAX CALL IN F4750_P50.JS FILE
• 35625669 - APPROVAL COMPONENT: CREATED ON, CREATED BY, LAST UPDATED ON AND LAST UPDATED BY IS OVERWRITTEN AT APP RE-IMPORT WITH REPLACEMENT
• 35619859 - UPGRADE TO 23.1 FAILS DUE TO BUG IN UNIQUE INDEX ON PLUGIN ATTRIBUTES
• 35213251 - SQL COMMANDS CAN SHOW APEX INTERNAL PACKAGE IN STACK TRACE WHEN ERROR OCCURS

• 35711528 - JAVASCRIPT ERRORS OCCUR ON REGION DISPLAY SELECTOR
• 35574855 - TEMPLATE COMPONENT: ACTIONS OF TYPE LINK DON'T SHOW TARGET PAGE PROPERTY
• 35815444 - OBJECT BROWSER: 'SAVE AND COMPILE' DOESN'T DISPLAY ALL ERRORS
• 35305108 - APEX_APPL_PAGE_SEARCH_SOURCES MISSING JOIN; RETURNS ROW FOR EVERY PAGE NAME
• 35823778 - SEARCH REGION WITH TWO OR MORE SEARCH SOURCES BREAKS APPLICATION SEARCH
• 35734474 - SAML SIGN-OUT BEHAVES DIFFERENTLY WHEN CONFIGURED FOR THE BUILDER THAN FOR AN APP
• 35568630 - LOG WORKSPACE CREATION FOR REPORTING OVER TIME
• 35796739 - SQL WORKSHOP LOAD DATA TO EXISTING TABLE: CANNOT LOAD VALUES WITH FRACTIONAL SECONDS TO DATE COLUMNS
• 35554377 - SETTING EQ FILTER ON IG DATE COLUMN INTERPRETED AS UNSAVED CHANGE ON CLIENT SIDE
• 35419252 - REGRESSION: CLOB SESSION STATE FAILS VALIDATIONS WHEN >32K
• 35319758 - {WITH/}{APPLY/} CANNOT PASS &APEX$ITEM. INSIDE A {LOOP/}
• 35510011 - CARDS, INTERACTIVE GRID, AND TEMPLATE COMPONENT REPORT SCROLL PAGINATION REQUEST TOO MUCH DATA
• 35701019 - SIMPLE HTTP REST SOURCE TYPE: CHARACTER STRING BUFFER TOO SMALL IF "HAS MORE ROWS" JSON ATTRIBUTE IS LARGER THAN 255 BYTE
• 35509624 - PAGE DESIGNER: TEMPLATE COMPONENT ON THE GLOBAL PAGE BREAKS THE LOADING OF OTHER PAGES
• 35716957 - REGRESSION: DATA EXPORT AS PDF RAISES ERROR FOR UNSUPPORTED IMAGES

• 35938522 - UPTAKE TINYMCE 6.7.1
• 35717714 - WHEN DISPLAY ZOOM IS LARGE, INTERACTIVE GRID DOES NOT SHOW THE 41ST ROW
• 35857964 - INTERACTIVE REPORT SUBSCRIPTION FAILS WITH "SESSION ENDED ERROR" AFTER UPGRADE TO 23.1
• 35527223 - IG SHOW NO DATA WHEN MAXIMIZED AFTER USING REGION DISPLAY SELECTOR
• 35832592 - BLANK PAGE AFTER TIMEOUT, WHEN SESSION SWITCHED TO SOCIAL SIGN-IN AUTH SCHEME

• 35996877 - SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE LINE ENDINGS TO 0X0A (INVALID /RESPONSE/SIGNATURE)
• 36041971 - FORCE PASSWORD CHANGE PAGE DOES NOT REDIRECT BACK TO FRIENDLY URL

• 36229358 - SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE ENTITY ENCODINGS (
 to 
)
• 36250686 - SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE

• 36250686 - SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE

APEX 23.1 Content Delivery Network (CDN)

• APEX 23.1 static resources are available on a CDN.
• For APEX product version 23.1.0 use https://static.oracle.com/cdn/apex/23.1.0/. The CDN contains the production APEX 23.1 static resources.
• For APEX product versions 23.1.1, 23.1.2, 23.1.3 and 23.1.4 use https://static.oracle.com/cdn/apex/23.1.1/. The CDN contains the production APEX 23.1 static resources and the updated static resources included in PATCH_VERSION 1, 2, 3 and 4. Please refer to the included README for instructions on using the new CDN.
• For APEX product version 23.1.5, use https://static.oracle.com/cdn/apex/23.1.5/. The CDN contains the production APEX 23.1 static resources and the updated static resources included in PATCH_VERSION 5. Please refer to the included README for instructions on using the new CDN.
• For APEX product versions 23.1.6, 23.1.7, 23.1.8, and 23.1.9, use https://static.oracle.com/cdn/apex/23.1.6/. This CDN contains the production APEX 23.1 static resources and the updated static resources included in PATCH_VERSION 6, 7, 8 and 9. Please refer to the included README for instructions on using the new CDN.

Oracle Cloud Customers

• If you are an Oracle Cloud Infrastructure (OCI) customer using one of the data management services (for example, Oracle Base Database Service), your Customer Support Identifier (CSI) may not have the ability to download software patches from My Oracle Support. In this case, you can contact Oracle Support to request a one-time alternative download location. Please file a Service Request for your database service from OCI Console and specify which Oracle APEX patch you require, in this case:
  
  Patch 35283657: PSE BUNDLE FOR APEX 23.1 (PSES ON TOP OF 23.1.0)
  
  You will need to file another Service Request if you wish to download the next version of this Patch Set Bundle after it is published.
  
  
• If you are using Oracle Autonomous Database or Oracle APEX Application Development Service, Oracle automatically applies Patch Set Bundles to your database soon after they are published.