SAP Knowledge Base Article - Public

3078375 - Workforce HR Import Error failed

Symptom

HR Import error failed with the following message
================================

[DEBUG]  2021-07-05 06:43:50 Running import policies...
[DEBUG]  2021-07-05 06:43:50  Importing employee <User id> from staging to actual using PPI_EMPLOYEE_STAGE
[DEBUG]  2021-07-05 06:43:51  Finished staging to actual transfer of employee using policy: PPI_EMPLOYEE_STAGE
[DEBUG]  2021-07-05 06:43:51  Importing employee <User id> from staging to actual using PPI_ASGNMT_STAGE
[ERROR]  2021-07-05 06:43:51 
Validation Error occurred while processing record with effective dates [From Date - To Date] and match id <User id> . Details: 
 Staging table: PPI_ASGNMT_STAGE
 Employee Import Policy: PPI_ASGNMT_STAGE
 Error Message: class com.workforcesoftware.Exceptions.ImportValidationException: In policy profile group set [GSI_GLOBAL_MONTHLY, GEFC_UK_BIWEEKLY] (linked from policy profile set [GEFC_UK_BIWEEKLY_PPM, GSI_GLOBAL_MONTHLY_PPM]), pay frequencies differed: [2, 4]

[INFO]  2021-07-05 06:43:51 No changes were identified in staging table PPI_EMPLOYEE_STAGE; skipping stage-to-actual step for employee <User id>
[INFO]  2021-07-05 06:43:51 Attempting to import PPI_ASGNMT_STAGE record with match id <User id> and effective dates [From Date - To Date ] using PPI_ASGNMT_STAGE employee import policy ...
[INFO]  2021-07-05 06:43:51 Stage to Actual Assignment HR status is: T
[DEBUG]  2021-07-05 06:43:51 Updating master record with import status information...
[DEBUG]  2021-07-05 06:43:51 Master record updated with import status information...
[DEBUG]  2021-07-05 06:43:51 Unlocking employee for modification by future imports
[ERROR]  2021-07-05 06:43:51 Error occurred while importing employee with Id <User id> . Details: 
Validation Error occurred while processing record with effective dates [From Date - To Date ] and match id <User id> . Details: 
 Staging table: PPI_ASGNMT_STAGE
 Employee Import Policy: PPI_ASGNMT_STAGE
 Error Message: class com.workforcesoftware.Exceptions.ImportValidationException: In policy profile group set [GSI_GLOBAL_MONTHLY, GEFC_UK_BIWEEKLY] (linked from policy profile set [GEFC_UK_BIWEEKLY_PPM, GSI_GLOBAL_MONTHLY_PPM]), pay frequencies differed: [2, 4]

Environment

SAP Time and Attendance Management by WorkForce Software

Reproducing the Issue

  1. Run HR Import for an employee.
  2. Timesheet import failed.
  3. Check HR import log for the mentioned error.

    Employee Import Policy: PPI_ASGNMT_STAGE
     Error Message: class com.workforcesoftware.Exceptions.ImportValidationException: In policy profile group set [GSI_GLOBAL_MONTHLY, GEFC_UK_BIWEEKLY] (linked from policy profile set [GEFC_UK_BIWEEKLY_PPM, GSI_GLOBAL_MONTHLY_PPM]), pay frequencies differed: [2, 4]

Cause

Soft termination window is set to 90. Import will be failed for an employee having any of these conditions.

The employee import will show an error.
===========================
1) Must have a split assignment.

2) The prior assignment must have been soft terminated (so this was a term and rehire, not just a split change).

3) The soft termination period must have been for more than 90 days.

Resolution

  1. Change soft termination window to 365 days.
  2. Re-import the timesheet for an employee.

Keywords

Timesheet, Import, PPI_ASGNMT_STAGE, GEFC_UK_BIWEEKLY_PPM, GSI_GLOBAL_MONTHLY_PPM, PPI_EMPLOYEE_STAGE, soft termination window , KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , Problem

Product

SAP SuccessFactors HXM Core 2105