R12.1.1 : R12.1.1 upgrade fails on file isc_fs_004_mv.xdf Exception occured ORA-00942: table or v
Hi
during upgrade from 11i to R12 I faced error
1 Run AutoPatch R120 pl isc_fs_004_mv.xdf FAILED
with error
Exception occured ORA-00942: table or view does not exist
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1
The log file is showing :
File name : adwork001.log
================================
CREATE MATERIALIZED VIEW "APPS"."ISC_FS_004_MV"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)