Oracle APEX 22.2 Known Issues

APEX 22.2 was released on November 10, 2022.

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 7, 2024.

Patch Set Bundle for Oracle APEX 22.2(34628174)

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

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 14. When this patch is applied, the APEX product version will be updated to 22.2.14. 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 = 34628174 order by installed_on;

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

Patch Version: 1
  • 34703420 - TEXT FIELD WITH AUTOCOMPLETE SHOULDN'T TRIGGER CHANGE EVENT ON SELECTION
  • 34737968 - APPROVALS COMPONENT - COMPUTED DUE DATE SQL STATEMENT BIND VARS ALL GET VALUE NULL
  • 32413371 - INTERACTIVE GRID: END USER CHANGES (FILTER, ARRANGE COLUMNS) ARE RECORDED IN APP AUDIT COLUMNS
  • 34741309 - MANUAL TASK RENEWAL UNEXPECTEDLY RESETS RENEWAL COUNT
  • 34766999 - PERSISTENT AUTHENTICATION FAILS WHEN APP LINK IS OPENED FROM WECHAT 
  • 34752241 - EDIT DATA PROFILE - DYNAMIC ACTION ACTIONS NOT FIRED CORRECTLY WITH LOOKUP COLUMN TYPE
  • 34776987 - PERFORMANCE REGRESSION FOR XLSX LOADING OF "MEDIUM-SIZED XLSX FILES"
  • 34694482 - DEVELOPER TOOLBAR "SESSION" DIALOG DOES NOT RESPECT CHANGED PAGE ID
  • 34747046 - INTERACTIVE GRID: DATE PICKER PRODUCES ERROR WHEN TRY HIGHLIGHT/FILTER AND FORMAT MASK IS SINCE
  • 34799740 - APEX.DATE / NEW DATE PICKER: IF THE FORMAT MASK IS DAY AND DAYS CONSIST OF SEVERAL WORDS, THE CAPITALIZATION IS NOT CORRECT
  • 34695048 - APPLICATION BUILDER - DATE PICKER: BAD CONTRAST OF DAY GRID IN LIGHT MODE
  • 34802200 - WWV_PURGE.PURGE_WORKSPACES DOES FETCH ACROSS COMMITS
  • 34832851 - APPROVALS COMPONENT: CONSTRAINT ON WWV_FLOW_TASKS$.PREVIOUS_TASK_ID MUST BE REMOVED
  • 34788649 - REGRESSION: BINDING.JS: DOUBLE ESCAPING OF ATTRIBUTES WHEN USING DYNAMIC MIN MAX IN DATE PICKER
  • 34755867 - IMPORTING UPDATED APP VERSION INTO PROD DELETES TASK INSTANCES
  • 34674541 - TEXT FIELD WITH AUTOCOMPLETE TRIGGERS CHANGE EVENT WHILE TYPING
Patch Version: 2
Note: All bug fixes from the previous patch versions are included.
  • 34873699 - RUNNING ULTRP.SQL SEEING XDB NOW INVALID, COULD NOT FIND XDBCONFIG
  • 34964321 - CARD REGION: DISPLAY BLOB IMAGE FAILS IF COMBINED PK, MIMETYPE AND LAST MODIFIED INFORMATION IS TOO LONG
  • 34921302 - SOCIAL SIGN-IN ERROR WHEN USING CONFIGURATION PROCEDURE: THE HTTP REQUEST TO "#DISCOVERY_URL#" FAILED
  • 34986496 - REGRESSION: REMOTE DEPLOYMENT DOES NOT WORK WHEN DEPLOYING TO APEX 22.2
  • 34976781 - INTERACTIVE REPORT SUBSCRIPTION DOES NOT PICK UP REGION WEB SOURCE PARAMETER VALUES
  • 35046785 - DATE PICKER: MISSING SUPPORT OF AM IN FORMAT MASK AND WRONG HANDLING WHEN 12:XX PM IS SELECTED
  • 35042794 - APEX.ORACLE.COM: PAGE DESIGNER "PICK TABLE" DIALOG SHOWS UNACCEPTABLE PERFORMANCE
  • 35048332 - CATPATCH_CON.SQL THROWS ORA-20001: YOU CAN ONLY USE THIS SCRIPT TO PATCH RELEASE 22.2.% WHEN APPLYING PSE TO A CDB
