SAP Knowledge Base Article - Public

2326028 - Validation Errors not being flagged for additional fields in Extended User input file

Symptom

Custom fields or newly mapped fields added to the user_extended data file are being updated unexpectedly and exception errors are not being handled by the connector nor flagged in the associated connector report.

In addition, these exception errors are caught when mapped to the corresponding user_data file. For example, when mapping TERMINATION_DATE to the user.extended_data file (sfuser.extendeduser.field.mapping.data.TERM_DTE=TERMINATION_DATE) and mapping HIREDATE to standard user_data file (sfuser.field.mapping.data.HIREDATE=HIREDATE). If a user's TERM_DTE is before their HIREDATE in the two files when the SF User Connector is ran, the user record still gets updated and no exception is flagged in the report as would be the expected behaviour.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Learning Administration >
  2. System Administration >
  3. Configuration >
  4. System Configuration >
  5. CONNECTORS configuration file >
  6. Find the mapping: sfuser.extendeduser.field.mapping.data.TERM_DTE=TERMINATION_DATE >
  7. Now, in Provisioning, find corresponding Extended User Export job >
  8. Add TERMINATION_DATE to file's mapping >
  9. Change an exported user's TERMINATION_DTE to date before date in HIREDATE field > 
  10. Run both LMS employee & Extended User Export jobs in Provisioning >
  11. Check to see both user_data and user_extended_data files have been exported to the SFTP >
  12. Run the SF User Connector >
  13. The said user's record updates successfully without any exception error message in the connector job report.

Cause

Currently validation checks are specific to each input file and the code does not handle cross-referencing and validation between the two files.

Resolution

To avoid this issue or any other related to validation checks or erroneous updates across the user_data and user_extended_data files, only map the fields recommended and referenced in the Connector Workbook. They are as follows:

1

USERID

STUD_ID

2

REGULAR-TEMP

REGULAR_TEMP_ID

3

IS-FULLTIME-EMPLOYEE

FULLTIME

4

EMPLOYEE-CLASS

EMP_TYP_ID

5

EMPLSTATUS

EMP_STAT_ID

SAP SuccessFactors Learning does not currently support using any additional fields (including custom fields) other than those listed above and the required validation checks cannot be made across multiple files at this time. This functionality, however, is planned for a future version release to be confirmed by engineers.

See Also

2326051 How to configure mapping for additional custom fields for connector files in SuccessFactors Learning

Keywords

LMS, Connectors, Extended, User, File, Exception, Errors, Custom, Columns, Additional, Fields, Mapping, SF User Connector, HIREDATE, TERM_DTE, termination, hire, date, sf, sap , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions