SAP Knowledge Base Article - Public

2641074 - SF-User connector: number of records processed explained

Symptom

We have noticed a discrepency between the number of records the connector has processed and the number of records in our user_data and extended_user data files.

For example:

  • User data file = 263 records
  • Extended User file = 213 records
  • Processed records = 333 (and no records were rejected)

Environment

  • SAP SuccessFactors HCM suite
  • Learning Management System (LMS)
  • System admin > connectors > User connector -SF
  • View results > Processed
  • Show archived input files > # of records contained in files

Cause

  • All the records have been processed correctly.
  • The way the connector counts the records is as follow: All the records in user_data file + all UNIQUE records in user_extended_data file = processed records
  • Unique means that there is no record for the same user in the user_data_file (specific to updating certain fields for an existing user)
    For example: User A is changing region and this field is mapped in my extended user file, there is no other update to this user record.
    User A will have a record in the extended_user_data file ONLY but no record in the user_data file.

Resolution

By using a lookup formula in Excel, we were able to determine the number of unique records in the extended_user_data file and confirmed that this number, added to the records in the user_data file do match the total number of processed records.

  • Unique extended records = 70 records
  • User data file = 263 records
  • Total processed records = 263 +70 = 333 records

Keywords

SAP, SF, Successfactors, LMS, learning, connnectors, SF connector, User connector -SF, records, processed, archived, input file, user file, extended user file , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors Learning 1711