SAP Knowledge Base Article - Public

3003681 - User Connector Does Not Update User's Phone Numbers - LMS

Symptom

There are certain business needs where users' phone numbers need to be updated in bulk using a User Connector. However, if the number is already existing, User Connector will only update its corresponding description. If the number is not yet existing, it will add the new number and its description. User Connector cannot update the phone number itself.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Prepare the input file which would look like below:
    • STUD_ID|NOTACTIVE|PHON_NUM1|PHON_NUM1_DESC|PHON_NUM2|PHON_NUM2_DESC!##!
    • TEST_USER|N|111-222-3333|Work Phone Number|111-222-4444|Work Cell Number!##!
  2. Upload the input file to the designated SFTP server
  3. Run the User Connector

Cause

This is a standard behaviour since phone numbers should ideally be updated in platform and allow User Connector - SAP SuccessFactors to update them through the mapping and business rules that you configured.

Resolution

As a workaround, nullify the existing phone numbers and then add the desired phone numbers. This workaround only allows a maximum number of two phone numbers to be added after nullification. Below are the steps:

  1. Navigate to System Administration > Configuration > System Configuration > Connector
  2. Add the configuration user.connector.updateOnNull=PhoneNumbers
    Note: updateOnNull is a configuration used only by certified partners and by professional services team. If you wish to pursue this as self-service, please do rigorous tests on staging instance before applying anything to production.

  3. Prepare the input file which would look something like below:
    • STUD_ID|NOTACTIVE|PHON_NUM1|PHON_NUM1_DESC|PHON_NUM2|PHON_NUM2_DESC|PHON_NUM3|PHON_NUM3_DESC!##!
    • TEST_USER|N|||111-222-3333|Work Phone Number|111-222-4444|Work Cell Number!##!
      Note: The blank/null values for PHON_NUM1 and PHON_NUM1_DESC trigger the nullification of all phone numbers of a user. The PHON_NUM2 and PHON_NUM3 will then be added as the new phone numbers of the user, as well as their descriptions.

  4. Run the User Connector
  5. Once done, remove the configuration user.connector.updateOnNull=PhoneNumbers from the Connector configuration (see Step 1)

Keywords

phone, number, numbers, phone number, phone numbers, update, user, users, user's, users', connector, user connector, not, does not, updating, updated, did, did not, lms, learning , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning 2011