AMWVIOLATCHK: ORA-03113, ORA-01000, ORA-01041 in Check Violation For Constraints Program (Doc ID 373776.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Internal Controls Manager - Version 11.5.8 to 11.5.10.0 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.
EXECUTABLE:AMWVIOLATCHK - Check Constraint Violation

Symptoms

RDBMS 9.2.0.6

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 exceeded
Routine 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
...

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
Contact your system administrator or support representative.

The SQL Trace file contains the following:

ORA-07445: exception encountered: core dump [kglobal()+588] [SIGBUS] [unknown code] [0x0000000D8] [] []
Current SQL statement for this session:
SELECT urall.RESPONSIBILITY_APPLICATION_ID,urall.responsibility_id,
min(urall.start_date) start_date, (select ur.created_by from
FND_USER_RESP_GROUPS_ALL ur where ur.user_id = :1 and ur.responsibility_id =
urall.responsibility_id and ur.start_date = start_date and rownum=1)
created_by, ce.group_code FROM FND_USER_RESP_GROUPS_ALL urall
,AMW_CONSTRAINT_ENTRIES ce WHERE urall.user_id = :2 and urall.start_date <=
sysdate AND (urall.end_date >= sysdate or urall.end_date is null) AND
urall.responsibility_id = ce.function_id AND ce.constraint_rev_id = :3
GROUP BY urall.RESPONSIBILITY_APPLICATION_ID,urall.responsibility_id,
ce.group_code

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