My Oracle Support Banner

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 SEPTEMBER 06, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.