REP-1401: MSG-01000 Running AERS BIP Reports (Doc ID 1364092.1)

Last updated on MARCH 08, 2017

Applies to:

Adverse Event Reporting System - Version 4.7 and later
Information in this document applies to any platform.
*** Checked for relevance: 01-Apr-2015 ***

Symptoms


On : After the installation of AERS 4.7, when running any BIP Report the following error is occurring:

ERROR
-----------------------
Terminato con errore:
REP-1401: MSG-01000: Report Started
MSG-02000: Obtained the DB Server Attributes
MSG-03000: PRSC Object Created
MSG-04000: OPA_HOME is set
MSG-05000: PRSC Object Params Loaded
MSG-00400: Unhandled Java Exception: javax.xml.rpc.soap.SOAPFaultException: oracle.apps.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: due to oracle.apps.xdo.XDOException: ORA-01722: invalid number
ORA-06512: at "AERS1.REPORT_UTILITY", line 829
ORA-06512: at "AERS1.RPT_PSUR07", line 3607
ORA-06512: at "AERS1.RPT_PSUR07", line 4034
ORA-06512: at line 4

REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06503: PL/SQL: Function returned without value


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Generate a BIP Report utilizing the BIP Report Server

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