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
- Run HR Import for an employee.
- Timesheet import failed.
- 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
- Change soft termination window to 365 days.
- 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