BIL_BI_GRP_CNT_MV Refresh Error ORA-01001 Invalid Cursor and Name Already Used By An Existing Object (Doc ID 1939158.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Sales Intelligence - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Running the  BIL Materialized View Refresh Programe > DBI Clear and Load all Summaries Request Set and getting error:

ERROR
-----------------------
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$_BIL_BI_GRP_CNT_MV" of type INDEX not found in schema "SYS"
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$_BIL_BI_GRP_CNT_MV" of type INDEX not found


STEPS
-------
1. DBI Administrator resp
2. Conc Request
3. Run Sales request set DBI with option Clear And Load All Summaries


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