SAP Knowledge Base Article - Public

2504781 - SF User Connector not passing blank value for a field in LMS

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

  1. Remove Middle Name from a user account in Employee Central (BizX).
  2. Employee Export job setup picks up blank value for MI column for that user
  3. 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