Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292 Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE; ORA-33262: Analytic workspace ODPCODE does not exist.

(Doc ID 1054417.1)

Last updated on AUGUST 04, 2015

Applies to:

Oracle Application Install - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2012***

Symptoms

When attempting to apply the R12.1.1 upgrade driver, patch 6678700 is failing with following errors :

sqlplus -s APPS/***** @<Path to $MSD_TOP>/patch/115/sql/MSDODPCODE.sql
begin
*
ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
using the specified access mode.
ORA-06512: at "SYS.DBMS_AW", line 67
ORA-06512: at "SYS.DBMS_AW", line 131
ORA-06512: at "SYS.DBMS_AW", line 984
ORA-06512: at "SYS.DBMS_AW", line 937
ORA-33262: Analytic workspace ODPCODE does not exist.      <===
ORA-06512: at "SYS.DBMS_AW", line 908
ORA-06512: at "APPS.MSD_AW_LOADER", line 10
ORA-06512: at line


Another similar error that can be encountered for the same reasons is the failure of the script fpamain.sql with the following error:

declare
*
ERROR at line 1:
ORA-33290: Analytic workspace FPA.FPAPJP cannot be attached in the mode you
requested because another user has it attached in an incompatible mode.
ORA-06512: at line 13483

Changes

The above errors may be encountered as part of different scenarios as follows:

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