QuickPay Ending with Error APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table ff_formulas_f
(Doc ID 2247801.1)
Last updated on MARCH 21, 2022
Applies to:
Oracle Payroll - Version 12.1 to 12.2 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
Problem Statement:
QuickPay ends in the error below.
+---------------------------------------------------------------------------+
Chunk Size : 20
Threads : 16
HR_51118_HRPROC_ERR_OCC_ON_ASG
APP-PAY-51118: Error was encountered when processing assignment xxxx
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME XXXXX
APP-PAY-51119: Error was encountered when processing Element Type XXXXX
HR_6881_HRPROC_ORA_ERR
SQLERRMC SQL-02112: SELECT..INTO returns too many rows
SQL_NO 521
TABLE_NAME ff_formulas_f
APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table ff_formulas_f at location 521
Cause: an oracle error has occurred. The failure was reported on table ff_formulas_f at location 521 with the error text SQL-02112: SELECT..INTO returns too many rows.
Action: Please contact your support representative.
stat_low = 8B
stat_high = 0
emsg:was terminated by signal 11
Program exited with status -1
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 1403 in afppct
Cause: afppct failed due to ORA-01403: no data found
ORA-06512: at "APPS.FND_CONC_STAT", line 62
ORA-06512: at "APPS.FND_CONC_STAT", line 113
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: and was executed from the file &ERRFILE.
Concurrent request completed
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Execute QuickPay for an employee
2. Observe error in log
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |