The Medwatch Report Fails With REP-1401, ORA-6502, ORA-6512 For A Specific Case (Doc ID 459844.1)

Last updated on AUGUST 08, 2011

Applies to:

Adverse Event Reporting System - Version: 4.5.1.38 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
=================================
***Checked for relevance on 08-AUG-2011***
=================================

Symptoms

In AERS 4.5.1

When attempting to execute the Medwatch Report in 'Draft' Mode for a particular case, the
following error occurs:

ERROR

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.

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