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.

Symptoms

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)

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