Cannot Rollback FPS Using GB Rollback - ORA-01427: Single-row Subquery Returns More (Doc ID 1917312.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP6 version, UK Payroll

When attempting to Rollback FPS, the following error occurs.
No patches have been applied and FPS has been rolled back for other Payrolls
This problem has only been reported for the FPS on this Payroll

ERROR
-----------------------
"Cause: FDPSTP failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.PAY_GB_ROLLBACK_PKG", line 289
ORA-06512: at "APPS.PAY_GB_ROLLBACK_PKG", line 1200
ORA-06512: at line 1"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Rollback FPS using GB Rollback


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to rollback FPS - unable to make the necessary changes and then submit them to HRMC

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