Oracle APEX 21.1 Known Issues

Oracle APEX 21.1 Known Issues

APEX 21.1.0 was released on May 12, 2021.

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 December 17, 2021.

Bugs

32935381 - PERFORMANCE ISSUES FOR LOADING APEX PAGES WHEN USING ORDS 21.1
Solution: Upgrade to ORDS 21.1.3 or newer.
 
33063434 - APPLICATION IMPORT FAILS WITH "GET_BLOCK" ERROR IF APPLICATION COMMENT CONTAINS MANY UNICODE CHARACTERS
Solution: Remove the application comments, export the app and import, then reinstate the application comments.
 

 

Patch Set Bundle for Oracle APEX 21.1 (32598392)

The Patch Set Bundle for Oracle APEX 21.1 is available for download from My Oracle Support, via the following path: https://support.oracle.com/epmos/faces/PatchDetail?patchId=32598392. Navigate to Patches & Updates and search for patch number 32598392.
 
The Patch Set Bundle may be updated numerous times when new fixes are added to the bundle, and can be reapplied as needed. The Patch Set Bundle was last updated on December 17, 2021, and its PATCH_VERSION is 7. When this patch is applied, the APEX product version will be updated to 21.1.7. 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 = 32598392 order by installed_on;
 
This patch includes the following bug fixes:
 
