This error message:
"SOURCEREF:s26500_council_tax
EMPNO :XXXXX
ERRNO :100
ERRMESS :ORA-01403: no data found
**End UnHandled Exception - Contact Support HelpDesk."
appears in the PAY140 trace file.
The employee flagged in the trace file show negative net earnings, affecting their council tax calculations. Council tax starts at a net earning of 0, and a negative entry is necessary when an employee’s pay dips below zero.
Additionally, there must be a valid entry against the employee's positive monthly threshold.
Check tax council pay code
To check the tax council pay code, follow the steps outlined in the relevant section below.
Portal
Click Employee then in the search field, search for employee.
Beside the relevant employee, click VIEW.
Click Deductions.
Back Office
Click CorePay then click Employee.
Click Employee Deductions then View Employee Deductions.
Valid entry
To input a valid entry against the employee's positive monthly threshold, follow the steps outlined in the relevant section below.
Portal
Click Settings, then under Codes, click Pay Codes(Classic).
From the Pay Group drop-down menu, select the relevant pay code.
Click Deductions.
⚠️Important: If the employee has negative earnings, follow the steps below.
Under Court Orders / AEO’s, click Scales.
Add a row with Nett Earnings From as -9999 and the Nett Earnings To as Zero.
📌 Note: If the employee has positive earnings, follow these steps.
Check that there is a valid entry covering a range that includes the employee's weekly or monthly earnings for that period.
Check for any gaps in the thresholds (e.g., 0-100, 100.01 - 160.00, 160.01 - 220).
Back Office
Click CorePay then click Reference.
Click Advanced Reference Features then click Reference K-P.
Click Nett deduction Rates.
⚠️Important: If the employee has negative earnings, follow the steps below.
To add a row, click the add
icon.Input Nett Earnings From as -9999 and the Nett Earnings To as Zero.
📌Note: If the employee has positive earnings, follow the steps below.
Check that there is a valid entry that covers a range including the employee’s weekly or monthly earnings.