Symptom
- Scheduled Employee Import (SFTP jobs) not validating the required field of User data import file. It is uploading the user import file even with blank username/invalid Manager.
- The job of Employee Import is completed with an error: Failed to add/update user [xxx] ": Missing required fields - "[GENDER, XX]"
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Schedule an Employee Import Job in Provisioning or Import user via the UI
- Run the job by placing the import file leaving any required field blank like username/invalid manager ID
- The job completes without any error, no validation occurred.
- Perform validation check for the same import file via Employee data import in Admin center, there are validation errors for required fields.
Cause
There is an option in Provisioning that controls the validation of required field of Employee data file:
"Assign default required field values for new users if none specified"
When this feature is enabled:
- If Username field is blank then system will automatically populate with the value of UserID
- If user has invalid manager, system will automatically populate as no manager.
Also, the fields must be set as Required = True in the data model. If the flag is enabled, and the HR fields are not informed in the User Data File (UDF), the system will generate a default value for these two fields, and then the error will not occur.
Resolution
Please contact your partner or support team if you want to change the behavior and disable "Assign default required field values for new users if none specified".
Keywords
Assign default required field values for new users if none specified, Employee Import Job, No validation on required field, user job, required field, ECT-201586, INC2998517 , KBA , LOD-SF-PLT-UIM , Employee Import Issues , How To