1 What's New in Release 4.7.0

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

New and Changed Features

Table 1-1 New and Changed Features

Area Feature Reference
List of Values Default value for fields with LOV Default Values for Business Object Fields
List of Values Ability to clear the selected choice in the search windows

Clear Cache for a List of Values

List of Values Enhanced List of Values designer

About Lists of Values

List of Values "Select Single Value Automatically for Create" check box moved to menu

Configure a List of Values with a Business Object

Form-over-Table Ability to navigate to form issues (upload and data entry) from the status viewer

Configure a List of Values with a Business Object

Form-over-Table Next / Previous Issue now includes issues in the form region

Form-over-Table Download

Descriptive Flexfields FND_ACFF_IsRequired x-hint is now used to help determine required-ness for polymorphic segments

Required Fields

Polymorphic Fields Added publish option that deletes all global and context-sensitive polymorphic segments from the workbook

About Polymorphic Business Objects

Row Finders Cached finder variable values are now cleared when the finder definition is altered

Use a Workbook Parameter Value for a Row Finder Variable

Data Entry Ability to resize the current layout to fit the current data

Table Download

Fixed Issues in Release 4.7

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

  • Form issues lost on save-close-reopen (VBAFE-405)
  • Validation for LOV missing in search and other windows (VBAFE-976)
  • Designer tab names getting clipped (VBAFE-1560)
  • Focus rectangle clipped in network monitor (VBAFE-2222)
  • Inactive context-sensitive fields marked as required during create (VBAFE-2297)
  • Empty elements taking up space in the status viewer (VBAFE-2551)
  • Go to Next Issue gives "No Issues Found" when issue exists (VBAFE-2575)
  • Deleting a layout does not delete all hidden sheets associated with that layout (VBAFE-2606)
  • LOV editor: checkbox labels clipped (VBAFE-2614)
  • Polymorphic field Data Type change not immediately reflected in overview table (VBAFE-2648)
  • LOV driven field fails with data type error if unhid (VBAFE-2649)
  • Form not made read-only when marked as stale (VBAFE-2657)
  • Excel crashes when activating worksheet with Form-over-Table in create mode (VBAFE-2659)
  • Publish: Clear authentication properties does not clear static ScopesFQ value (VBAFE-2661)
  • Diagnostic report shows Windows 10.x for Windows 11 (VBAFE-2666)
  • Publish does not clear FOT data cache (VBAFE-2672)
  • Extracted translatable strings for Action Table contain unneeded custom actions (VBAFE-2676)
  • Deleted layout worksheets leave behind layout artifacts (VBAFE-2677)
  • FA token Relay ScopesFQ value picked up incorrectly with hardcoded pod name (VBAFE-2678)
  • Failed row status custom action invocation interferes with list of values, data entry validation popups (VBAFE-2679)
  • Field validation rule evaluated before default value is applied (VBAFE-2681)
  • Hyperlink appears in status viewer for Form-over-Table row status custom action, but does not work (VBAFE-2689)