Various Shipping Concurrent Programs Error With Multiple Errors ORA-03113, ORA-03114 and ORA-01041
Last updated on MARCH 08, 2017
Applies to:
Oracle Shipping Execution - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document applies to any platform.
EXECUTABLE:WSHINTERFACE - Interface Trip Stop
EXECUTABLE:WSHPSGL - Pick Selection List Generation
EXECUTABLE:WSHASCSRS - Automated Ship Confirm - SRS
Symptoms
When attempting to run a Shipping concurrent program, such as, Pick Selection List Generation, Automated Ship Confirm SRS and/orthe Interface Trip Stop, the following errors are occurring:
ERROR
-------------
**Starts**08-FEB-2007 14:30:07
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
APP-FND-01564: ORACLE error 1000 in AFPGRG
Cause: AFPGRG 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.
List of errors encountered:
1) Routine AFPCMT encountered an ORACLE error. ORA-01041: internal error. hostdef extension doesn't exist.
Review your error messages for the cause of the error. (=<POINTER>)
2) Routine AFPPRD has encountered a fatal error. ORA-03114: not connected to ORACLE. Contact your system administrator or support representative.
3) Routine AFPPRD has encountered a fatal error. ORA-01041: internal error. hostdef extension doesn't exist.
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
APP-FND-01564: ORACLE error 1000 in AFPGRG
Cause: AFPGRG 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.
List of errors encountered:
1) Routine AFPCMT encountered an ORACLE error. ORA-01041: internal error. hostdef extension doesn't exist.
Review your error messages for the cause of the error. (=<POINTER>)
2) Routine AFPPRD has encountered a fatal error. ORA-03114: not connected to ORACLE. Contact your system administrator or support representative.
3) Routine AFPPRD has encountered a fatal error. ORA-01041: internal error. hostdef extension doesn't exist.
.
Changes
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0/ 11g 11.2.0.3.0
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