Fusion Global Payroll: Error on Running QuickPay - "A System Error SQL-02112: SELECT..INTO returns too many rows occurred in table pay_status_processing_rules_f" (Doc ID 2569613.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

On : 11.13.19.04.0 version, Global Payroll

When attempting to Run QuickPay,
the following error occurs:

ERROR
-----------------------
A system error SQL-02112: SELECT..INTO returns too many rows occurred in table pay_status_processing_rules_f at location 512. Contact your help desk.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. submit QuickPay;
2. error occurs

Cause

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