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
- Learning Administration >
- System Administration >
- Configuration >
- System Configuration >
- CONNECTORS configuration file >
- Find the mapping: sfuser.extendeduser.field.mapping.data.TERM_DTE=TERMINATION_DATE >
- Now, in Provisioning, find corresponding Extended User Export job >
- Add TERMINATION_DATE to file's mapping >
- Change an exported user's TERMINATION_DTE to date before date in HIREDATE field >
- Run both LMS employee & Extended User Export jobs in Provisioning >
- Check to see both user_data and user_extended_data files have been exported to the SFTP >
- Run the SF User Connector >
- 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
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