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 30, 2017

Applies to:

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

Symptoms

Problem Statement:

QuickPay ends in the error below.

QUICKPAY: QuickPay Run
+---------------------------------------------------------------------------+

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