Enhanced Retropay Errors: ORA-01403: no data found or ORACLE ERROR 3114 IN AFPRSP
(Doc ID 1532118.1)
Last updated on JUNE 12, 2022
Applies to:
Oracle Payroll - Version 11.5.10.2 and laterInformation 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.
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:
- Run Retropay (Enhanced)
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 |