Symptom
- SF user connector is not passing blank value for MI column in LMS.
- We have changed the Middle Name of a user in EC and the connector input file also contain null value for MI column, however LMS does not update middle name for the user to blank.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Remove Middle Name from a user account in Employee Central (BizX).
- Employee Export job setup picks up blank value for MI column for that user
- SF user connector runs successfully however, MI value is not updated to NULL in LMS
Cause
Blank values are not automatically updated to NULL in LMS through connectors
Resolution
1. Map the update on null property to MI column
sfuser.connector.updateOnNull=MI
- This will nullify Middle Name for all the user records that are present in the connector input file.
2. If the requirement is only for few specific users then the above property will not help. In that case:
- Map the update on null property to MI column for "User connector" - user.connector.updateOnNull=MI
- Create user connector input file and add only those users in the file for which you would like to update the MI field to NULL
- Place the file on SFTP server
- Run User Connector
Keywords
SF user connector, User connetor, Blank value not updating, nullify field in LMS , KBA , LOD-SF-LMS-CON , Connectors , Problem
Product
SAP SuccessFactors Learning all versions