Granting Discoverer EUL Administrative Privileges via the EULAPI Command-Line to SYSADMIN Fails with ORA-00942 (Doc ID 444752.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.1 to 10.1.2.3 [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Jun-2012***


Symptoms

You are granting Administrative privileges to the SYSADMIN Oracle Applications user using a Discoverer EULAPI command shown below:

 

eulapi -connect eul_us/eul_us@db -grant_privilege -user SYSADMIN
-privilege administration -privilege all_admin_privs -log grantEULAdminPriv.log

 

 

When running the command, it fails with:

 

ORA-00942: table or view does not exist

 

Changes

The following standard E-Business Suite schemas have been renamed:

Renamed "APPS" to "APPS_AOL" 
Renamed  "APPLSYSPUB" to "AOLPUB"
Renamed "APPLSYS" to "AOL"

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