Symptom
This is KBA relating to customers not receiving the usual Exception Error message in the SF User Connector Report when a user's Termination Date (TERM_DTE) is before their Hire Date (HIRE_DTE) in the input file(s). When this is the case, the exception error message is usually flagged in the report and the affected user's Termination Date in their user record is subsequently not updated.
Error Message
Error Code: 1213
Exception: Term Date cannot be before Hire Date
Environment
SAP SuccessFactors Learning
Reproducing the Issue
Manual Process
- Populate user_data & user_extended_data files >
- Update EXIT_DATE (TERM_DTE) in user_extended_data file so that it is before HIRE_DTE in user_data file >
- Make sure user record is set to INACTIVE >
- Run SF User Connector >
- Check Connector Run Detailed Report for Exception Error Message.
Automated Process
- Make EXIT_DATE in BizX User Profile before date in HIRE_DTE field >
- Inactivate User in BizX >
- Run SF User Connector >
- Check Connector Run Detailed Report for Exception Error Message.
Cause
If this condition is met (TERM_DTE < HIRE_DTE) and the Exception Error Message is not flagged in the Connector Detailed Report (and the TERM_DTE field is not updated), this is usually a mapping issue.
Resolution
- Make sure that TERM_DTE is mapped to SF Extended User Connector and not just the SF User Connector as the TERM_DTE field is updated by data in the EXIT_DATE column field contained in the User Extended Data file.
- In the Connector Configuration file include the following mapping: sfuser.extendeduser.field.mapping.data.TERM_DTE=EXIT_DATE
- Make sure that the date in the EXIT_DATE column field matches the following format: MON-DD-YYYY HH24:MI:SS or the TERM_DTE field will not update and no Exception Error Message will appear in the mentioned report.
Additionally, if you only want to include the date and not the exact timestamp, you can include the following property so that only MON-DD-YYYY is needed:
sfuser.extendeduser.field.transform.date.format.TERM_DTE.MMM-dd-yyyy\ HH\:mm\:ss=MM/dd/yyyy
Keywords
lms, learning, sf, successfactors, user, connector, termination, date, hire, term, cannot, future , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem