Payroll Deduction Import File Error Troubleshooting

Payroll Deduction Import File Error Troubleshooting

ISSUE: Facing multiple issues on Payroll Deduction Import File. 

GOAL: To educate on different configuration to review and verify when each of the above errors happen upon Payroll Deduction File Import. 

Error: “The employee has Multiple Employee Groups with an OTIP Flag in this period”

FIX: Employee likely has a Future Position record with Benefit Plan = OTIP configured. This causes the system to think there are multiple OTIP records. 

Remove OTIP Flag from Future Position to reconcile. 

Note: Future Positions should not have Benefit Plan = OTIP configured yet. 

Error: “The employee is not in a matching group for this period”

FIX: This can be due to Future Position having Benefit Plan = OTIP configured when it should not. 

FIX2: No Current Position is configured with Benefit Plan = OTIP. 

While this is not a prerequisite to populate on MPL, this will cause the Deduction Import File to error out. 

select BENEFIT_PLAN, * from EC_EMPLOYEE_POSITIONS

where EMPLOYEE_ID = 'xxxx'

and POSITION_START_DATE >= '2022-03-30'

and POSITION_END_DATE is NULL