Override migration

There are two possible ways to store override values in the database. An upgraded design was introduced in the 2023.10 release. To maintain backward compatibility, the original legacy design is also still supported.

Note: The upgraded design also includes a new Override Builder that you can use to create your own override types.

See Adding an override type.

In an on-premises environment, you could previously create your own override types by creating custom JSP pages. If you previously created custom JSP pages, you should evaluate whether it would be better to keep the existing JSP pages or use the new Override Builder.

For legacy overrides, denormalized override values are stored in the OVR_NEW_VALUE column in the OVERRIDE table. For upgraded overrides, normalized override values are stored separately in the OVERRIDE_VALUE table, with foreign key links to the overrides in the OVERRIDE table.

To select the option for your environment, use this registry parameter:

system/WORKBRAIN_PARAMETERS/LEGACY_OVERRIDE_VALUE

See the Infor Workforce Management Registry Parameter Reference Guide for more information.

The default value of the LEGACY_OVERRIDE_VALUE parameter is False for new implementations of Workforce Management, meaning the upgraded overrides are used. You must set the value to True to enable legacy overrides. To maintain backward compatibility, the default is True when upgrading an existing site to 2023.10.

You can also convert existing overrides in the database, either form the legacy format to the upgraded format or from the upgraded format to the legacy format. To convert overrides, use the Override Value Convert Task in the Job Scheduler.

See Scheduling the Override Value Convert Task.

Note: The Override Value Convert Task converts overrides between the legacy format and the upgraded format. If you have created your own override types, you can also use the Data Migration Tool to migrate them to a new environment without converting them by migrating the OVERRIDE_TYPE table.

See "Data Migration" in the Infor Workforce Management Application Configuration Guide.