Oracle APEX 21.2 Known Issues

Oracle APEX 21.2 Known Issues

APEX 21.2 was released on November 4, 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 November 3, 2022.

Patch Set Bundle for Oracle APEX 21.2(33420059)

The Patch Set Bundle for Oracle APEX 21.2 is available for download from My Oracle Support, via the following path: https://support.oracle.com/epmos/faces/PatchDetail?patchId=33420059. Navigate to Patches & Updates and search for patch number 33420059.
 
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 November 3, 2022, and its PATCH_VERSION is 9. When this patch is applied, the APEX product version will be updated to 21.2.9. 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 = 33420059 order by installed_on;
 
This patch includes the following bug fixes:
 
33543999 - CARDS REGION ACTION LINK ATTRIBUTE RENDERS OVER ESCAPED
33539379 - PWA BACKGROUND COLOR IS NOT EXPORTED CORRECTLY, CAUSING IMPORT CRASH
33536015 - REGRESSION: INTERACTIVE REPORT SUBSCRIPTION ATTACHMENT FILENAME IS WRONG
33502089 - INVALID SCHEDULER CALENDAR EXPRESSIONS LEAD THE COORDINATOR JOB TO FAIL
33521738 - INTERACTIVE GRID: WRONG COLUMN ORDER WITH CONDITIONAL COLUMNS
33500729 - REGRESSION: INTERACTIVE REPORT BLOB DOWNLOAD ALWAYS AS ATTACHMENT
32131583 - INTERACTIVE GRID - COLUMN ORDER NOT PRESERVED AFTER RESIZE & REFRESH
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
33551886 - CONFUSION WHEN PWA IS UNAVAILABLE TO INSTALL
33266662 - ENVIRONMENT BANNER CAUSES RESIZE ISSUES
33600780 - REGRESSION: #ROWNUM# SUBSTITUTION IN CLASSIC REPORT DOES NOT WORK ANY MORE
33529988 - UT 21.1 - GEOCODED ADDRESS ITEM: ITEM DOESN'T RESPECT REQUIRED ATTRIBUTE / VALIDATION
33529859 - DISPLAY MAP ITEM: IF MARKER COLOR IS NULL, THE ITEM DOESN'T PICK UP DEFAULT COLOR FROM THEME
33483848 - INTERACTIVE GRID DATE PICK WITH POPUP DOESN'T STAY IN THE CELL
33526376 - UNIVERSAL THEME 21.2: FIXED HEADERS ON MOBILE BROKEN
33536521 - FOCUSING ON SMART FILTERS SEARCH BAR ON IOS CAUSES SAFARI TO ZOOM
33589210 - UNIVERSAL THEME VITA DARK USING INCORRECT PRIMARY COLOR
33404549 - PRE TEXT IS GETTING DISPLAYED AFTER DISPLAY MAP PAGE ITEM
33493972 - DATE PICKER DOESN'T HAVE RED BORDER ON FAILED VALIDATION
33395892 - PWA INSTRUCTIONS MODAL FOR IOS 15 DOES NOT REFLECT ACTUAL UI OF SAFARI
33670264 - SAML AUTH ERROR ON AZURE: ORA-30625: METHOD DISPATCH ON NULL SELF ARGUMENT IS DISALLOWED
33678557 - WORKSPACE PASSWORD RESET SHOWS: ERR-1014 APPLICATION NOT FOUND
33737354 - TOO MANY ROWS WHEN ACTIVATING PWA INSTALLABLE ON 4000:4001
33686557 - PDF OF INTERACTIVE REPORT WITH LEADING NULL-VALUED COLUMN CONTAINS GARBLED FORMATTING
33665357 - INTERACTIVE GRID - EDITING ROW SEARCH FILTER THROWS JAVASCRIPT ERROR
33765879 - RESTORE THEME SUBSCRIPTION DELETES TEMPLATES WITH ZERO REFERENCES
33494082 - INCORRECT DATE VALIDATION
33073050 - DATE PICKER: VALID DATE VALIDATION FAILS WHEN APP IS IN A DIFFERENT LANGUAGE
33674249 - APEX.DATE.PARSE SHOULD SUPPORT MONTH, DAY, DS & DL FORMAT MASK
33603077 - APEX.DATE PARSE IS ONLY WORKING IN ENGLISH WHEN USING MON IN PARSE FORMAT
33625554 - APEX.DATE.FORMAT RETURNS LOCALIZED VERSION FOR DD FORMAT
33804998 - REGRESSION: APEX.DATE.PARSE RESULTS COULD BE WRONG ON CERTAIN DAYS
33857017 - WORKSPACE SPACE REQUESTS RESULT IN NO-OP WHEN APPROVED AFTER NEW INSTANCE_TABLESPACE
33810455 - JET DATEPICKER - REMOVE DOUBLE ESCAPING FOR GETVALUE BEFORE JET IS LOADED
33698427 - REGRESSION: ITEM IS NULL CLIENT-SIDE CONDITION FAILS FOR POPUPLOV DYNAMIC ACTION
33862263 - APEX.DATE.DEFAULT_DATE_FORMAT IS NOT SET CORRECTLY AFTER INITIALIZATION
33862228 - IMPROVE ERROR HANDLING AND VALIDATIONS OF APEX.DATE.PARSE WHEN PARSING A DATE STRING
33807678 - ERRORS WHEN USING SPECIFIC FORMAT MASKS IN DIFFERENT LANGUAGES
25421217 - INTERACTIVE GRID: CLICKING 'GO' TWICE QUICKLY RESULTS IN DUPLICATED RESULT DATA
33874026 - DATEPICKER: TIME CANNOT BE SET VIA POPUP FOR CERTAIN FORMAT MASKS
33845275 - SAML AUTH: AUTHNREQUEST SHOULD CONTAIN DESTINATION
33924085 - WORK AROUND DB BUG 33050182 (JSON_EXISTS WRONG RESULTS) FOR FACETED SEARCH
34052817 - BACKPORT: SMART FILTER OR FACETED SEARCH W/ BIND VAR SHOWS NO CHOICES IN CHECKBOX GROUP
34047956 - REGRESSION: THEME42.JS CHANGED FROM USING HTML ATTRIBUTE DOUBLE QUOTES TO SINGLE QUOTE
34027021 - UPGRADED INSTANCE WITH WEBSHEETS DISPLAY WEBSHEET DEPRECATION WITH INVALID EINSTEIN LINK
33998868 - PAGE DESIGNER THROWS JAVASCRIPT ERROR WHEN CHANGING A PAGE ITEM LEGACY DATABASE COLUMN ATTRIBUTE
34000577 - REGRESSION: INTERACTIVE GRID CONTROL BREAK WITH SORT NULLS = FIRST LEADS TO ORA-6502 ERROR
34049625 - ALLOW ADB-S USERS TO CHANGE INTERNAL AUTHENTICATION SCHEME
34091265 - URL WITH APEX_CLONE_SESSION REQUEST SHOULD ALWAYS REDIRECT
34114473 - 21.2 PSE DOES NOT WORK IN APPLICATION CONTAINER
32850886 - INTERACTIVE REPORT: HIGHLIGHT & FILTER DIALOGS FAIL TO LOAD FIRST TIME, WHEN IMAGES ARE FROM CDN
29924673 - IR SUBSCRIPTION DATA PICKER DOESN'T SHOW TIME FIELDS AND TODAY BUTTON
34151906 - CAN'T SET 29 FEB IN DATEPICKER WHEN IT'S A LEAP YEAR
34004879 - REGION DISPLAY SELECTOR TITLES DO NOT RESPECT COMPONENT-BASED AUTHORIZATION SCHEMES
33964860 - STACKED DIALOG CLOSE EVENTS LEADS TO JAVASCRIPT ERROR WHEN FIRED IN SEQUENCE
34007404 - JQUERY DATEPICKER - MINUTES AND HOURS HAS THE WRONG ORDER
32413371 - INTERACTIVE GRID: END USER CHANGES (FILTER, ARRANGE COLUMNS) ARE RECORDED IN APP AUDIT COLUMNS