33678557 - WORKSPACE PASSWORD RESET SHOWS: ERR-1014 APPLICATION NOT FOUND
33270320 - CLASSIC REPORT ALWAYS REQUESTS THE TOTAL ROW COUNT WHEN USED WITH FACETED SEARCH
33209293 - ORA-01400: CANNOT INSERT NULL INTO ("APEX_210100"."WWV_FLOW_SW_DETAIL_RESULTS"."STARTED") WHILE TRYING TO RUN THE SCRIPT FROM SQL WORKSHOP
33502089 - INVALID SCHEDULER CALENDAR EXPRESSIONS LEAD THE COORDINATOR JOB TO FAIL
33568963 - REGRESSION: REST SOURCE POST PROCESSING WITH "PL/SQL FUNC BODY RETURNING SQL QUERY" RAISES PLS-00103
33541186 - UPDATE OF IDLE TIMEOUT CAUSES UNNECESSARY IO FOR AJAX CALLS
30704900 - APEX_MAIL.SEND THROWS AN ORA-00942: TABLE OR VIEW DOES NOT EXIST - 19CDB
33300363 - APEX CONTENT-SECURITY-POLICY SYNTAX NOT APPEARING IN THE HTTP RESPONSE HEADERS
33063434 - APPLICATION IMPORT FAILS WITH "GET_BLOCK" ERROR IF APPLICATION COMMENT CONTAINS MANY UNICODE CHARACTERS
33235891 - AFTER UPGRADE TO APEX 20.2 FUNCTION STOPPED WORKING IN SHORTCUTS
33280889 - APEX_APP_SETTING.SET_VALUE DOES NOT SET THE VALUE IF VALID VALUE IS NULL
32897694 - REGRESSION: LABEL COLUMN SPAN OF 0 IS NOT USED
33307595 - UT 21.1 - SIDE NAVIGATION DOESN'T COLLAPSE OFF SCREEN ON MOBILE
32769532 - APEX_WEB_SERVICE MULTIPART FORM SUPPORT MAY CORRUPT BLOBS
33177936 - APEX_DATA_PARSER THROWS CHAR TO NUMBER CONVERSION ERROR WHEN "FORMULA STRING" CELLS USE AN XLSX DATE STYLE
32440879 - BUILD OPTION IGNORED FOR AJAX CALLBACKS
33212886 - UT 21.1 - INCORRECT HELP BUTTON ALIGNMENT
33212879 - UT 21.1 - INCORRECT LINE-HEIGHT ON DISPLAY ONLY ITEMS
33198130 - UT 21.1 - INCORRECT ALIGNMENT OF INPUTS SET TO READONLY
33212917 - UT 21.1 - DIALOG SPINNER REMAINS ON PAGE AFTER LOAD
33189831 - UT 21.1 - INCORRECT CHARACTERS APPEARING ON CHECKBOXES
33189860 - UT 21.1 - SIDE NAVIGATION COLLAPSED WITH ICONS HAS INCORRECT WIDTH
33198127 - UT 21.1 - NAVIGATION BAR HAS MISSING BADGE COLORS
33074565 - RIGHT COLUMN CANNOT BE SCROLLED WHEN USING REDWOOD THEME
32847919 - API TO SUPPORT DATABASE CHARSET CONVERSION FOR APEX STRINGS
32792411 - NOT POSSIBLE TO INSERT LINKS IN CK EDITOR 5 IN INLINE DIALOG
33004873 - PUBLIC VIEW APEX_WORKSPACES MISSING COLUMN ALLOW_PACKAGED_APP_INS_YN
33042527 - REGRESSION: EDITING AN LOV BASED ON REST SOURCE DUPLICATES REST SOURCE PARAMETERS
32797091 - LOCALE NEED TO BE PASSED DYNAMICALLY BASED ON THE APPLICATION INPUT
33061429 - UT 21.1 - MENUBAR BADGES MISSING STYLES
33061437 - UT 21.1 - DISPLAY ONLY ITEMS TEXT WRAPS ON MULTIPLE LINES
33061445 - UT 21.1 - PAGE ITEMS CLIPPED WHEN USING ITEM SPACING TEMPLATE OPTIONS
33061455 - UT 21.1 - PRE & POST TEXT "BLOCK" STYLES MISSING
33061460 - UT 21.1 - HELP BUTTON OVERLAPS LABEL IN FLOATING FIELDS
33061462 - UT 21.1 - HEADER AND LOGO SIZE NOT RESPECTING THEME ROLLER
33068660 - UT 21.1 - GRID COLUMNS DO NOT LINE UP WHEN COLUMNS DON'T EQUAL 12 WIDE
33040178 - REGRESSION: HTML TAGS ARE ESCAPED IN ERROR NOTIFICATIONS
33067031 - REGRESSION: APEX_ZIP.GET_FILE_CONTENT FAILS WITH ORA-06502
33082351 - DATE PICKER: PAGE SUBMIT SOMETIMES TRIGGERS DATE PICKER CHANGE LOGIC
33063548 - REGRESSION: APEX_UTIL.GET_PRINT_DOCUMENT SIGNATURE 2 PRINTS EMPTY FILES
32901225 - REGRESSION: FULL WORKSPACE IMPORT THROWS ORA-01400 ERROR
32841848 - APEX_UTIL.GET_PRINT_DOCUMENT IS NOT WORKING WITHOUT APEX SESSION
32841636 - PDF EXPORT: ORA-06592 WHEN DATA CONTAINS UNICODE CHARS NOT INCLUDED IN FONTS
32851644 - PDF EXPORT: SCRAMBLED ARABIC TEXT
32884820 - COPY PAGE WITH IR DOES NOT COPY REPORT ALIAS
32324411 - HIDE "ORACLE APPLICATION SERVER SINGLE SIGN-ON" AUTHENTICATION SCHEME IF NOT SUPPORTED
32886864 - DATA LOADING PAGE PROCESS RAISES ERROR IF SOURCE DATA TYPE SET TO SQL QUERY
32500177 - APEX CAN NOT DISPLAY ADDITIONAL LANGUAGE WHEN USING UTF8 FOR THE DATABASE CHARACTER SET
32902541 - REGRESSION CAN'T USE THE SAME SUBSTITUTION WITH DIFFERENT ESCAPE FILTERS
32909230 - NLS:APEX:AUTO FILLED WORKSPACE NAME BECOMES DECIMAL REFERENCE AFTER INPUT USER NAME
32853470 - FULL CALENDAR STYLES MISSING FORM UT 21.1, VITA, VITA DARK & RW LIGHT
32928010 - REST DATA SOURCE OR DATA LOADING FAILS WHEN NUMBER COLUMNS HAVE A FORMAT MASK
32933909 - PDF EXPORT: ORA-1403 IS RAISED FOR NON-UTF8 DB CHARACTER SETS
32902995 - MISC UNIVERSAL THEME 21.1 REGRESSIONS
32955854 - SAML: SINGLE LOG OUT RUNS INTO INVALID VALUE FOR PARAMETER: /LOGOUTREQUEST/SIGNATURE/SIGNEDINFO/REFERENCE/@URI
32961724 - RESPONSIVE UTILITIES ARE MISSING IN CORE.CSS FOR 21.1
32973256 - DATA LOADING LOG ERROR TO COLLECTION GENERATES PAGE WITH ERRORS REPORT REGION QUERYING EMPTY COLLECTION NAME
32907720 - APEX CREATES INVALID FOP/XSLT TEMPLATE FOR SPECIFIC LANGUAGES/PAGE FORMATS
32959945 - PDF DOWNLOAD OF IG REPORT HAVING LINE BREAKS IN THE TEXT THROWS ORA-01403
32980382 - REGRESSION: INTERACTIVE REPORT CSV EXPORT STRIPS HTML WHEN "CSV_LEGACY" HINT IS USED
32921485 - TIME OUT WHEN UPLOADING STARTER APPS ON APEX.ORACLE.COM
32851172 - WARN ON UNSAVED CHANGES NOT WORKING FOR ITEM TYPE "NUMBER FIELD"
32972477 - NUMBER FIELD ITEM GIVES WRONG RESULT WITH COMMA DEC SEP AND FORMAT MASK WITH NO D
32993056 - BROKEN REQUEST A WORKSPACE LINK IN TASKS REGION OF SIGN IN PAGE 4550:1

 

APEX 21.1 Content Delivery Network (CDN)

APEX 21.1 static resources are available on a CDN.

For APEX product versions 21.1.0 and 21.1.1, use https://static.oracle.com/cdn/apex/21.1.0/. The CDN contains the production APEX 21.1 static resources and the updated static resources included in PATCH_VERSION 1.

For APEX product version 21.1.2, 21.1.3, 21.1.4, 21.1.5, 21.1.6 and 21.1.7,  use https://static.oracle.com/cdn/apex/21.1.2/. The CDN contains the production APEX 21.1 static resources and the updated static resources included in PATCH_VERSION 1, 2, 3, 4, 5, 6 and 7. Please refer to the included README for instructions on using the new CDN.

Documentation
Resources
Related

#orclAPEX

 
@OracleAPEX
 
Linkedin
 
Facebook
 
ODTUG APEX Blogroll
 
APEX Community