SAP Knowledge Base Article - Public

2088656 - Legacy Picklists: What are the character limitations on a picklist?

Symptom

Is there a character limitation on Legacy Picklist? 

Environment

SAP SuccessFactors HCM Suite

Resolution

For Picklist ID:

  • The character limitation will be the one specified on the field definition (max-length=XXX). This specification can be found on the data model.

For Picklist Label:

  • The character limitation for picklist label is by default set to a max of 255 characters. This is hard-coded into the system and cannot be changed.
    NOTE: If the picklist label exceeds the max 255 bytes, then you will receive the following error when updating the picklist: ORA-12899: value too large for column error.

Keywords

ORA-12899: value too large for column error, legacy picklist, size limitation, character limitation, picklist id character, picklist label character , KBA , sf picklist , LOD-SF-PLT-PCK , Picklist Management Issue , How To

Product

SAP SuccessFactors HXM Suite all versions