error when attempting user upgrade on 11.2.0.3 spotlight user (4339478)

Spotlight User Wizard has encountered an error.

760/16 PLS-00201: identifier 'DBMS_SQL' must be declared
760/10 PL/SQL: Statement ignored
761/34 PLS-00201: identifier 'DBMS_SQL' must be declared
761/10 PL/SQL: Statement ignored
762/10 PLS-00201: identifier 'DBMS_SQL' must be declared
762/10 PL/SQL: Statement ignored
763/10 PLS-00201: identifier 'DBMS_SQL' must be declared
763/10 PL/SQL: Statement ignored
764/16 PLS-00201: identifier 'DBMS_SQL' must be declared
764/10 PL/SQL: Statement ignored
765/16 PLS-00201: identifier 'DBMS_SQL' must be declared
765/10 PL/SQL: Statement ignored
770/13 PLS-00201: identifier 'DBMS_SQL' must be declared
770/13 PL/SQL: Statement ignored
771/13 PLS-00201: identifier 'DBMS_SQL' must be declared
771/13 PL/SQL: Statement ignored
980/27 PLS-00201: identifier 'DBMS_SQL' must be declared
980/27 PL/SQL: Item ignored
981/27 PLS-00201: identifier 'DBMS_SQL' must be declared
981/27 PL/SQL: Item ignored
in table Soo ....

and getting table or view does not exist.......this is happening for 11.2 databases.....

Ran manual script, but Spotlight still prompts for upgrade anyway and fails.

The script fails close to the end with :

Package body created.
Package body created.
begin quest_soo_schema_mgr.init; end;
Error at line 74083
ORA-04067: not executed, package body "USER.QUEST_SOO_SCHEMA_MGR" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "USER.QUEST_SOO_SCHEMA_MGR"
ORA-06512: at line 1

BEGIN
quest_soo_schema_mgr.set_version('AnalyzeTrace',0.3);
END;
Error at line 74086
ORA-04067: not executed, package body "USER.QUEST_SOO_SCHEMA_MGR" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "USER.QUEST_SO