/
SQL Error Message while Running Payroll


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"


Capture.PNG


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


  1. Payroll > Employees > Employee Payroll Information
  2. Click on the Withholding tab
  3. Check the State Withholding section
  4. 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





Related content

PRP032 Payroll Error during Gross To Net
PRP032 Payroll Error during Gross To Net
More like this
PRP008 Function store_oper() Payroll Error during Gross To Net Process
PRP008 Function store_oper() Payroll Error during Gross To Net Process
More like this
Error processing payroll ORA-00001: unique constraint (PRODUCTION.TC_DED_PK) violated
Error processing payroll ORA-00001: unique constraint (PRODUCTION.TC_DED_PK) violated
More like this
Error running centralized gross to net
Error running centralized gross to net
More like this
PRP009 SQL MD = Invalid W/H state code for Maryland error
PRP009 SQL MD = Invalid W/H state code for Maryland error
More like this
Application error during Centralized Gross Pay Report or when querying timecard batch
Application error during Centralized Gross Pay Report or when querying timecard batch
More like this