APEX 23.1 was released on May 17, 2023.
Please review the Release Notes for significant issues known at time of release. Any new significant issues will be added here. This page was last updated on March 6, 2024.
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:
select patch_version, installed_on from apex_patches where patch_number =
35283657 order by installed_on;
This cumulative patch includes the following bug fixes, grouped by patch version:
Patch Version: 135075104
- 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 NAME35381729
- REGRESSION: PERCENT GRAPH COLUMN IS ESCAPED IN HTML EXPRESSION OF INTERACTIVE REPORT35340435
- DB POOL NAME IS MISSING IN AUTOREST OBJECT URL35532402
- REGRESSION: INTERACTIVE GRID WITH RICH TEXT TYPE COLUMN ESCAPES OUTPUT IN HTML DOWNLOAD35579586
- MENU ENTRIES OF TEMPLATE COMPONENTS ARE DUPLICATED IF THE APP GETS TRANSLATED35501357
- APP_SAML_AUTH_METADATA NOT COMMITTED IN POST-AUTHENTICATION PROCEDURE LOGIC35536832
- AVATAR TEMPLATE PARTIAL RAISES ERROR IN INTERACTIVE REPORT35482969
- WWV_FLOW.SHOW POST REQUESTS SHOULD ALWAYS CONTAIN P_CONTEXT QUERY PARAMETER35522369
- TEMPLATE COMPONENT REPORT: REMOVE PRE-FETCHING OF DATA35531933
- 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 APP35526692
- APPROVAL COMPONENT: TASK PARAMETER VALUE IS LIMITED TO 255 CHARACTERS IN APEX_TASK_PARAMETERS35510125
- FOOTER FROM EMAIL TEMPLATE IS NOT BEING DISPLAYED IN EMAIL35504868
- REPLACING AN APP WITH BACKGROUND EXECS RAISES "ACCESS TO SESSION STATE IS DISABLED" ERROR35658705
- IMPORT PAGE FAILS WITH PARENT KEY NOT FOUND ERROR35679690
- TEMPLATE COMPONENT REGION ATTRIBUTES DO NOT GET TRANSLATED35527585
- P_CONTEXT PARAMETER IS MISSING IN WWV_FLOW.AJAX CALL IN F4750_P50.JS FILE35625669
- APPROVAL COMPONENT: CREATED ON, CREATED BY, LAST UPDATED ON AND LAST UPDATED BY IS OVERWRITTEN AT APP RE-IMPORT WITH REPLACEMENT35619859
- UPGRADE TO 23.1 FAILS DUE TO BUG IN UNIQUE INDEX ON PLUGIN ATTRIBUTES35213251
- SQL COMMANDS CAN SHOW APEX INTERNAL PACKAGE IN STACK TRACE WHEN ERROR OCCURS35711528
- JAVASCRIPT ERRORS OCCUR ON REGION DISPLAY SELECTOR35574855
- TEMPLATE COMPONENT: ACTIONS OF TYPE LINK DON'T SHOW TARGET PAGE PROPERTY35815444
- OBJECT BROWSER: 'SAVE AND COMPILE' DOESN'T DISPLAY ALL ERRORS35305108
- APEX_APPL_PAGE_SEARCH_SOURCES MISSING JOIN; RETURNS ROW FOR EVERY PAGE NAME35823778
- SEARCH REGION WITH TWO OR MORE SEARCH SOURCES BREAKS APPLICATION SEARCH35734474
- SAML SIGN-OUT BEHAVES DIFFERENTLY WHEN CONFIGURED FOR THE BUILDER THAN FOR AN APP35568630
- LOG WORKSPACE CREATION FOR REPORTING OVER TIME35796739
- SQL WORKSHOP LOAD DATA TO EXISTING TABLE: CANNOT LOAD VALUES WITH FRACTIONAL SECONDS TO DATE COLUMNS35554377
- SETTING EQ FILTER ON IG DATE COLUMN INTERPRETED AS UNSAVED CHANGE ON CLIENT SIDE35419252
- REGRESSION: CLOB SESSION STATE FAILS VALIDATIONS WHEN >32K35319758
- {WITH/}{APPLY/} CANNOT PASS &APEX$ITEM. INSIDE A {LOOP/}35510011
- CARDS, INTERACTIVE GRID, AND TEMPLATE COMPONENT REPORT SCROLL PAGINATION REQUEST TOO MUCH DATA35701019
- SIMPLE HTTP REST SOURCE TYPE: CHARACTER STRING BUFFER TOO SMALL IF "HAS MORE ROWS" JSON ATTRIBUTE IS LARGER THAN 255 BYTE35509624
- PAGE DESIGNER: TEMPLATE COMPONENT ON THE GLOBAL PAGE BREAKS THE LOADING OF OTHER PAGES35716957
- REGRESSION: DATA EXPORT AS PDF RAISES ERROR FOR UNSUPPORTED IMAGES35938522
- UPTAKE TINYMCE 6.7.135717714
- WHEN DISPLAY ZOOM IS LARGE, INTERACTIVE GRID DOES NOT SHOW THE 41ST ROW35857964
- INTERACTIVE REPORT SUBSCRIPTION FAILS WITH "SESSION ENDED ERROR" AFTER UPGRADE TO 23.135527223
- IG SHOW NO DATA WHEN MAXIMIZED AFTER USING REGION DISPLAY SELECTOR35832592
- BLANK PAGE AFTER TIMEOUT, WHEN SESSION SWITCHED TO SOCIAL SIGN-IN AUTH SCHEME35996877
- SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE LINE ENDINGS TO 0X0A (INVALID /RESPONSE/SIGNATURE)36041971
- FORCE PASSWORD CHANGE PAGE DOES NOT REDIRECT BACK TO FRIENDLY URL36229358
- SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE ENTITY ENCODINGS ( to 
)36250686
- SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE36250686
- SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE