"Refresh Collection Snapshots" Errored With Error ORA-27477: "SYS.IDX_RB$CLASS_79499" Already Exists
(Doc ID 1944371.1)
Last updated on AUGUST 23, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0.6 and laterInformation in this document applies to any platform.
Symptoms
PROBLEM
-------------
MSRFWOR module: Refresh Collection Snapshots
+---------------------------------------------------------------------------+
Current system time is 11-NOV-2014 03:01:52
+---------------------------------------------------------------------------+
**Starts**11-NOV-2014 03:01:52
**Ends**11-NOV-2014 03:04:12
ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh path
ORA-27477: "SYS.IDX_RB$CLASS_79499" already exists
STEPS
--------
Launch collections.
BUSINESS IMPACT
----------------------
Collections will not complete.
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 |
Cause |
Solution |
References |