Various Shipping Concurrent Programs Error With Multiple Errors ORA-03113, ORA-03114 and ORA-01041 (Doc ID 417071.1)

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.



.

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