FRM-40735 ORA-6502 in Update Submission Dates (Doc ID 309671.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Adverse Event Reporting System - Version 4.5.1 and later
Information in this document applies to any platform.
***Reviewed for currency: 22-Jan-2015***

Symptoms

In AERS The following error is generated when navigating to File->Update Submission Dates in the Case Browse window:

FRM-40735 WHEN-NEW-FORMS-INSTANCE trigger raised unhandled exception ORA-6502.
ORA-1403: no data found.

- After accepting the error message not all expected records are displayed.

 

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