My Oracle Support Banner

Running AERS E2B Report Terminates with Warning - REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-06502: PL/SQL: numeric or value error (Doc ID 1273392.1)

Last updated on JUNE 12, 2018

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.

Symptoms

AERS 4.6.1

When running an E2B report ( including a particular case) , get the following error:

Terminated with error:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "AERS1.E2B", line 995
ORA-06512: at "AERS1.E2B", line 1112
ORA-06512: at "AERS1.E2B", line 9359
ORA-06512: at "AERS1.E2B", line 9906



If mentioned case is removed from case list or run, then error does not occur.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.