My Oracle Support Banner

Fusion Applications - Global Payroll - RETROPAY Fails With AFDICT_APP_PREFIX-PAY-1635870: A System Error ORA-01422: Exact Fetch Returns Mor (Doc ID 2563197.1)

Last updated on JULY 11, 2019

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

 *Symptoms
Briefly describe the symptoms of the problem. Remember to delete any customer specific information

Changes
If there are changes in the environment, product, account and hardware that trigger the problem describe them.

*Cause
Explain what caused the issue.

An existing employee who has a start date of last year and the user have now created calculation cards for 01-apr-2019 ready for processing in May 2019.

They successfully ran a quickpay for this employee in May, no errors.

They created some additional recurring elements as of 01-April-2019 which created some retro events for 01-APR-2019. After running retro pay with a process date of 01-06-2019 and the process errors with the following:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FUSION.PAY_RETRO_PKG", line 1816
ORA-06512: at line 1

SQL_NO 3065
TABLE_NAME pay_retro_pkg.create_retro_entry
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FUSION.PAY_RETRO_PKG", line 1816
ORA-06512: at line 1
occurred in table pay_retro_pkg.create_retro_entry at location 3065. Contact your help desk.

*Solution
Provide step by step instructions on how to solve the problem.

 

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.