P45 Not Produced - Tax Details blank and with error ORA-24347: Warning of a NULL column in an aggregate function FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01841. (Doc ID 2296314.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Upon processing the termination of an ex employee - when payroll, prepayments, FPS and P45 Process have been run, no P45 is produced.
When looking at tax details for the employee, they show blank and the following error occurs:

Error:
ORA-24347: Warning of a NULL column in an aggregate function
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01841.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Run payroll, prepayments, FPS and P45 Process
2. No P45 produced
3. Tax details is grayed out.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms