FRM-40735 Error Occurs Upon Re-Opening Recently Entered Case.
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms