SAP Knowledge Base Article - Public

2550347 - Can a non-referenced field (custom column) be converted to referenced field

Symptom

When an attempt is tried to update a non-referenced field (custom column) to a referenced field the following validation error is generated

custom column update.jpg

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

  1. As LMS admin, create a Custom Column for an item and make it as non-referenced
  2. Create an item and make sure that the Custom Column that you created above is populated with a value
  3. Once the item has been created try to change the Custom Column from non-referenced to referenced. You will get a validation error:

"The custom column cannot be modified to referenced because certain records already have non-referenced values that would become invalid"

Cause

  • This is expected behavior.
  • You cannot change a non-referenced field to a referenced field if there are already records related to that custom column.

Resolution

You may reach out to our Professional Services team (through your CSM) and they might help you with.

As a workaround since you would be aware of the values needed for the Custom Column, you could create another custom column that is referenced and add the references to the custom column.

Keywords

The custom column cannot be modified to referenced; certain records already have non-referenced values; would become invalid; Custom column; Non referenced custom column; Referenced Custom column , KBA , LOD-SF-LMS-ADM , Admin Tools , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Problem

Product

SAP SuccessFactors Learning all versions