Improvements to Enhanced Workbench

This feature provides a set of new capabilities and features for the Enhanced Workbench. Improvements have been provided in several areas, including:

  • Personalization:
    • Table Parameter Settings
    • Sort Order in Tables
    • Layout Display
  • Table -  Freeze/Unfreeze Columns
  • Dock Scheduling Gantt - Action Checks
  • Force Assign Actions on Enhanced Workbench
  • Legacy Workbench end-of-life changes
    • Action Parameters - Selection of  Legacy Workbenches for Action Parameter settings removed
    • Workbench Manager - Legacy View Enabled Action Removed
    • Menu edit no longer allows Legacy Workbenches

Personalization

This feature extends the previously delivered personalization capabilities to include personalization for Table Parameters, Sort Order and Layout Display.  As with all Workbench Table Personalization changes, the changes will remain until the browser cache is refreshed, or the Workbench Layout is modified or until the tables related screen set is modified.

Personalized Table Parameter Settings.

To start, the Enhanced Workbench table is setup with the Table Parameter Settings below.

Original workbench table parameter settings

Original Workbench Table Parameter Settings

Below, the Table Parameter Settings have been personalized.

Personalized table parameter settings

Personalized Table Parameter Settings

The table view, using the personalized Table Parameter Settings, even with logging out and logging back into the application are shown below, i.e., the personalized Table Parameter Settings are retained.

Personalized table parameter view

Personalized Table Parameter View

Personalized Sort Order.

In the example below the Sort Order personalization is shown - in this case the Dest field sort order is reversed.

Personalized table sort order original view

Personalized Table Sort Order Original View

For the Personalized view, the table is sorted by the Dest field as shown below.

Personalized table sorted table view

Personalized Table Sorted Table View

Table view, using personalized Table Parameter settings, after logging out and logging back into the application.

Personalized table sort order after logging out and logging back in

Personalized Table Sort Order After Logging Out and Logging Back In

Personalization Layout Display.

In the example below the Layout Display/Layout Format personalization is shown.  In this example the Layout Format will switch from the Default to Super Compact.

Below is the Layout Display and Layout Format for the original table configuration.

Personalized table layout display and layout format set to default

Personalized Table Layout Display and Layout Format Set to Default

The Layout Format - for this user - is personalized to Super Compact as shown below.

Personalized table layout display and layout format set to super compact

Personalized Table Layout Display and Layout Format Set to Super Compact

Once the Layout Format is Personalized for this user  - set to Super Compact - when this user opens the Enhanced Workbench, their selected Layout Format of Super Compact will be used.

Personalized table layout format super compact

Personalized Table Layout Format Super Compact

Table -  Freeze/Unfreeze Columns

This feature provides the ability to freeze and unfreeze the scrolling within a table based on a selected column.  All columns to the left of the selected frozen column will remain fixed, while columns to the right of the frozen column will scroll.  This will allow you to keep your important data columns visible while scrolling across the data in your tables.  Using the available personalization features, you can easily reorganize columns so they are to the left of the frozen column - and remain fixed, or you can move them to the scrolling portion of the table.

In the example below, all of the columns to the Left of the selected Carrier column will be frozen when the Freeze action is selected.

Table view freeze/unfreeze action

Table View Freeze/Unfreeze Action

Once the columns are frozen, all columns to the left of the Carrier column are frozen, while all the columns to right of the frozen column are scrollable.

Freeze column example - columns to the left frozen, columns to the right scroll

Freeze Column Example - Columns to the Left Frozen, Columns to the Right Scroll

To unfreeze the columns you only need to select the Unfreeze action from the View menu - as shown below.

Unfreeze view action

Unfreeze View Action

After the Unfreeze is initiated the table will refresh to reflect the unfrozen column view as shown below.

Unfrozen view

Unfrozen View

Navigation Menu Improvements

Dock Scheduling Gantt Action Checks

This feature continues the enhancements provided in previous updates related to Action Checks and the Dock Scheduling Gantt.

For Adjust Appointment Time introduced action check DOCK - ADJUST APPOINTMENT TIME which has been provided for the LOCATION RESOURCE data query type.  Can be used to check the location resource used to schedule an appointment, in the case you select the incorrect resource the action check error, as shown below, will be displayed.

Select resource that fails action check

Select Resource That Fails Action Check

Action check error message

Action Check Error Message

An action check has also been added for Schedule Appointment - Show Options.  The action check  will be checked in the case where you have the option to View Group Resources and you schedule on a resource of your choice or when you select Save the appointment and the appointment is to be scheduled on a feasible resource for that group. In either of these cases, if the action check fails on the resource selected the action check will be shown.

