Issue/Symptom/Question

User is trying to input an employees time, when the user queries a particular employee ID she gets this error message.

Port: Port

Program: u_dwPenta

Function: itemChanged

SQL Error Number: 1422

SQL Error Text: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "PENTA.PK_EMPINFO", line 31

ORA-06512: at line 1

System Error Text: Window: w_pentaMaint

u_dwPenta ( itemChanged, of_itemChanged_empId )

tabpage_weekly ( of_itemchanged_empId, n_employee:of_editWithSecurity )

n_employee ( of_editWithSecurity, of_edit )

n_employee ( of_edit, Get Status from emp_stat_hist )

SQL Code: -1

SQL DB Code: 1422

SQL Error Text: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "PENTA.PK_EMPINFO", line 31

ORA-06512: at line 1

Applies To

Penta for Windows

Payroll Time Entry

Resolution/Fix/Answer

The error indicates the employee may have more than one record in their status history with the same date - Get Status from emp_stat_hist.

Check the employee’s status history to make sure there are no duplicate dates. If so, you’ll have to delete one of the duplicates and, enter a date after the last previous status. 

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:

• Screenshot of the Error
• Employee ID
• PTI Error or Error History