My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.