AMWVIOLATCHK: Check Violation for Constraints program errors out with: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: and was executed from the file . 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. ...

ORACLE error 3114 in AFPRSR-Resubmit_Time Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE . The SQL statement being executed at the time of the error was: and was executed from the file . ORA-01000: maximum open cursors exceededRoutine AFPPRD has encountered a fatal error. ORA-01041: internal error. hostdef extension doesn't exist Contact your system administrator or support representative. Shutting down Concurrent Manager : 18-MAY-2006 16:06:05 ORA-01041: internal error. hostdef extension doesn't exist ORACLE error 3114 in AFPRSR-Resubmit_Time Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE ...

CauseThe error found in the trace file is the same error reported in Bug 4158956: ORA-7445 [KGLOBAL] ERROR OCCURS AFTER APPLYING PATCHSET 9.2.0.6, which was confirmed to be a duplicate of RDBMS Bug 3256015 - APPSST10G: JAVA.SQL.SQLEXCEPTION: NO MORE DATA TO READ FROM SOCKET[KGLPIM].

SolutionTo implement the solution, please execute the following steps:

1. Please download and review the readme and pre-requisites for Patch 3256015.

2. Please apply Patch 3256015 in a test environment.

3. Please retest the issue.

4. If the issue is resolved, migrate the solution as appropriate to other environments.