Enhanced Retropay Errors: ORA-01403: no data found or ORACLE ERROR 3114 IN AFPRSP (Doc ID 1532118.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Enhanced RetroPay process completes with an error and some assignments remain unprocessed.

The log file shows the error.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 507
TABLE_NAME pay_element_types_f
APP-PAY-06881: Error ORA-01403: no data found
 has occurred in table pay_element_types_f at location 507

Cause: an oracle error has occurred. The failure was reported on table pay_element_types_f at location 507 with the error text ORA-01403: no data found

Action: Please contact your support representative.

-------------------------------------------------------------------------
PL/SQL Output
-------------------------------------------------------------------------
ORACLE error 3114 in AFPRSP

Cause: AFPRSP failed due to ORA-03114: not connected to ORACLE

The SQL statement being executed at the time of the error was: and was executed from the file .
Routine FDPCLS encountered an error changing request XXXXXXX status.

Contact your support representative.
ORACLE error 1000 in close_server_files

Cause: close_server_files failed due to ORA-01000: maximum open cursors exceeded.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
ORACLE error 1000 in fetch_lines

Cause: fetch_lines failed due to ORA-01000: maximum open cursors exceeded.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
ORACLE error 1000 in open_server_files

Cause: open_server_files failed due to ORA-01000: maximum open cursors exceeded.





Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1. Run Retropay (Enhanced)



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