My Oracle Support Banner

Order Import Program Errors With AFPGRG Failed Due To ORA-03114: Not Connected To ORACLE After Upgrading To Release 12.2 (Doc ID 2291513.1)

Last updated on NOVEMBER 10, 2021

Applies to:

Oracle Order Management - Version 12.2 to 12.2.11 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Running Order Import program via an automated process errors with the following:



ERROR

ORACLE error 3113 in FDPSTP
Cause: FDPSTP failed due to ORA-03113: end-of-file on communication channel
The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.A and was executed
APP-FND-01564: ORACLE error 3114 in AFPGRG
Cause: AFPGRG failed due to ORA-03114: not connected to ORACLE.
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
+---------------------------------------------------------------------------+
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: SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.A and was executed
ORA-03114: not connected to ORACLE
Routine AFPPRD has encountered a fatal error. ORA-03114: not connected to ORACLE
Contact your system administrator or support representative.
Shutting down Concurrent Manager
ORA-03114: not connected to ORACLE
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: savepoint FND_LOCK_REQUEST and was executed from the file 19879690/fnd/lib/afpsrs.

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-03114: not connected
to ORACLE
Review your error messages for the cause of the error. (=)
_ 2 _
Routine AFPPRD has encountered a fatal error. ORA-03114: not connected
to ORACLE
Contact your system administrator or support representative.


STEPS

1. Order Management Super User Responsibility
2. Run Order Import Concurrent Program

Changes

 Upgrade to Release 12.2

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
Changes
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.