Error when running Oracle User Wizard: "PL/SQL: ORA-00942: table or view does not exist" (4267895)

I receive PL/SQL errors when using the Oracle User Wizard in Spotlight on one of our databases.

Here is the output:

PACKAGE BODY (Line: 640)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 639)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 645)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 644)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 2524)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 2523)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 2561)
PLS-00364: loop index variable 'R1' use is invalid

PACKAGE BODY (Line: 2561)
PL/SQL: Statement ignored


** Log opened: 3/20/2009 10:28:04 AM **
PACKAGE BODY (Line: 640)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 639)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 645)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 644)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 2524)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 2523)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 2561)
PLS-00364: loop index variable 'R1' use is invalid

PACKAGE BODY (Line: 2561)
PL/SQL: Statement ignored


** Log opened: 3/20/2009 10:29:38 AM **
PACKAGE BODY (Line: 640)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 639)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 645)
PL/SQL: ORA-00942: table or view does not exist

PACKAGE BODY (Line: 644)
PL/SQL: SQL Statement ignored

PACKAGE BODY (Line: 2524)
PL/SQL: ORA-00942: table or view does not exist

Missing synonym

This issue can be due to a missing public synonym. To discover which synonym is missing, the user can run the manual installation script and examine the output.

The manual installation script can be found in C:\Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScripts along with instructions on what to do.

Note: It may be helpful to run each section of the script one at a time until the error is reproduced.