Cannot Run BIPEE Reports via BI Server - ORA-01937: missing or invalid role name

(Doc ID 1319290.1)

Last updated on MAY 12, 2011

Applies to:

Adverse Event Reporting System - Version: 4.6.2 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Goal

AERS 4.6.2

Running any BIP reports:

Get following error when running reports in BI Server.


ORA-01937: missing or invalid role name
ORA-06512: at "AERS1.PUBLIC_RPT_PSUR07", line 18
ORA-06512: at line 4



Solution

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