Oracle APEX

Known Issues - APEX 18.2.0

APEX 18.2.0 was released on September 28, 2018.

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 October 31, 2018.

Note: Review the APEX 18.1 and above Known Issues Addendum for important information regarding flash charts.

  • 28776956 - AUTOMATIC ROW FETCH/TABFORM PROCESS - ROWID IS NOT IN LIST
    Page Designer doesn’t show ROWID as a valid column name in the list of available columns for the ‘Primary Key Column’ attribute of the following processes:
    • Automatic Row Fetch
    • Automatic Row Processing (DML)
    • Tabular Form - Multi Row Update [Legacy]
    • Tabular Form - Multi Row Delete [Legacy]
    This prevents a developer from using ROWID as a primary key for inserting, updating and deleting from a table or view.
    Solution: A PSE has been made available for this issue on MyOracleSupport.
    Navigate to Patches & Updates and search for patch number 28727865.
    Note: this PSE also contains other bug fixes, please review the README in the patch for more details.
  • 28816707 - INITIAL QUERY NOT RESPECTING 'MAXIMUM ROWS PER PAGE' REPORT ATTRIBUTE
    For example, setting the maximum rows per page to 10 for an Interactive Report with 51 rows does not display correctly. When the page is run it shows pagination 1 - 15 of 51, instead of 1 - 10 of 51. If you then click Next, it shows pagination 1 - 10 of 51, instead of 11 - 20 of 51.
    Solution: A PSE has been made available for this issue on MyOracleSupport.
    Navigate to Patches & Updates and search for patch number 28727865.
    Note: this PSE also contains other bug fixes, please review the README in the patch for more details.
  • 25891453 - INTERACTIVE GRID WRITE PROTECTS HIDDEN COLUMN EVEN IF VALUE PROTECTED IS NO
    It is sometimes desir14able to programmatically update a hidden Interactive Grid column using a Dynamic Action or other JavaScript code. This is not possible using Dynamic Actions for a column of type Hidden, as it is write protected, even if it has the Value Protected attribute = No. As of APEX 18.2 when Value Protected = Yes the column value can be changed but only through the model API. There is no column item generated.
    Workaround: Use a column type of Text Field instead of Hidden, then use the Column configuration dialog to hide the column. However, the disadvantage is that the column is still seen by the user in the Column dialog.
    As of APEX 18.2 the partial fix allows a hidden field to be updated, but only through the model API rather than the the apex.item API or a Dynamic Action.
  • 28690621 - UNABLE TO EXPORT ORDS BASED RESTFUL WEBSERVICES FOR ANY PARTICULAR SERVICE
    When running the ORDS REST workshop against ORDS 18.3 and above, if you attempt to export a specific (single) service, an error is shown:
    ORA-06550: line 2, column 20: PLS-00306: wrong number or types of arguments in call to 'EXPORT_MODULE'
    This error does not occur when exporting ALL services, or when running against ORDS versions prior to 18.3
    Workaround: Export All Services and then edit the resulting file to extract the required service. Or use SQL Developer to export the required service.
  • 28550442 - ORDS REST WORKSHOP PARAMETERS NOT PROVIDING 'RESPONSE' TYPE
    Within Oracle APEX ORDS REST Workshop you can not specify the correct parameter types in the Handler. Using SQL Developer or PL/SQL APIs you can specify HEADER, URI (IN parameter only), or RESPONSE (OUT parameter only). Within Oracle APEX you can only specify URI or HEADER, irrespective of whether it is an IN or OUT parameter, and you can not specify a RESPONSE parameter.
    Workaround: Maintain REST services with RESPONSE type parameters using SQL Developer or PL/SQL APIs.

Changed Behavior:

  • N/A - FLASH CHARTS AND GANTT CHARTS NO LONGER DISPLAY
    Starting with Oracle Application Express 5.1.4 and continuing with Oracle APEX 18.1, the AnyChart and AnyGantt flash .swf files have been removed from the /images folder. This will result in your map chart and gantt charts no longer rendering. No error message will be displayed, instead the region will be blank.
    Solution: To install the AnyChart Flash Content in your instance, download the zip file, unzip the contents and follow the instructions outlined in the README.txt file, to update your images folder.
    Workaround: Please see the Addendum for more details.
  • N/A - JQUERY AND JQUERY UI UPGRADE
    Oracle APEX 18.1 includes jQuery 3.1.1, which breaks compatibility with earlier 2.x versions. If your application relies on removed 2.x, or 1.x jQuery functionality, then this functionality will no longer work.
    Workaround: For applications that still rely on removed 2.x functionality, you can use the jQuery Migrate plug-in. To include this plug-in, set the Desktop User Interface Details attribute Include jQuery Migrate to Yes.
    If your application relies on removed 1.x jQuery APIs, that functionality will no longer work, and you must update the JavaScript to only use jQuery 3.1 APIs.
    Review the jQuery migration guides to learn more: For further information including information about the jQuery UI upgrade, please review section 8.1.2 Known Issues for jQuery and jQuery UI in the release notes.
  • N/A - CLASSIC REPORTS: ENABLING COMPUTE SUM AND BREAK COLUMNS CAN LEAD TO SQL ORDER BY CLAUSE BEING IGNORED
    The Compute Sum functionality in classic reports does now use the SUM() OVER() analytic SQL function. If Compute Sum and Break Columns are enabled and the report query contains an ORDER BY clause, the analytic SQL function can lead the database query optimizer to ignore the ORDER BY clause.
    Workaround: Use the Sorting > Default Sequence column attribute to control report sorting.