Bugs

33503392 - WRONG PWA INSTALLATION INSTRUCTIONS FOR IPHONE IN DE, PT-BR AND SR

Problem: Two text messages across three languages were not translated correctly regarding the PWA instructions for iPhone and iPad.
Solution: If you require those translations in your application, we suggest creating an application text message from the Shared Components with the following configuration:

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPHONE
Language: de

<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Diese Website verfügt über App-Funktionen. Fügen Sie sie Ihrem Home-Bildschirm hinzu, um diese bestmöglich nutzen zu können.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Tippen Sie auf das Symbol <strong>Freigeben</strong> in der Navigation unten</p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Scrollen Sie nach unten, und tippen Sie auf <strong>Zu Home-Bildschirm hinzuf.</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Tippen Sie zur Bestätigung auf <strong style="color:#007AE1;">Hinzufügen</strong></p>
    </div>
</div>

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPHONE
Language: pt-br

<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Este site tem funcionalidade de aplicativo. Adicione-o à sua tela inicial para obter a melhor experiência.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Toque no ícone <strong>Compartilhar</strong> junto à barra de endereço</p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Toque em <strong>Adicionar à Tela Inicial</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Toque em <strong style="color:#007AE1;">Adicionar</strong> para confirmar</p>
    </div>
</div>

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPHONE
Language: sr

