Oracle APEX

Known Issues - Oracle APEX 18.1 and Above 
Addendum

This page was last updated on September 28, 2018.

Changed Behavior:

  • FLASH CHARTS AND GANTT CHARTS NO LONGER DISPLAY
    Starting with Oracle Application Express 5.1.4, and continuing with later releases, the AnyChart and AnyGantt Flash .swf files have been removed from the APEX 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.

    To determine if this issue may affect one or more of your applications you need to find any Gantts, maps or Flash-based charts currently being utilized. To find candidate pages which may have issues you should perform the following:
    • A. Use Application Upgrade utility to find and potentially upgrade AnyChart charts within each application
    • B. Find AnyGantts installed within any of your applications
    • C. Find AnyChart Maps installed within any of your applications
    • D. Find Flash-based AnyCharts installed within any of your applications
    • E. Test pages found across your applications

    A. Use Application Upgrade Utility

    If you are upgrading from Application Express 5.1.x and have not yet upgraded to Oracle APEX 18.1 or above, or you have already upgraded, then the easiest way to identify and upgrade the pages which contain the legacy AnyCharts is to use the Upgrade Application utility.
       {Note: The Application Upgrade utility will not identify AnyChart Maps and Gantts}
    Perform the following:
    • 1. Log into your development environment
    • 2. Navigate to the App Builder
    • 3. For each application -
      • a. Select the application
      • b. Click Utilities
      • c. Click Upgrade Application
      • d. Inspect the list of Upgrade Types.
           If Upgrade AnyChart Charts to Oracle JET Charts or Upgrade Flash Charts to HTML5 Charts
           is displayed then review the pages listed.
           Wherever possible upgrade the charts to Oracle JET.

    B. Find AnyGantts installed within any of your applications

    To identify pages that have AnyGantt charts within your applications run the following SQL statement in SQL Commands:

    select application_id,
       application_name,
       page_id,
       region_name,
       region_id
    from apex_application_page_flash5
    where chart_type in ('Project Gantt','Resource Gantt')

    If any pages found proceed to E. Test pages found across your applications

    C. Find AnyChart Maps installed within any of your applications

    To identify pages that have AnyChart Map charts within your applications run the following SQL statement in SQL Commands:

    select application_id,
       application_name,
       page_id,
       region_name,
       region_id
    from apex_application_page_flash5
    where chart_type = 'Map'

    If any pages found proceed to E. Test pages found across your applications

    D. Find Flash-based AnyCharts installed within any of your applications

    To identify pages that have AnyChart Flash charts in use in your applications, which are not of type map or Gantt, run the following SQL statement in SQL Commands:

    select application_id,
       application_name,
       page_id,
       region_name,
       region_id
    from apex_application_page_flash5
    where chart_rendering = 'Flash Chart'
    and chart_type not in ('Map','Project Gantt','Resource Gantt')

    E. Test pages found across your applications

    If steps B, C, or D identified any pages that are utilizing AnyCharts components then you should perform one of the following options:
    • 1. 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.
    • 2. Convert Flash-based AnyChart charts to Oracle JET
         - Oracle recommends you upgrade legacy AnyChart charts to Oracle JET charts as soon as possible