My Oracle Support Banner

Fusion UK Payroll - P45 Errors for Employees With Multiple Assignments - Single row subquery returns more than one row (Doc ID 2762575.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.21.01.0 to 11.13.21.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.13.21.01.0 version, UK - United Kingdom Legislation

When attempting to run P45 report, specific employees are returning an error:

ERROR
-----------------------
A System error ORA-01427 Single row subquery returns more than one row ORA-06512 at ORA.FUSION_PAY_REPORT_PROCESS Line 2077
ORA-06512 FUSION.HRX_GB_ARCHIVE line 1088


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run P45 Process
2. Review results.

Changes

 

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
Changes
Cause
Solution
References


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