My Oracle Support Banner

Mass Revaluation Errors with ORA-03114, ORA-01000, ORA-01041 (Doc ID 456623.1)

Last updated on AUGUST 20, 2019

Applies to:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2011***


Symptoms

-- Problem Statement:
When running Mass Revaluation, the following errors are encountered:

APP-OFA-48400: ORA-03113: end-of-file on communication channel

Number of
Number of failuers: 0
The mass change module finished with errors:
Error de ORACLE 3114 en AFPRSR-Resubmit_Time

Cause: FPRSR-Resubmit_Time, has failed due to an ORA-03114: not connected to ORACLE
.

the sql sentence being executed from the file at the moment of the error was:
The FDPCLS path found an error when changing the status of the request 1223428

Contact support representative
APP-FND-01564: Error de ORACLE 1000 en close_server_files

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

The SQL sentence executed at the moment of the error was: &SQLSTMT and was executed from the file
&ERRFILE.
Error ORACLE 1041 on FDPCLS

Cause: FDPCLS has failed due to an ORA-01041: internal error. hostdef extension doesn't exist
.
The SQL sentence executed at the moment of the error was:
select (min(asset_id)-1) into :b0 from f
/applprod11/prodappl/fa/11.5.0/bin/FAVRVL
Program was terminated by signal 1

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!


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