Action check for selected resource in group or save and select resource in group options

Action Check for Selected Resource in Group or Save and Select Resource in Group Options

An action check has been added for DOCK - REMOVE APPOINTMENT and if for the APPOINTMENT data query type.

Limitations: Find Next Available Appointment, Find Previous Available Appointment, Recompute appointment, still could be scheduled on a door which has the action check

Force Assign Actions on Enhanced Workbench

This feature continues the addition of Force Assign actions for the Enhanced Workbench.   For this update Force Assign Actions have been implemented for Remove Shipment from Work Assignment and Unassign Driver from Shipment on the driver Gantt.

Legacy Workbench End-Of-Life Changes

This feature provides a number of changes to finalize the removal of the Legacy Workbenches.  At this point all your Workbenches should be either newly created Enhanced Workbenches or Legacy Workbenches that have been converted to Enhanced Workbenches using the Enhanced View Enabled action available in the Workbench Manager.  Please check to make sure that all of your Legacy Workbenches have been converted.  Navigate to Configuration and Administration > User Configuration > Workbench Manager and query for Legacy = Yes and then select and run the Enhanced View Enabled Action.

Workbench manager search for legacy - yes

Workbench Manager Search for Legacy - Yes

Select the set of returned Legacy Workbenches  - as shown below and run the Enhanced View Enabled action.

Select all legacy workbench results run action enhanced view enabled

Select All Legacy Workbench Results Run Action Enhanced View Enabled

NOTE: You must be logged in as DBA.ADMIN or the domain.ADMIN to access this page. The Workbench Manager and Enhanced Workbench menus are only available on the  DBA_ADMIN_MENU and ADMIN_MENU public menus. If any of your Legacy Workbenches do not convert, delete them - and recreate them using the Enhanced Workbench.

Changes provided related to the removal of the Legacy Workbenches.

Action Parameters - Selection of  Legacy Workbenches for Action Parameter Settings Removed

This feature removes the option of selecting Legacy Workbenches for the Workbenches opened with the configured the Action Parameters.  Note, the Public Workbenches related to the Actions by default have been upgraded to the Enhanced Workbench.  If you have configured the Action settings previously - with a Legacy Workbench, you will want to change the related parameter setting so that the Action now uses an Enhanced Workbench.  This change eliminates the option of configuring the Action parameter with a Legacy Workbench.

Actions and default configuration

Actions and Default Configuration

When you go to find and select a new Parameter Value - as shown below, the Finder and related Finder Results no longer allows you to select a Legacy Workbench.

Finder no search option for legacy

Finder No Search Option for Legacy

As expected, the Finder Results are all Enhanced Workbenches - not Legacy - as shown below.

Action parameter finder result - all enhanced workbenches

Action Parameter Finder Result - All Enhanced Workbenches

Workbench Manager - Legacy View Enabled Action Removed

This feature also removes the option in the Workbench Manager to run the Legacy View Enabled action on an Enhanced Workbench where the Enhanced View Enabled action had be run previously.  The only action available is to run the Enhanced View Enabled action.

Workbench manager - only supports enhanced view enabled action

Workbench Manager - Only Supports Enhanced View Enabled Action

Menu Edit no longer allows Legacy Workbench Selection

The option to select a Legacy Workbench and add it to your Menu has been removed, only Enhanced Workbenches are available to be added to the Menu.  In the example below the Menu is being edited  - the option to add a link to another Workbench is not limited to only Enhanced Workbenches.

Edit menu entry for workbench link

Edit Menu Entry for Workbench Link

The Finder only provides Enhanced Workbench options for the Menu link as shown below.

Menu option for workbenches limited to enhanced workbenches

Menu Option for Workbenches Limited to Enhanced Workbenches

This feature provides additional features and usability improvements for the Enhanced Workbench - giving you more options for implementing Enhanced Workbenches to support more use cases and users.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Personalization of Layout display is browser specific that is changes made for a layout in one browser cannot be personalized to another browser.

NOTE:  The legacy Workbench developed using Oracle Application Development Framework - ADF, has been deprecated and the supporting code for the ADF based Workbenches is being removed from the application.  If you have not done so already - you should move to the new Enhanced Workbenches as soon as possible to avoid any issues. 

The Enhanced Workbench relies on REST calls to access data, due to the current security infrastructure, the following additional setup is required.

  • For users with any role other than ADMIN and DEFAULT the following Access Controls are necessary and can be added to the User Role or directly to the User:
    • REST – Workbench
    • Workbench – Create
      • This is required only for Add/Delete
      • Can also revoke the ability to Add/Delete