SAP Knowledge Base Article - Public

2241410 - User Sync not importing

Symptom

  • Users are not loading into Onboarding
  • User Sync job pick up from SFTP
  • User Sync failing to load into Onboarding

2015-11-09_usersync_failed.png

Resolution

  • The fields in the UserSync table created in BizX must match exactly to the Foundation Field Mapping xml

Example below:

Fields in the  UserSync Table -

2015-11-09_usersync_headers must match.png

Fields in the Foundation Mapping xml -

2015-11-09_usersync_case sensitive.png

Note: In the Foundation Filed Mapping xml is expecting the User Sync ID to be in lower case, upon import this would case the UserSync to fail

You should confirm that all fields match.

Change the Foundation Field Mapping to "User Sys ID" to match the User Sync table from BizX

2015-11-09_usersync_fieldmapping.png

Re - upload the Foundation Field Mapping through Super Admin

Please check settings in the file "ImportUsers.xslt" (Super Admin/ Import/Export Settings).

By default the file must use variables
2016-02-10_11-40-23.png

If you use columns names instead of variables, please sure that columns names are correct

 2016-02-10_11-43-18.png

 

Re - upload the  "ImportUsers.xslt" through Super Admin if it necessary

Run the UserSync in Provisioning

Check the Integration through the Onboarding Audit, import Successful see below

2015-11-09_usersync_successful.png

 

Keywords

KBA , LOD-SF-OBD , Onboarding , Problem

Product

SuccessFactors HCM Core 1508