SAP Knowledge Base Article - Public

2316465 - TERM_DTE < HIRE_DTE not triggering SF User Connector Exception Message

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

  1. Populate user_data & user_extended_data files >
  2. Update EXIT_DATE (TERM_DTE) in user_extended_data file so that it is before HIRE_DTE in user_data file >
  3. Make sure user record is set to INACTIVE >
  4. Run SF User Connector >
  5. Check Connector Run Detailed Report for Exception Error Message.

Automated Process

  1. Make EXIT_DATE in BizX User Profile before date in HIRE_DTE field >
  2. Inactivate User in BizX >
  3. Run SF User Connector >
  4. 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

Product

SAP SuccessFactors Learning all versions