Various Shipping Concurrent Programs Error With Multiple Errors ORA-03113, ORA-03114 and ORA-01041
(Doc ID 417071.1)
Last updated on JUNE 20, 2018
Applies to:Oracle Shipping Execution - Version 184.108.40.206 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
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:
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 Database 10g Enterprise Edition Release 10.2.0.2.0/ 11g 220.127.116.11.0
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!