10 Fixed Bugs
The following section lists bugs fixed in this release.
Table 10-1 Fixed Bugs in Oracle APEX 22.2
| Bug Number | Description |
|---|---|
| 25673217 | INTERACTIVE GRID DOES NOT SUPPORT BLOB COLUMNS |
| 30250291 | INTERACTIVE GRID: IG_RPT_NAME_UK ERROR WHEN UPDATING REPORT SETTINGS |
| 30450209 | SQL WORKSHOP: V$SESSION INSTRUMENTATION FOR SQL SCRIPTS IS INCONSISTENT |
| 31048028 | INTERACTIVE GRID: DYNAMIC COLUMN NAME NOT MAINTAINED IN VALIDATION MESSAGE |
| 31193604 | PAGE DESIGNER: VALIDATION EDITABLE REGION SHOULD NOT ALLOW SELECTING FORM REGION TYPE |
| 32070574 | WARN ON UNSAVED CHANGES BROKEN AFTER MODAL DIALOG PAGE CLOSES |
| 32079384 | CLASSIC REPORT CURRENT COLUMN SORT NOT PERCEIVABLE WITH SCREEN READERS |
| 32479148 | DYNAMIC ACTION EVENT 'AFTER REFRESH' SHOULD NOT BE DEFAULT FOR REGIONS THAT DON'T SUPPORT IT |
| 32532058 | COLLAPSIBLE REGION TEMPLATE NEEDS ACCESSIBILITY IMPROVEMENT |
| 32861547 | APEX_DATA_PARSER ERRORS OUT WITH ORA-06502 IF FIRST ROWS CONTAIN UNICODE CONTENT LONGER THAN 128 BYTE |
| 33040542 | SHARED LOV PAGE: MISSING VALIDATION TO CHECK MAPPING COLUMNS ARE DEFINED IN 'ADDITIONAL DISPLAY COLUMNS' |
| 33140144 | ERROR WHEN CLICKING ON LINK WITH \ESCAPED\ PAYLOAD THAT NAVIGATES FROM DIALOG TO NORMAL PAGE |
| 33184216 | UNDO BUTTON IS ENABLED ON THEME ROLLER EVEN THOUGH THERE IS NOTHING TO UNDO |
| 33233910 | LIST OF VALUES EDIT PAGE > SWITCHING FROM TABLE TO SQL QUERY CAN RESULT IN CONSTRAINT ERROR |
| 33302244 | INTERACTIVE AND CLASSIC REPORT DOWNLOADS TRIGGER "WARN ON UNSAVED CHANGES" MESSAGE |
| 33475574 | PAGE DESIGNER PROPERTY EDITOR NUMBER FIELDS DON'T SUPPORT COPY AND PASTE |
| 33522530 | APEX SHOULD NOT ALLOW TO USE "FILES" AS THE PAGE ALIAS, AS RUNNING THE PAGE FAILS WITH HTTP-400 |
| 33591098 | INTERACTIVE REPORT FILTERS NEEDS ACCESSIBILITY IMPROVEMENTS |
| 33655826 | GETTING ERRORS WHEN THE SWITCHED THEME DOESN'T HAVE A MAPPED TEMPLATE |
| 33719312 | UNIVERSAL THEME FLOATING LABELS ANIMATIONS |
| 33875951 | SUCCESS MESSAGES CAN BE ANNOUNCED TWICE BY JAWS |
| 33957428 | DATA LOADING: PROVIDE NEW COLUMN TYPE "LINE NUMBER" |
| 33969953 | DATA GENERATOR: DATA SOURCE COLUMNS NOT POPULATED AFTER NEW CUSTOM DATA SOURCE CREATED |
| 33991020 | APEX_APPLICATION_LIST_ENTRIES DOES NOT SHOW AUTH SCHEME NAME FOR TRANSLATED ENTRIES |
| 33996486 | MLE OBJECT GRANTS REVOKED FROM USER SCHEMA ON APEX UPGRADE OR UNINSTALL |
| 33998885 | PWA APPLICATION NAME IS NOT RESOLVING SUBSTITUTIONS AT RUNTIME |
| 34002437 | NEW DATA LOADING: TRANSFORMATION RULE "REPLACE" DOES NOT ALLOW TO REPLACE WITH NULL (STRIP OUT) |
| 34003115 | PUBLISHING A THEME TO APP SUBSCRIBERS LEADS TO AN INDEX VIOLATION |
| 34005344 | ORACLE APEX ADVISOR SHOWS WRONG MESSAGES |
| 34012116 | EMAIL TEMPLATE UTILIZATION REPORT INCLUDES INCORRECT ROWS FROM OTHER APPLICATIONS |
| 34012638 | IR SUBSCRIPTION SESSION GETS MARKED TO PURGE WHEN SIGN OUT CLICKED FROM AN APP USING SAML AUTH |
| 34012897 | APEX GALLERY: WHEN INSTALLATION OF SUPPORTING OBJECTS FAILS THE GALLERY DOES NOT DETECT THAT APP IS INSTALLED |
| 34012954 | SESSION OVERRIDES: REORDER GROUPS IN SESSION OVERRIDES FEATURE |
| 34013988 | MASTER DETAIL PAGE DOESN'T LOAD THE DETAIL REGION ROWS AFTER REFRESH |
| 34014879 | DON'T START AUTOMATIONS AND EMAIL JOBS UNTIL THE FIRST AUTOMATION/EMAIL IS CREATED |
| 34015610 | DATA LOADING: ERROR MESSAGE DISPLAYED FOR LOADING OF INVALID JSON FILE SHOULD BE MORE CLEARER |
| 34016829 | FILE BROWSE ITEM IN FORM REGION ERRORS OUT AFTER COPYING THE PAGE |
| 34020505 | DATA GENERATOR: FORMULA PROPERTY VALUE IS NOT SAVED WHEN DATA SOURCE TYPE IS NOT "FORMULA" |
| 34026101 | DATA GENERATOR: MISSING MAX LENGTH ATTRIBUTES FOR PAGE ITEMS |
| 34027348 | REST SOURCE SYNC CREATES "JSON DOCUMENT" COLUMN AS VARCHAR INSTEAD OF CLOB IN LOCAL TABLE |
| 34029928 | INTERACTIVE REPORT THROWS ORA-936 IF THERE IS NO VISIBLE COLUMN TO RENDER |
| 34032488 | PAGE DESIGNER NO LONGER AUTO-FOCUSES RENDERING TAB IN 2 PANE MODE |
| 34032561 | THEME ROLLER ISSUE WHEN A LESS FILE IS NOT FOUND |
| 34032804 | FOCUS ON SEARCH FIELD OF SMART FILTER, WITH ONLY REQUIRED SEARCH FACET, RESULTS IN MOMENTARY FLASH OF EMPTY DROPDOWN |
| 34033306 | PAGE DESIGNER DOES NOT REMEMBER CURRENT PAGE ON REFRESH |
| 34037405 | HELP TEXT FOR RANGE FACETS SHOULD CONTAIN LOV SYNTAX EXAMPLES |
| 34047243 | SUPPORT MAX_STRING_SIZE=EXTENDED FOR DATA PROFILES |
| 34064516 | DATA GENERATOR: COLUMN COUNT IS WRONG IN THE DATA GENERATOR REPORT |
| 34065533 | DATA GENERATOR: COLUMN AND TABLE SEQUENCE VALUES ARE NON EDITABLE |
| 34066159 | QUICK SQL IDENTITY PK WITH SAMPLE DATA CAUSES FORM PAGE TO ERROR OUT WITH UNIQUE CONSTRAINT |
| 34070384 | ERROR PROCESSING VALIDATION WHEN SWITCHING THEMES AND NO THEMES SELECTED |
| 34077180 | INTERACTIVE GRID MASTER DETAIL ADD BUTTON ON DETAIL DISABLED AFTER SAVE NEW MASTER ROW |
| 34086815 | INTERACTIVE REPORT AGGREGATE OF COMPUTED COLUMN UNEXPECTEDLY LEFT-ALIGNED |
| 34087189 | BUILD OPTION SELECTED TO INCLUDE DURING APP UPGRADE DOES NOT GET INCLUDED |
| 34090790 | DATA GENERATOR: REQUIRED TOGGLE BUTTON IS NOT GETTING DISABLED FOR A COLUMN |
| 34093041 | USING A TRANSFORMATION IN A REST DATA SOURCE COLUMN CAUSES ORA-00904 ERROR. |
| 34097011 | DATA LOAD MERGE FAILS IF DEFINITION CONTAINS PRIMARY KEY COLUMN PROFILE ONLY |
| 34104268 | CALLING APEX_REGION.OPEN_QUERY_CONTEXT FOR INTERACT. GRID ON OTHER PAGE LEADS TO WRONG META DATA LOADED |
| 34104741 | APEX$USE_NO_GROUPING_SETS "PSEUDO HINT" IS NOT CONTAINED IN PAGE DESIGNER HELP TEXT |
| 34110990 | IT IS NOT POSSIBLE TO CREATE A THEME FROM SCRATCH USING THE WIZARD |
| 34115954 | DATA LOAD DOES NOT LOAD THE COLUMN IF PROFILE COLUMN NAME CONTAINS HYPHEN |
| 34120638 | NUMBER FIELD WITH FORMAT MASK AND NUMBER WITH LARGE NUMBER OF DECIMAL PLACES GIVES ERROR |
| 34131726 | CANNOT ADD DATA COLUMN FROM DATA PROFILE COLUMNS GRID |
| 34155212 | APEX_AUTOMATION.EXECUTE LACKS P_RUN_IN_BACKGROUND PARAMETER |
| 34155996 | PASS SAMPLE RESPONSE TO REST DATASOURCE PLUGIN FOR DISCOVERY |
| 34170409 | MULTI_VALUE FACETS: JSON_EXISTS FUNCTION SHOULD USE BIND VARIABLES |
| 34179761 | CANNOT SET GALLERY_FILE_URLS PARAMETER USING PL/SQL API WITH NEW LINE |
| 34180759 | QUERY BUILDER NOT RETURNING SQL QUERY |
| 34185197 | PREVENT PROVISONING OF WORKSPACE NAMES WITH NAMES CONTAINING URLS |
| 34189472 | COMBOBOX - SEARCH TERM IS NOT SUBMITTED ON FIELD CLICKED |
| 34190686 | DUPLICATED COLUMN EXPORTING TO EXCEL FROM APEX APPLICATION |
| 34191555 | QUICK SQL: CREATE VIEW WHERE CLAUSE DOESN'T ALWAYS RESPECT MANUAL PK |
| 34194772 | JET CHART: PIE CHART 'DISPLAY AS' ATTRIBUTE SHOULD PROVIDE 'LABEL - PERCENTAGE' OPTION |
| 34201197 | MAX_WEBSERVICE_REQUESTS RESET TO DEFAULT UPON UPGRADE |
| 34208220 | REGRESSION: "ORDER BY" PROPERTY ON FORM REGION NO LONGER DISPLAYS |
| 34213875 | OPEN_QUERY_CONTEXT() IGNORES APPLIED REGION FILTERS IF USED FROM DIFFERENT PAGE |
| 34224098 | PAGE DESIGNER PAGE SEARCH DOES NOT PERSIST WHEN MOVING ACROSS PAGES |
| 34230448 | APEX_DATA_PARSER DOES NOT SUPPORT MAX_STRING_SIZE=EXTENDED |
| 34231006 | SAML AUTH: ERROR IN WWV_FLOW_ASN1 PACKAGE WHEN PARSING CERTIFICATE WITH SPACES |
| 34245972 | DOWNLOAD IR TO EXCEL FAIL WHEN APPLICATION LANGUAGE SET TO HEBREW AND NUMERIC FO |
| 34248854 | NEW SERVICE SIGNUP WIZARD DOES NOT RESPECT SSO USERNAME |
| 34256371 | DATA GENERATOR: COLUMN NOT SAVED ON BLUEPRINT DATA SOURCE TYPE |
| 34257937 | SAML AUTH: ERROR REGISTERING CERTIFICATE WITHOUT VERSION IDENTIFIER |
| 34259635 | JQUERYUI DIALOG CLOSE BUTTON'S FOCUS STYLE IS TOO WIDE IN FIREFOX |
| 34261389 | DATA GENERATOR: CUSTOM DATA SOURCES DO NOT LOAD TABLES OR EXECUTE QUERIES |
| 34264934 | ASSOC ARRAY SHAPE NOT CONSISTENT W/ SESSION PARAMETERS USING APEX_PAGE.GET_URL() W/ LINGUISTIC BINARY_AI NLS |
| 34272782 | APPROVAL COMPONENT - ACCESSIBILITY - UNIFIED TASK LIST IS USING MIDDOT CHARACTER WITHOUT PROVIDING A SEPARATOR ROLE |
| 34297638 | SUPPORT "OBJECT STORE" PAGINATION STYLE "NEXTSTARTWITH" IN "OCI" REST SOURCE TYPE |
| 34300897 | GENERATE REQUEST BODY TEMPLATE CAN USE INCORRECT PROPERTY NAMES |
| 34307623 | CREATE SAMPLE DATASETS DOES NOT WORK IF SCHEMA NAME HAS SPECIAL CHARACTERS LIKE / OR & |
| 34318575 | INTERACTIVE GRID SETTINGS NEED ACCESSIBILITY IMPROVEMENTS |
| 34322254 | PAGE DESIGNER DOES NOT USE COMBINED JAVASCRIPT FILE |
| 34323267 | COPY AUTOMATION RAISES ORA-54013: INSERT OPERATION DISALLOWED ION VIRTUAL COLUMN |
| 34333105 | DIALOG PAGE > NOT-CHAINED > 2ND PAGE LOSES KEYBOARD FOCUS IN FIREFOX |
| 34333480 | APEX.DATE FORMAT & PARSE FUNCTION LOG TOO MUCH INFORMATION TO BROWSER CONSOLE |
| 34334231 | PAGE DESIGNER DOES NOT DETECT IDENTITY COLUMNS FOR A TABLE DATA SOURCE |
| 34346694 | EDIT AUTOMATION: PRIMARY KEY COLUMN ATTRIBUTE ALWAYS CLEARS WHENEVER DATA SOURCE SETTINGS ARE CHANGED |
| 34348144 | DML PROCESSING RAISES "CHARACTER STRING BUFFER TOO SMALL" ERROR WHEN GENERATING CHECKSUM QUERY FOR VERY LARGE SOURCE QUERY |
| 34358291 | NAVIGATION MENU FLICKERS WHEN EXPANDED BY DEFAULT OR IN ICON COLLAPSE MODE |
| 34368236 | REST SOURCE PLUG-IN DISCOVERY FUNCTION CAN ONLY SET EMPTY PLUG-IN ATTRIBUTE VALUES |
| 34371634 | APEX_DATA_PARSER: P_STORE_PROFILE_TO_COLLECTION IS IGNORED WHEN REPORT STOPS FETCHING EARLY |
| 34371688 | REGION DISPLAY SELECTOR CAUSES REGIONS TO FLICKER ON PAGE LOAD UNTIL JS INITIALIZES |
| 34379915 | EMAIL TEMPLATES ARE NOT COPIED WHEN REFERENCING AUTOMATION OR PAGE PROCESS IS COPIED TO OTHER APP |
| 34401404 | USING FACETED SEARCH WITH MAP COMPONENT RAISES RUNTIME ERROR WHEN NO QUERY AT REGION LEVEL |
| 34418790 | INTERACTIVE GRID SELECTION AFTER SAVE INCORRECT IN SOME CASES |
| 34425530 | APPLICATION "4000" PAGE "1207" NOT FOUND WHEN CREATING A THEME FROM THE REPOSITORY |
| 34429821 | COPY SHARED COMPONENT CODE: IMPROVE COPY REST SOURCE PARAMETERS LOGIC |
| 34447119 | GETTING ERRORS WHEN TEMPLATE NAME ALREADY EXISTS FOR THE THEME |
| 34457484 | CREATING REST SOURCES FROM REST CATALOG GENERATES INVALID WEB CREDENTIAL |
| 34460675 | NON-ENGLISH BUILDER SESSION THROWS ORA-2047 FOR PAGES USING DBLINK WHEN RENDERING DEVELOPER TOOLBAR |
| 34470960 | PAGE DESIGNER TREE NODE LOSES SERVER SIDE CONDITION STYLING WHEN MOVED |
| 34471057 | EMBEDDED CODE UTILITY FAILS W/ ORA-6502 FOR REPORT QUERY OVER 1000 CHARS |
| 34475959 | PAGE LOAD API APEX.PWA.CLEANUP IS INVASIVE TO CUSTOM SERVICE WORKERS |
| 34485827 | MASTER DETAIL INTERACTIVE GRID - LAZY LOAD - RESET REGION NOT WORKING |
| 34510738 | INTERACTIVE GRID MASTER DETAIL DOES NOT REFRESH DETAIL WHEN MASTER REPORT CHANGES |
| 34518378 | COPY PAGE DOESN'T COPY HUMAN TASK PROCESSES PARAMETERS |
| 34529179 | APEX COMPONENTS (CARD REGION, INTERACTIVE REPORT, DISPLAY IMAGE ITEM) DO NOT LAZY LOAD IMAGES LEADING TO PERFORMANCE ISSUES |
| 34533953 | PAGE DESIGNER: COLUMN QUICK PICK IN HTML EXPRESSIONS SHOULD APPEND AND NOT REPLACE |
| 34534485 | APPLICATION EXPORT FAILS WHEN USING SWITZERLAND NLS TERRITORY SETTING |
| 34538449 | SERVICE WORKER ITEM-LEVEL HELP TEXT TOO LONG |
| 34542636 | ROW HIGHLIGHTS MISSING IN INTERACTIVE REPORT DOWNLOADS WHEN COLUMN IS EXCLUDED |
| 34549822 | UNABLE TO REFRESH THEME FROM SHARED COMPONENT PAGE |
| 34554254 | EDIT LOV ON REST SOURCE: ENABLING POST PROCESSING POPULATES QUERY, BUT COLUMN SELECT LISTS ARE EMPTY |
| 34560184 | APEX UPGRADE RUNS INTO DBA_REGISTRY FK ERROR (SYS.REGISTRY_PROGRESS_FK) |
| 34560360 | PWA MANIFEST UNABLE TO LOAD DUE TO CORS 401 UNAUTHORIZED RESOURCES |
| 34569916 | INTERACTIVE REPORT CHART ON PAGINATED REST SOURCE DOES NOT CORRECTLY FETCH ALL ROWS |
| 34570863 | JET CHARTS DO NOT RESPECT EXTERNAL FILTER AND ORDER BY FOR REST SOURCES |
| 34571670 | CARDS REGION ONLY SUPPORTS ONE FULL CARD ACTION |
| 34575387 | PAGE DESIGNER: JS ERROR WHEN OPENING CONDITION ITEM LOV IN PROPERTY EDITOR FOR CARDS ACTIONS |
| 34594066 | XLSX EXPORT: ERROR WHEN TABLE NAME STARTS WITH A NUMBER |
| 34594885 | REST SOURCE DISCOVERY DOES NOT PASS "SCOPE" ARGUMENT WHEN USING EXISTING WEB CREDENTIAL |
| 34597724 | XLSX EXPORT: ERROR WHEN DUPLICATE COLUMN HEADINGS ARE USED |
| 34633052 | TEST REST ENABLED SQL THROWS ERRORS IN CHINESE ENVIRONMENTS |