32029693 - CLASSIC REPORT PRINTING: COLUMN HEADINGS INCLUDED WHEN COLUMN HEADINGS TYPE=NONE

Column headings are always included when downloading a Classic Report, even when the Headings Type is set to "None".

Workaround: No current workaround available.

32030024 - CLASSIC REPORT PRINTING: CSV DOWNLOAD FILENAME MODIFIED

In previous releases, the extension of the CSV filename for Classic Reports was respected if a custom extension was used (e.g. "report.txt"). In APEX 20.2 the CSV filename always ends with ".csv".

Workaround: No current workaround available.

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

 

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 June 10, 2021, and its PATCH_VERSION is 2021.06.09. If you installed the bundle prior to this date, it is recommended that you download the latest bundle and reapply. To verify the version currently installed, in your workspace open the Help > About dialog to inspect the value of Patch Version. Alternatively, query the APEX_PATCHES view using the following SQL statement:

 

 

This patch includes the following bug fixes:

 

32980382 - REGRESSION: INTERACTIVE REPORT CSV EXPORT STRIPS HTML WHEN "CSV_LEGACY" HINT IS USED

32758715 - ACCESS TO V$ VIEWS WITH COL=SYS_CONTEXT(...) CAN BE INEFFICIENT

32663412 - INTERACTIVE GRID RAISES ORA-00904 FOR CHART VIEW AND COLUMN WITH QUOTED COLUMN NAME

32730161 - REGRESSION: REST SOURCE OF THE "ORDS" TYPE RETURNS HTTP-400 WHEN BOTH "EXTERNAL FILTER" AND REPORT RUNTIME FILTERS ARE USED

32769983 - IMPORTING OLD APP CAN RESULT IN WWV_FLOW_CODE_EXEC_MLE.MLE_NOT_SUPPORTED ERROR

32629086 - EMAIL TEMPLATE PROCESSING CAN FAIL WITH ORA-6502 WHEN TEMPLATE CONTAINS MULTIBYTE CHARACTERS

32645089 - MISSING REGION SOURCES AFTER COPY/EXPORT OF APPLICATION WHEN USING DB TABLE

32574205 - SOCIAL SIGN-IN: ERROR WHEN ACCESS TOKEN IS BIGGER THAN 4000 BYTES

32537199 - REST SOURCE "RESPONSE" TYPE PARAMETER NOT PASSED BACK WHEN CACHED RESULT IS USED

32539151 - CARD REGION WITH FACETS NOT SHOWING IMAGES IF MULTIPLE VALUES SELECTED FOR A CHECKBOX FACET

32476787 - ORACLE HTTP SERVER 12C SETTING X-XSS-PROTECTION

32449442 - APEX INVALID AFTER DATABASE UPGRADE TO 21C

32010574 - UNABLE TO DOWNLOAD APPLICATION/WORKSPACE STATIC FILES AS A ZIP

32435254 - CARDS SCROLL PAGINATION DOES NOT RENDER ALL RECORDS AT THE END

32324403 - INITIALIZATION PL/SQL CODE IS NOT FIRING WHEN SAVING INTERACTIVE GRID

32347471 - AJAX PROCESSES DO NOT ALWAYS CALL DATABASE SESSION CLEANUP PL/SQL CODE

32234337 - AUTOMATIC TIME ZONE DETECTION FAILS FOR PUBLIC PAGE IF FRIENDLY URLS ARE TURNED ON

32165878 - APEX DATA LOADING WIZARD LOSES DOUBLE QUOTE

32365794 - APEX_REGION.OPEN_QUERY_CONTEXT WITH INTERACTIVE GRID IGNORES FILTERS OR RAISES ERRORS IN TRANSLATED APPS

32317530 - ADB: REQUESTS TAKE LONG TIME WHEN LEVEL9 DEBUG IS ENABLED

32319789 - XLSX EXPORT: SLOW PERFORMANCE FOR LARGE REPORTS

32045697 - MENUS > IF FIRST MENU ITEM HAS A SUB-MENU, IT WILL NOT OPEN ON HOVER THE FIRST TIME IT IS HOVERED

32093233 - ADB-S: PERMIT SET_WORKSPACE AND CREATE_USER CALLS BY ADMIN

32293583 - DISCOVERY OF "ORACLE SAAS" REST API THROWS ORA-6502: CHARACTER TO NUMBER CONVERSION ERROR