Patch Version: 3
Note: All bug fixes from the previous patch versions are included.
  • 34944320 - APEX INCORRECTLY ADDING BACKSLASHES TO URIS
Patch Version: 4
Note: All bug fixes from the previous patch versions are included.
  • 34880536 - REGRESSION: INTERACTIVE REPORT: NAVIGATING IN SINGLE ROW VIEW OF IR PRODUCES ERROR
  • 35101826 - REGRESSION: DA-ASSIGNED-TO-NULL NUMBER FIELD NOW FLAGGED AS INVALID NUMBER ON SUBMIT
Patch Version: 5
Note: All bug fixes from the previous patch versions are included.
  • 35160611 - INVOKE API PROCESS: PAGE DESIGNER THROWS ERROR FOR CUSTOM DATA TYPE WITH NAME LONGER THAN 24 BYTE
Patch Version: 6
Note: All bug fixes from the previous patch versions are included.
  • 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
Patch Version: 7
Note: All bug fixes from the previous patch versions are included.
  • 35450075 - POSSIBLE SESSION CONTENTION IN SCHEDULER JOBS
Patch Version: 8
Note: All bug fixes from the previous patch versions are included.
  • 35526692 - APPROVAL COMPONENT: TASK PARAMETER VALUE IS LIMITED TO 255 CHARACTERS IN APEX_TASK_PARAMETERS
Patch Version: 9
Note: All bug fixes from the previous patch versions are included.
  • 35532402 - REGRESSION: INTERACTIVE GRID WITH RICH TEXT TYPE COLUMN ESCAPES OUTPUT IN HTML DOWNLOAD
Patch Version: 10
Note: All bug fixes from the previous patch versions are included.
  • 35658705 - IMPORT PAGE FAILS WITH PARENT KEY NOT FOUND ERROR
  • 35625669 - APPROVAL COMPONENT: CREATED ON, CREATED BY, LAST UPDATED ON AND LAST UPDATED BY IS OVERWRITTEN AT APP RE-IMPORT WITH REPLACEMENT
Patch Version: 11
Note: All bug fixes from the previous patch versions are included.
  • 35734474 - SAML SIGN-OUT BEHAVES DIFFERENTLY WHEN CONFIGURED FOR THE BUILDER THAN FOR AN APP
  • 35716957 - REGRESSION: DATA EXPORT AS PDF RAISES ERROR FOR UNSUPPORTED IMAGES
Patch Version: 12
Note: All bug fixes from the previous patch versions are included.
  • 35996877 - SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE LINE ENDINGS TO 0X0A (INVALID /RESPONSE/SIGNATURE)
Patch Version: 13
Note: All bug fixes from the previous patch versions are included.
  • 36229358 - SAML AUTH: XML CANONICALIZATION SHOULD NORMALIZE ENTITY ENCODINGS (
 to 
)
  • 36250686 - SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE
Patch Version: 14
Note: All bug fixes from the previous patch versions are included.
  • 36250686 - SAML AUTH: XML CANONICALIZATION FOR ASSERTION CONTAINS SUPERFLUOUS XMLNS FROM ROOT NODE

APEX 22.2 Content Delivery Network (CDN)

  • APEX 22.2 static resources are available on a CDN.
  • For APEX product versions 22.2.0, 22.2.1, 22.2.2, 22.2.3, 22.2.4, 22.2.5, 22.2.6, 22.2.7, 22.2.8, 22.2.9, 22.2.10, 22.2.11, 22.2.12, 22.2.13 and 22.2.14 use https://static.oracle.com/cdn/apex/22.2.0/. The CDN contains the production APEX 22.2 static resources and the updated static resources included in PATCH_VERSION 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 and 14.

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 34628174: PSE BUNDLE FOR APEX 22.2 (PSES ON TOP OF 22.2.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.