My Oracle Support Banner

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 JUNE 07, 2021

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
+---------------------------------------------------------------------------+

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 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



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
Cause
Solution
References


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