1 What's New in Release 2.4.0
Here’s an overview of new features and enhancements added to Oracle Visual Builder Add-in for Excel in Release 2.4.0. Take note also of some limitations when using the add-in.
New and Changed Features
- Display two or more columns from the immediate parent layout in a child Table layout for multi-level business object hierarchies. Including parent columns allows users to specify the appropriate parent item when creating a child item. See Use Multiple Layouts for Multi-level Business Objects.
- Add descriptive flexfields (DFF) to your layout's forms and tables. DFFs expand to display additional fields, including context-sensitive fields, for tracking supplemental information. These fields are supported in REST services using Oracle ADF Business Components. See Add Descriptive Flexfields to a Layout.
- An enhancement to the way the add-in handles TLS security protocols during the HTPS handshake. In 2.4, the add-in uses the system default for TLS in accordance with Microsoft guidelines. See TLS Security.
- Configurable options to publish a workbook, enabling you to now choose whether you want to disable the designer tools, clear all layouts, enable worksheet protection, and so on. See Publish an Integrated Excel Workbook.
- Process custom actions, along with other types of changes, in batches. See Batch Mode for Custom Actions.
- Refresh a business object catalog after a workbook is integrated with a service. See Refresh a Business Object Catalog.
- Control the REST-Framework-Version header value for Oracle business object REST API services. See Configure the REST-Framework-Version.
- Define a list of values for a custom action's payload field. See Configure a List of Values for a Custom Action Field.
- Add, remove, and update a business object's available row finders for Oracle business object REST API services that support row finders. See Configure Row Finders for a Business Object.
- Change how a business object field's 'required' property is determined and introduce two new properties (Required for update and Required for create) to distinctly manage the values for an update and a create. See 'Required' Fields.
- Delete the parent form row in a Form-over-Table layout. See Delete a Form Row in a Form-over-Table Layout in Managing Data Using the Oracle Visual Builder Add-in for Excel.
- Display event details and verbose output in the Log Console. See Logging Console.
Known Limitations
- Review REST Service Support to understand the limitations around data type support.
- Review Use Lists of Values in an Excel Workbook to understand limitations around using lists of values.
- Review Custom Actions to understand custom action support.
- Workbooks created or modified with version 2.3 are generally considered to be incompatible with prior versions of the add-in.