QuickPay Ending with Error APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table ff_formulas_f
Last updated on MARCH 30, 2017
Applies to:
Oracle HRMS (UK) - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
QuickPay ends in the error below.
+---------------------------------------------------------------------------+
Current system time is 07-MAR-2017 14:09:41
+---------------------------------------------------------------------------+
===============================================================================
Oracle Human Resources Generic Process
Started at : 07-MAR-2017 14:09:41
Chunk Size : 20
Threads : 16
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 51341
APP-PAY-51118: Error was encountered when processing assignment 51341
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME NI
APP-PAY-51119: Error was encountered when processing Element Type NI
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
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