32157149 - CANNOT SET NEW PAGE NUMBER IN CREATE PAGE WIZARD WHEN APP CONTAINS > 1001 PAGES

32202013 - AGGREGATION FUNCTION IN THE INTERACTIVE GRID - TOTAL NO LONGER APPEARS

32303316 - APEX_DATA_PARSER / SQL WORKSHOP DATA LOADING CONSUMES TOO MUCH PGA FOR LARGE XLSX FILES

32297556 - APEX_UTIL._PRINT_DOCUMENT DOES NOT DO URL ESCAPING

32080408 - CARD REGION CSS CLASSES DOES NOT RENDER

32228104 - QUICK SQL HAS A DISPLAY ISSUE WITH SAFARI 13.1.2

32214154 - REGIONS: CACHE CONDITIONS OF TYPE PL/SQL OR SQL EXPRESSION HAVE NOT BEEN MIGRATED

32189779 - CARD REGION DOESN'T WORK IN TRANSLATED APPS

32188008 - REST DATA SOURCE "DELETE" OPERATION THROWS ORA-22275 (INVALID LOB LOCATOR) WHEN SERVICE RETURNS EMPTY RESPONSE

32155714 - REST DATA SOURCE WITH SYNC ENABLED BECOMES UNEDITABLE WHEN "FETCH ROWS" OPERATION IS REMOVED OR CHANGED

32151519 - WHEN CREATING "HTTP HEADER" WEB CREDENTIAL, APEX MIXES UP CLIENT ID AND CLIENT SECRET

32153507 - UPGRADE DOMPURIFY FROM 2.0.7 TO THE LATEST 2.2.2

32122973 - INTERACTIVE GRID: ERRORS WHEN DOWNLOADING REPORT WITH MULTIPLE ROW HIGHLIGHTS

32144931 - APEX_REGION.EXPORT_DATA ON INTERACTIVE REPORT AND CLASSIC REPORT USES REMOTE PRINT SERVER FOR PDF

32105958 - APEX_REGION.EXPORT_DATA BEHAVES WRONG DURING PRE-RENDERING

32123043 - CSV EXPORT: VALUES NOT ALWAYS ENCLOSED WHEN AUTOMATIC CSV ENCODING IS USED

32119232 - PLUG-IN IMPORT FAILS IF PRINT SERVER TYPE IS SET TO AOP OR REMOTE PRINT SERVER

32074458 - CREATE APP FROM A TABLE OR FILE UPLOAD CREATES INCORRECT DASHBOARD CHART LINKS

32078187 - MANAGING INTERACTIVE REPORT SUBSCRIPTIONS PAGE RAISES ORA-01830 ERROR

32050844 - REGRESSION: INTERACTIVE GRID NUMBER COLUMN WITH FORMAT MASK SHOWS AS "NAN", IF NLS DECIMAL CHAR IS COMMA

32085533 - STANDALONE CARDS REGION FAILS WITH JAVASCRIPT ERROR IF ITEMS TO SUBMIT IS SET

32085681 - INTERACTIVE REPORT WITH A PERCENT GRAPH COLUMN: DOWNLOAD AS CSV OR PDF RAISES ERROR

32077595 - SOCIAL SIGN-IN: VALUE_ERROR FOR FACEBOOK WHEN MAPPING ATTRIBUTE "PICTURE"

32020280 - INTERACTIVE REPORT: DOWNLOAD GROUP BY WITH COUNT WITHOUT SPECIFYING COLUMN RAISES ERROR

32045818 - CSV EXPORT: ERRORS DURING DOWNLOAD DUE TO NLS / ESCAPING

32063008 - REST DATA SOURCE PLUG-IN: ADDING AN APPLICATION LEVEL ATTRIBUTE LEADS TO ORA-2290

32069450 - APEX_EXEC.EXECUTE_WEB_SOURCE THROWS ORA-01403

32068419 - REST SOURCE SYNC DOES NOT PICK UP APPLICATION PROXY SERVE

32001315 - INTERACTIVE GRID QUERY ON 4000:145 (GRID EDIT LIST ENTRIES) IS INEFFICIENT

32058862 - ALL CODE EDITORS BREAK WHEN USING AN INSTANCE IMAGE PREFIX REFERENCING A CDN