Problem :
Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292
Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE
Solution :
1) Verify the status for the account OLAPSYS, checking that the account is not EXPIRED or LOCKED:
select username ,account_status from dba_users where username like '%OLAP%';
If the above query showed that the user is locked, unlock using the following sql command:
ALTER USER OLAPSYS IDENTIFIED BY "newpassword" ACCOUNT UNLOCK;
2) Please run the following as APPS User in SQL*Plus to create the analytic workspace (AW) odpcode:
begin
dbms_aw.execute('aw create odpcode');
end;
dbms_aw.execute('aw create odpcode');
end;
3) Bounce the database
4) Continue with upgrade/retest, and restart the failing worker using adctrl.
Reference : Metalink Id 1054417.1
