1 What's New in Release 4.5.0

Here’s an overview of new features and enhancements added to Oracle Visual Builder Add-in for Excel in Release 4.5.0.

New and Changed Features

Area Feature
Custom Actions Ability to perform collection-level custom actions in bulk. See Create an Action Table Layout.
Lists of Values Option to select a single value automatically for create rows. See Configure a List of Values with a Business Object.
Lists of Values Ability to filter local LOVs when selecting a value. See Configure a List of Values with a Local Data Source.
Lists of Values Ability to sort the items in a local data source in the designer. See Create a Local Data Source for a List of Values.
Authentication Support for user-provided bearer tokens. See User-Provided Bearer Token Authentication.
New Layout Setup Ability choose an option to determine the initial set of fields in the new layouts. See Choose a Set of Fields for a Layout.
Service Metadata The add-in now harvests tool tips (x-hints.help.instruction) from ADF REST catalogs to populate Help Text properties.
Service Metadata The add-in now harvests descriptions for row finders and row finder variables.
REST Frameworks Added support for OTM-GTM catalogs. Also, for OTM-GTM catalogs, the visual search editor is enabled. See Oracle Transportation and Global Trade Management Business Object Resources.
Dependent Layouts Create Child Rows now works with a filtered table or a non-contiguous selection of parent rows.
Diagnostics The current catalog host is now displayed at the bottom of the status viewer.
Diagnostics Ability to export a workbook's metadata in JSON format. See Export Workbook Metadata.

Fixed Issues in Release 4.5

These issues in prior releases have been fixed in version 4.5:

  • Able to delete a subfield that is used in a layout (VBAFE-2298)
  • Pending changes warning on Download for uninitialized dependent layouts with column grouping enabled (VBAFE-2471)
  • Status viewer shows update statistics after upload in create-only table (VBAFE-2417)
  • Circular references in service metadata not identified correctly in all cases (VBAFE-2447)
  • Create Child Rows: Finish button is enabled with an invalid row count (VBAFE-2390)
  • Able to delete a custom action payload field that is used in a layout (VBAFE-2426)
  • Default Value is set in read-only FOT form field (VBAFE-2395)
  • Send Only Changed Data can be enabled when Update Enabled is unchecked (VBAFE-2380)
  • Null value sent during update for unchanged DLOV discriminator field in form (VBAFE-2394)
  • DFF fields were marked erroneously as editable in certain situations (VBAFE-2422)
  • Column Manager: custom action payload fields are added in reverse order (VBAFE-2423)
  • Custom action payload field columns cannot be altered when a default value is configured (VBAFE-2442)
  • Next/Previous Issue sometimes displays "No issues found" erroneously instead for navigating to the next/previous issue (VBAFE-2523)
  • Form-over-Table layout: form fields configured with default values cause an unexpected exception when creating a new form row in a published workbook with worksheet protection (VBAFE-2524)
  • Form-over-Table Deleted child table row not removed after upload (VBAFE-2557)