My Oracle Support Banner

FRM-40735 Error Occurs Upon Re-Opening Recently Entered Case. (Doc ID 329427.1)

Last updated on MARCH 08, 2017

Applies to:

Adverse Event Reporting System - Version: 4.3
This problem can occur on any platform.


When opening an existing case the following errors are returned:

FRM-40735 POST_QUERY trigger raised unhandled exception ORA-06502.
ORA-01403: no data found.

If you attempt to update any fields, the following errors follow:

FRM-40508 ORACLE error: unable to INSERT record.
ORA-0001: Unique constraint (ENSITE.PK-AE-EVENTS-AE-EVENTS-P) violated.
(The error message will list the table location where you attempted to insert information)


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.