SAP Knowledge Base Article - Public

3686707 - Unable to change Data Type on referenced User custom fields

Symptom

When attempting to change the Data Type on referenced User custom fields, you receive a validation error:

Validation Error

You must correct the following error(s) before proceeding:

  • You can’t change the data type as the custom field x is associated with the User entity, Assignment Profiles, or both. Remove all existing references and try again.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Navigate to System Administration > Custom Fields > User
  2. Edit one of the existing referenced user custom fields
  3. Change default Data Type from "String" to for example "Decimal"
  4. Notice that the referenced values are disappearing from the screen
  5. Select Apply Changes
  6. Receive error:

    Validation Error

    You must correct the following error(s) before proceeding:

    • You can’t change the data type as the custom field 1 is associated with the User entity, Assignment Profiles, or both. Remove all existing references and try again.

Cause

Reference values are not supported for integer/decimal custom fields and the existing reference values are blocking the system from being able to save the data type change.

Resolution

For existing custom fields, we recommend removing all references of the field before attempting to change the data type.

NOTE: references can be removed from a custom field only if they are not in use on any User profile or within any Assignment Profile rule.

See Also

Support for Integer and Decimal Custom Fields for User Entity

Keywords

referenced, data type, integer, string, decimal, custom, custom field, custom column, user, validation error , KBA , LOD-SF-LMS-USR , User Entity , Problem

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Learning all versions