SQL Error Message while Running Payroll
Issue/Symptom/Question
Receiving the following error while running the week's final gross-to-net. 'Centralized Gross to Net Processing'
"An error has been detected in a SQL Statement.
PRP008 -1405 ORA-01405: fetched column value is NULL
wh_para,eters - sit emp"
Applies To
Running Centralized Gross to Net Processing
Payroll > Centralized Payroll Check Processing > Centralized Gross to Net Processing
Payroll > Employees > Employee Payroll Information
Resolution/Fix/Answer
- Payroll > Employees > Employee Payroll Information
- Click on the Withholding tab
- Check the State Withholding section
- If State Code is entered, Subject to State W/H (Y/N) is required to have a value entered to run Centralized Gross to Net Processing