Granting Discoverer EUL Administrative Privileges Via The EULAPI Command-Line To SYSADMIN Fails With ORA-00942

You are granting Administrative privileges to the SYSADMIN user using a similar Discoverer EULAPI command as 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 E-Business Suite schemas/users have been renamed:

For Example:

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

Cause

Several of the standard E-Business Suite users/schemas have been renamed in the database.

Solution

The solution used will depend upon if the schema names were changed before or after the EUL was created.

First, test your connection by specifying the -apps_fndnam parameter using the new "APPS" schema in the EULAPI command-line:

For example:

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

If the above solution does not work or you receive the error: user 'SYSADMIN' not found, then you may need to re-create the EUL with the new schema names.

For example:

1. Delete the existing EUL
   
   
   Note: This is assuming the EUL is newly created and contains no metadata (Business Areas).
   
   
   
   
   eulapi -connect eul_us/eul_us@db -delete_eul -connect <**********> -delete_eul

   
   
2. Create a new applications mode EUL using the new schema name, apps_aol in this example:
   
   
   eulapi -CREATE_EUL -APPS_MODE -CONNECT system/pwd@db -USER EUL_US -PASSWORD EUL_US
-DEFAULT_TABLESPACE discoverer
-TEMPORARY_TABLESPACE TMP_123
-EUL_LANGUAGE US
-APPS_GRANT_DETAILS apps_aol/fnd
-log EULcreation.log

   
   
   
3. Connect using the the new schema name, apps_aol in this example:
   
   
   eulapi -connect eul_us/eul_us@dbetfi8i -apps_fndnam APPS_AOL -grant_privilege -user SYSADMIN -privilege administration -privilege all_admin_privs -log grantEULAdminPriv.log