The Medwatch Report Fails With REP-1401, ORA-6502, ORA-6512 For A Specific Case
Last updated on AUGUST 08, 2011
Applies to:Adverse Event Reporting System - Version: 188.8.131.52
Information in this document applies to any platform.
***Checked for relevance on 08-AUG-2011***
In AERS 4.5.1
When attempting to execute the Medwatch Report in 'Draft' Mode for a particular case, the
following error occurs:
Terminated with error:
REP-1401: Begin POP_MEDWATCHTEMP_TABLE28115!
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "ENSITE.RPT_THERAPY_DELTA", line 1173
ORA-06512: at "ENSITE.RPT_THERAPY_DATA", line 2078
ORA-06512: at "ENSITE.RPT_MEDWATCH_PKG", line 1074
ORA-06512: at "ENSITE.RPT_MEDWATCH_PKG", line 239
The Medwatch runs successfully for other cases and the CIOMS report executes successfully for this particular case.
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