Symptom
Integration Center (IC) job upserting EmpEmploymentTermination entity failing with the error:
"Failed due to - Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from ";DEFAULT_SCHEMA;".EMP_JOB_INFO_T where JOB_INFO_ID=? and CREATED_BY = ? and CREATED_DATE = ? and USERS_SYS_ID = ? and LAST_MODIFIED_BY = ? and LAST_MODIFIED_DATE = ? and CUSTOM_DATE1 is null and CUSTOM_DATE10 is null and CUSTOM_DATE2 is null and CUSTOM_DATE3 is null and CUSTOM_DATE4 is null and CUSTOM_DATE5 is null and CUSTOM_DATE6 is null and CUSTOM_DAT "
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create an Inbound or SF to SF IC job upserting data in EmpEmploymentTermination entity;
- Run the IC job;
Cause
There may be an issue with the Position Hierarchy adoption that is used to execute synchronously during termination.
Resolution
In Admin Center > Company System and Logo Settings select the checkbox Enable Centralized Services for Termination Details and save (refer to Centralized Services for Employee Data Imports chapter).
Keywords
centralizes services, resignation, API, import, issue, resignation, inbound, SF to SF , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , Problem