Oracle APEX 22.2 Known Issues

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

• 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

• 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

• 34944320 - APEX INCORRECTLY ADDING BACKSLASHES TO URIS

• 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

• 35160611 - INVOKE API PROCESS: PAGE DESIGNER THROWS ERROR FOR CUSTOM DATA TYPE WITH NAME LONGER THAN 24 BYTE

• 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

• 35450075 - POSSIBLE SESSION CONTENTION IN SCHEDULER JOBS

• 35526692 - APPROVAL COMPONENT: TASK PARAMETER VALUE IS LIMITED TO 255 CHARACTERS IN APEX_TASK_PARAMETERS

• 35532402 - REGRESSION: INTERACTIVE GRID WITH RICH TEXT TYPE COLUMN ESCAPES OUTPUT IN HTML DOWNLOAD

• 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

• 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

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, and 22.2.11 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, and 11.

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.