My Oracle Support Banner

Daily Business Intelligence Request Failing After Database Upgrade To 11.2.0.4.3 (Doc ID 1936333.1)

Last updated on OCTOBER 05, 2023

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.<OBJECT NAME>: name is already used by an existing object
ORA-06512: at "APPS.<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "<OBJECT NAME>", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" of type INDEX not found

 

Recreate Indexes, if any, on MVLog
Failed creating MV log for "<OBJECT NAME>", ORA-00955: name is already used by an existing object
ORA-06512: at "<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "<OBJECT NAME>", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" 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 "<OBJECT NAME>": name is already used by an existing object
ORA-06512: at "<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" of type INDEX not found in schema "SYS"
 
Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "<OBJECT NAME>", line 255
ORA-00955: name is already used by an existing object
ORA-06512: at "<OBJECT NAME>", line 551
ORA-31603: object "<OBJECT NAME>" of type INDEX not found
in schema "SYS"


What can be done?

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.