Issue/Symptom/Question

When interfacing employee labor time, I received the following error:

An error has been detected in a SQL Statement.

IFP003 1205 ORA -01405: fetched column value is NULL

select prev day of employee status_date

Applies To

PENTA for Windows  version 21.2

Labor Interface / Timecard import

Resolution/Fix/Answer

If you experience this problem please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

• the .txt file being imported
• the User ID of the person importing the file

Cause 

One of the employees in the interface file has a first active date in their employee record after the first day of the pay period (they were hired mid-week).