IFP003 Select Employee Status error during timecard interfacing
Issue/Symptom/Question
We received the below error when trying to process an interface file.
An error has been detected in a SQL Statement.
IFP003 -2112 SQL-02112:SELECT..INTO returns too many rows
select employee status
Applies To
PENTA for Windows
Interfaces > Processing > Initiate Batch Interface Request
Resolution/Fix/Answer
The interface file included a record with an inactive employee. Once the user updated the employee status, they were able to pick up the interface process.