Skip to Main Content

Features

Native Map Region Type

Visualize location data on a map with the new native Map Component in APEX 21.1.

  • Point, Line, Polygon, Heat Map and "3D Polygon" (Extruded Polygon) layer types.
  • Background maps from the Oracle Elocation Service. Ready to use, no API Key required.
  • Fully Interactive: Drag and Zoom, show details about objects on the map.
  • Oracle Spatial (SDO_GEOMETRY), GeoJSON and simple numeric columns.
  • Leverages Oracle Spatial (Indexes, Coordinate Transformations), if available.
  • Visualize data from local SQL queries, REST Enabled SQL or from REST Data Sources.
  • Rich set of built-in marker icons and SVG shapes.
  • Built-in color schemes for thematic visualizations.
  • Faceted Search integration.
  • Dynamic Action support and JavaScript API.

Native Markdown Support

  • New public PL/SQL API, APEX_MARKDOWN, to convert Markdown into HTML.
  • Enhanced ‘Display Only’ item type which supports Markdown. Added new ‘Format’ attribute and removed ‘Escape Special Characters’ flag.
  • Renamed ‘Markdown’ Classic Report Column Type to ‘Rich Text’.
  • New ‘Rich Text’ Interactive Report column type.
  • Markdown support added to HTML format of Data Export.
  • Changed default of Rich Text Editor, Rich Text to use Markdown as secure out-of-the-box default

Universal Theme Enhancements

  • Enhanced "Redwood Light" Theme Style which is more inline with the Redwood Design System.
  • New "Row CSS Classes" Page Designer attribute added to to Region, Page Item, and Item Buttons.
  • New "Theme Style Page CSS Classes" attribute added to Theme Styles ( see Shared Components -> Theme -> Theme Styles ).

Import Application Export as ZIP

The App Builder now supports the import of an application export which has been created as a ZIP file.

  • Applications and components exported with the Export as Zip option can be re-imported.
  • Zip exports which have been extracted on a local file system can be re-compressed and imported.
  • Folder structures created with the APEXExport utility, using the -split option, can be compressed to a Zip file and imported.

Additional Lazy Loading Support

Classic and Interactive Reports now support Lazy Loading.

  • Enabling the Lazy Loading toggle improves initial page load speed, especially for pages containing reports with long running queries.
  • Report data is not loaded until the page has been rendered, or the tab that it is on has been activated.

New Application Data Loading

New Application Data Loading functonality, which supports CSV, XLSX, XML and JSON formats.

  • Column Mapping at design time; no burden for end users any more.
  • Flexible column mappings based on simple names or regular expressions.
  • Data Conversion with Transformation Rules or Lookup Queries.
  • Super-Easy flow for end users: Just upload the file, verify the preview and load data.
  • CSV, XLSX, XML, and JSON data formats can be loaded to Tables or Collections.
  • Configure data loading to Append, Merge or Replace data, with or without Error Handling.
  • Simple new Process Type Data Loading: Customize Data Loading pages as you wish.
  • PL/SQL API APEX_DATA_LOADING available for custom processing.

Faceted Search Enhancements

Optional Facets with end user customization

  • Facet and Facet Groups now have two new Page Designer attributes under 'Advanced' called 'Display Toggling' and 'Initially Displayed'.
  • If ‘Display Toggling’ = On, End-Users can Show or Hide that facet from a new "More Facets" popup.
  • Use case: Hide some advanced and rarely used Facets out-of-the-box, but make them available on-demand.

New Date Picker Item Type

New Date Picker item type. This new modern, accessible item type is based on the Oracle JET Input Date Time, featuring.

  • Supports different display modes: JET-based Popup and Inline, and also Native HTML (no-JET, and better mobile UX)
  • All display modes support both Date, and Date and Time (time enabled through new dedicated attribute 'Show Time')
  • Includes ability to define dynamic Minimum / Maximum dates (for defining date ranges between items, eg 'From' and 'To')
  • Other new features include: Improved UX (especially around year and month selection), additional appearance options for example 'Show Week' and 'Days Outside Month', and a few other new attributes (check out the samples below)

REST Data Sources

  • Support for CSV data:
    Use Synchronization to schedule frequent loading of CSV data from the web to a local table.
  • Data conversions using Transformation Rules and Lookup Queries.
  • New Overview report on defined REST Data Synchronizations in Shared Components, REST Data Sources.

New Color Picker Item Type

This new Color Picker replaces the old one and adds new configuration options. It utilizes the Oracle JET Color Spectrum component. New functionality includes:

  • Supports different display modes: Input + Popup, Color Only (button) + Popup, Inline, and also Native HTML color input.
  • Color presets: custom or from the theme.
  • Optional contrast checking.
  • Various value return formats: Hex, rgb/rgba, hsl/hsla, or any CSS color value.

Report Printing

  • Support for Complex Text layout languages, Hebrew and Arabic, when exporting to PDF.

Developer Experience

  • Monaco-based Code Editor upgraded
    • New options for: Minimap, Show Suggestions, Show Line Numbers, Show Whitespace, Accessibility Mode (means that screen reader users no longer need to enable this every time they use APEX, which is much better).
    • References to non-existent page items will be marked as such.
    • Shortcuts for the built-in Transform Case actions Ctrl-Alt-U/L (Upper/Lower).
    • New action: Transform Code Case- Ctrl-Alt-C. Toggles between upper and lower case while not affecting ' or " enclosed strings.
  • FullCalendar upgraded
    • Lazy loading support
    • Faceted Search Integration

JavaScript Library Upgrades

  • Oracle JET 10.0.0
  • FullCalendar 5.5.1
  • CKEditor5 25.0.0
  • Monaco Editor 0.22.3

Miscellaneous

  • Interactive Grids support variable height rows by setting the 'Appearance: Fixed Row Height' property to Off.
  • The Number Field item type now does automatic formating according to the format mask and client side validation.
  • Client side validation messaging is more consistent with sever validation messaging.
  • New Create Spatial Index wizard in SQL Workshop.
  • GeoJSON and SDO_GEOMETRY support in the APEX_JSON and APEX_EXEC packages.