GP UK - GPGB_PEN_EN - Single-row Subquery Returns More Than One Row
(Doc ID 2242080.1)
Last updated on FEBRUARY 03, 2019
Applies to:PeopleSoft Enterprise HCM Global Payroll UK - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, General
During spot testing critical processes for bundling, it has been encountered an issue when running the pension auto enrollment process GPGB_PEN_EN.
The process ran to No Success because of "single-row sub-query returns more than one row".
The piece of SQL we used from the log file identified that the code is unable to cater for employees with more than one XFR row in JOB.
HCM 9.1 / Ptools 8.52
Unable to run the pension enrollment process and testing needs to be completed in time for bundles to be applied before the new tax year
1. Finalize a calendar and ensure an employee within the calendar run has more than one XFR row in JOB.
2. Run the Auto enrollment process in Trial for the calendar group
3. Review the results
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