My Oracle Support Banner

GP UK - GPGB_PEN_EN - Single-row Subquery Returns More Than One Row (Doc ID 2242080.1)

Last updated on NOVEMBER 23, 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.

Environment Details
HCM 9.1 / Ptools 8.52

Business impact
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

Replication steps
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

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