<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Ова веб локација има функцију апликације. Додајте је на почетни екран да бисте остварили најбољи доживљај.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Додирните икону <strong>Дели</strong> у навигацији на дну</p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Крећите се надоле и додирните <strong>Додај на почетни екран</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Додирните ставку <strong style="color:#007AE1;">Додај</strong> да бисте потврдили</p>
    </div>
</div>

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPAD
Language: de
<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Diese Website verfügt über App-Funktionen. Fügen Sie sie Ihrem Home-Bildschirm hinzu, um diese bestmöglich nutzen zu können.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Tippen Sie auf das Symbol <strong>Mehr</strong> neben der Adressleiste</p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Tippen Sie auf <strong>Zu Home-Bildschirm hinzuf.</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Tippen Sie zur Bestätigung auf <strong style="color:#007AE1;">Hinzufügen</strong></p>
    </div>
</div>

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPAD
Language: hr

<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Ovo web-mjesto ima funkcionalnost aplikacije. Kako biste najbolje iskoristili njegove mogućnosti, dodajte ga na početni zaslon.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Dodirnite ikonu <strong>Više</strong> uz adresnu traku    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Dodirnite <strong>Dodaj na početni zaslon</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Dodirnite <strong style="color:#007AE1;">Dodaj</strong> za potvrdu</p>
    </div>
</div>

Text message name: APEX.PWA.INSTRUCTIONS.IOS.SAFARI.IPAD
Language: pt-br

<div class="a-pwaDialog-introWrapper">
    <p class="a-pwaDialog-intro">Este site tem funcionalidade de aplicativo. Adicione-o à sua tela inicial para obter a melhor experiência.</p>
</div>
<div class="a-pwaDialog-steps">
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-1.svg" />
        <p class="a-pwaDialog-stepText">1. Toque no ícone <strong>Compartilhar</strong> junto à barra de endereço</p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-ios-safari-2.svg" />
        <p class="a-pwaDialog-stepText">2. Toque em <strong>Adicionar à Tela Inicial</strong></p>
    </div>
    <div class="a-pwaDialog-step">
        <img class="a-pwaDialog-stepImage" src="#IMAGE_PREFIX#pwa/apex-pwa-instructions-check.svg" />
        <p class="a-pwaDialog-stepText">3. Toque em <strong style="color:#007AE1;">Adicionar</strong> para confirmar</p>
    </div>
</div>

 

APEX 21.2 Content Delivery Network (CDN)

  • APEX 21.2 static resources are available on a CDN.
  • For APEX product versions 21.2.0 and 21.2.1, use https://static.oracle.com/cdn/apex/21.2.0/. The CDN contains the production APEX 21.2 static resources and the updated static resources included in PATCH_VERSION 1.
  • For APEX product version 21.2.2 and 21.2.3, use https://static.oracle.com/cdn/apex/21.2.2/. The CDN contains the production APEX 21.2 static resources and the updated static resources included in PATCH_VERSION 1, 2 and 3. Please refer to the included README for instructions on using the new CDN.
  • For APEX product version 21.2.4, 21.2.5, 21.2.6, 21.2.7, 21.2.8 and 21.2.9, use https://static.oracle.com/cdn/apex/21.2.4/. The CDN contains the production APEX 21.2 static resources and the updated static resources included in PATCH_VERSION 4, 5, 6, 7, 8 and 9. 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