GP UK - GPGB_PEN_EN - Single-row Subquery Returns More Than One Row
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.
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
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