DBI Request Failing After Database Upgrade To 11.2.0.4.3 (Doc ID 1936333.1)

Last updated on OCTOBER 20, 2014

Applies to:

Oracle E-Business Intelligence - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The DBI request failing with errors after Database upgrade to 11.2.0.4.3:

Recreate Indexes, if any, on MVLog
Failed creating MV log for APPS.OPI_INV_VAL_SUM_MV, ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_OPI_INV_VAL_SUM_MV" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "APPS.BIS_MV_REFRESH", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_OPI_INV_VAL_SUM_MV" of type INDEX not found

 

Recreate Indexes, if any, on MVLog
Failed creating MV log for APPS.ENI_RES_1_MV, ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_ENI_RES_1_MV" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "APPS.BIS_MV_REFRESH", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_ENI_RES_1_MV" of type INDEX not found in sch
ema "SYS"

 

executing apps_array_ddl.apps_array_ddl
Recreate Indexes, if any, on MVLog
Failed creating MV log for APPS.ISC_DBI_CFM_005_MV, ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_ISC_DBI_CFM_005_MV" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "APPS.BIS_MV_REFRESH", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.BIS_BIA_RSG_LOG_MGMNT", line 551
ORA-31603: object "I_MLOG$_ISC_DBI_CFM_005_MV" of type INDEX not found
in schema "SYS"


What can be done?

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