My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

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


-- 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
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
Program was terminated by signal 1


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.