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

 

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

• Patch Version: 1

• Patch Version: 2

• Patch Version: 3

• Patch Version: 4

• Patch Version: 5

• Patch Version: 6

• Patch Version: 7

• Patch Version: 8

• Patch Version: 9

• Patch Version: 10

• Patch Version: 11

 

 

 

 

34151611 - MISSING '/' IN TAB.SQL APPROVALS COMPONENT DDL

34151906 - CAN'T SET 29 FEB IN DATEPICKER WHEN IT'S A LEAP YEAR

34052422 - CREATE FORM AND REPORT PAGE WIZARD GENERATES FORMAT MASKS FOR HIDDEN COLUMNS

34140222 - ORACLE APPLICATION EXPRESS - INTERMITTENT 500 ERROR WITH OHS 12C. EMPTY RESPONSE HEADER NAMES GENERATED

31042456 - HIGHLIGHT IN A SAVED INTERACTIVE GRID DISAPPEARS IF FILTERS/STRETCH COLUMN WIDTHS ARE USED

34021265 - UNEXPECTED FOCUS SHIFT AFTER CHANGING REGION TYPE IN PAGE DESIGNER

34119093 - WWV_FLOW_MAIL.BACKGROUND CALLS DBMS_SESSION.SET_IDENTIFIER WITH A TOO LONG ID

34123145 - "REST ENABLED QUERY" REST SOURCE TYPE USES TOO SMALL FETCH SIZE WHEN "ALLOW FETCH ALL ROWS" IS TURNED ON

34123261 - REST SOURCE TYPE "REST ENABLED SQL" SENDS "LOCAL FILTERS" TO THE REMOTE SERVER

34142592 - AUTOMATIC BACKUP NOT WORKING FOR APPLICATIONS WITH LARGE NUMBERS OF CHANGES

34170140 - SAML AUTH: ASSERTION CAN NOT BE VERIFIED IF IT CONTAINS NEWLINES

34188499 - REST ENABLED SQL: SOME ENDPOINTS (OCI MYSQL) RESPOND WITH HTTP-404, IF THE ENDPOINT URL HAS A TRAILING SLASH

34185616 - REGRESSION: OVERALL AGGREGATES MISSING IN REPORT DOWNLOADS

33491949 - FRIENDLY URL'S ARE NOT WORKING WHEN APP ALIAS OR PAGE ALIAS ARE NUMBERS

34215142 - REGRESSION: CHECKBOX GROUP ITEM VALUE NOT SENT TO SERVER, FAILING VALIDATION

34122298 - REGRESSION: INTERACTIVE GRID POPUP LOV COLUMN WITH MANUAL ENTRY = ON LEADS TO ORA 6553 ON ROW SEARCH

34054368 - REGRESSION: MULTISELECT POPUPLOV W/ COMMA SEP TREATS CSV VALUES AS ONE

34004879 - REGION DISPLAY SELECTOR TITLES DO NOT RESPECT COMPONENT-BASED AUTHORIZATION SCHEMES

34007404 - JQUERY DATEPICKER - MINUTES AND HOURS HAS THE WRONG ORDER

34233744 - UNIVERSAL THEME MISSING FLEX UTILITY CLASSES

 

 

 

34258334 - REGRESSION: PDF DOWNLOAD DOES NO LONGER SUPPORT BR TAGS / LINE BREAKS

34266195 - INTERACTIVE REPORT WRONG GROUP BY RESULT IF GROUP BY COLUMN HTML EXPRESSION BUILT USING OTHER COLUMN

34263099 - PROPERTY EDITOR: CODE EDITOR SOMETIMES LOSES EDITS ON RE-VALIDATION

34263394 - UNIQUE APP ALIAS GENERATED ON IMPORT CAN BECOME EXTREMELY LONG FOR COMMONLY IMPORTED APPS

34283484 - STABLE: GETTING ORA-01920 UPON CREATING WORKSPACE USING EXISTING SCHEMA

 

 

 

34395538 - PDF DOWNLOAD GETS CORRUPTED

 

 

 

34320319 - REGRESSION: ERROR DOWNLOADING REPORT W/ FORMAT MASK USING SUBSTITUTION VARIABLE

34353896 - AJAX ERROR WHEN THE SCHEMA IS NOT ASSIGNED TO THE WORKSPACE BUT THE APP PARSING SCHEMA HAS PRIVILEGES ON THE OBJECT

 

 

 

34492232 - PUBLISH TRANSLATION ERROR FOR TABLE WWV_FLOW_TASK_DEF_ACTIONS - CASE NOT FOUND WHILE EXECUTING CASE STATEMENT

34227903 - FROM INTERNAL ADMIN, WHILE CREATING A NEW USER, WE DO NOT HAVE TO PROVIDE PASSWORD, BUT THEN CLICKING ON CREATE USER WITH OUT THE PASSWORD SHOW 400 BAD REQUEST

34463629 - REGRESSION: SHUTTLE ITEM - CLIENT SIDE VALIDATION FAILS WHEN SHUTTLE HAS VALUE BUT IT DID NOT CHANGE

34385347 - UNIVERSAL THEME SIDE NAVIGATION MENU ERRORS OUT WHEN ALL LIST ENTRY ID ATTRIBUTES ARE FILLED

34032095 - LOCAL POST PROCESSING QUERY IGNORED WHEN USE REST SYNC TABLE ENABLED

34351946 - HTTP-404 WITH APEX FRIENDLY URL WHEN THE CONTEXT ROOT AND APEX WORKSPACE ARE SAME

 

 

 

34463629 - REGRESSION: SHUTTLE ITEM - CLIENT SIDE VALIDATION FAILS WHEN SHUTTLE HAS VALUE BUT IT DID NOT CHANGE

 

 

 

34231006 - SAML AUTH: ERROR IN WWV_FLOW_ASN1 PACKAGE WHEN PARSING CERTIFICATE WITH SPACES

34257937 - SAML AUTH: ERROR REGISTERING CERTIFICATE WITHOUT VERSION IDENTIFIER

32413371 - INTERACTIVE GRID: END USER CHANGES (FILTER, ARRANGE COLUMNS) ARE RECORDED IN APP AUDIT COLUMNS

34766999 - PERSISTENT AUTHENTICATION FAILS WHEN APP LINK IS OPENED FROM WECHAT

 

 

 

34873699 - RUNNING ULTRP.SQL SEEING XDB NOW INVALID, COULD NOT FIND XDBCONFIG

35450075 - POSSIBLE SESSION CONTENTION IN SCHEDULER JOBS

 

Patch Version: 9

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

Patch Version: 10

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

Patch Version: 11

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

34068675 - COMBINATION CHART THROWS JAVASCRIPT ERROR WHEN REFRESHED USING DYNAMIC ACTIONS

 

APEX 22.1 Content Delivery Network (CDN)

• APEX 22.1 static resources are available on a CDN.
• For APEX product versions 22.1.0, 22.1.1, 22.1.2, 22.1.3, 22.1.4, 22.1.5, 22.1.6, 22.1.7, 22.1.8, 22.1.9, 22.1.10 and 22.1.11, use https://static.oracle.com/cdn/apex/22.1.0/. The CDN contains the production APEX 22.1 static resources and the updated static resources included in PATCH_VERSION 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and 11.