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

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll UK - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

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

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