User with Admin Privs in Disco Cannot Log into Disco Integrator - No Access to EUL Tables (Doc ID 281187.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Discoverer Integrator 4.5

Symptoms

An Oracle Financial Services Applications (OFSA) user who has been assigned "Administration" privileges within Discoverer Administration, such as ofsa_eulowner or the OFSA database owner, cannot log into OFSA's Discoverer Integrator application.  They receive the following error:

You do not have access to any End User Layer tables

They have already gone into Discoverer Admin as the EUL owner, gone to "Tools" > "Privileges", and refreshed the "Administration" privileges for this user.

When they review the table privileges assigned to the user, they see "EUL4" table privileges:

select table_name, privilege from dba_tab_privs
where grantee = 'username';

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