1. Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  2. What's New in Release 2.7.0

2 What's New in Release 2.7.0

Here’s an overview of new features and enhancements added to Oracle Visual Builder Add-in for Excel in Release 2.7.0. Take note also of some limitations when using the add-in.

New and Changed Features

  • Support for including table layouts for second-level "siblings" in a set of dependent layouts with a Form-over-Table primary layout. When creating a set of dependent layouts for a multi-level hierarchy of business objects, you can now link a separate table layout based on a second-level business object to a top-level Form-over-Table layout. See Use Multiple Layouts for Multi-level Business Objects.
  • A new MSI-based installer (vbafe-installer-current-user.msi) for Current-User installs that replaces the existing EXE-based installer. To upgrade using this new installer, simply download and install the new one. See Install Using the Current User Installer.
  • Support for "upsert" mode on pending create rows. Oracle business object REST API services may support an optional updating or creating ("upsert") mode that you can use when uploading changes to your REST service. See Upload Changes Using Upsert Mode.
  • Support for showing REST warning messages in addition to error messages in the Status Viewer. Oracle business object REST API services support the inclusion of warning messages in the response payload to a REST request. The add-in captures warnings for updates, creates, and custom actions and displays them in the Status Viewer. See Upload Changes.
  • Support for displaying the response to a custom action. After Upload (for table rows) or Perform Action (for the form row), the add-in captures the result, if any, from the response payload and displays it in the Status Viewer. See Upload Changes for Custom Actions.
  • Support for configuring the bind parameters for a descriptive flexfield (DFF) list of values. The add-in currently only supports configuring the polymorphic bind parameters. Other details of the list of values for DFFs must come from the metadata and are not configurable. Configure bind parameters using the Business Object Field Editor. See Configure the Bind Parameters for a Descriptive Flexfield's List of Values.
  • Support for omitting fields with empty values during upload. Request payloads for Create and Update operations normally includes a value for every column in the table (except those for read-only fields and custom action payload fields) even if the value is empty or null. You can now configure the add-in to omit null values from the payload. See Omit Empty Values During Upload.
  • Support for creating a list of values that displays multiple columns in the search-and-select window. For example, you might want to create a list of values for a "manager" column that displays both first and last names. When a user selects a cell in this column, the search-and-select window shows first and last names in separate columns. See Configure a List of Values with Multiple Display Fields.
  • Support for adding tooltips to custom action fields. See Edit Custom Actions.

Known Limitations