Refresh APCC Materialized Views Completing In Error ORA-00001

(Doc ID 1927853.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Refresh APCC Materialized Views MSCHUBRMV module: Refresh APCC Materialized Views
completing in error in the log file:

MSCHUBRMV module: Refresh APCC Materialized Views

+---------------------------------------------------------------------------+

Current system time is 25-AUG-2014 16:28:00

+---------------------------------------------------------------------------+

**Starts**25-AUG-2014 16:28:00
**Ends**25-AUG-2014 16:28:16
msc_phub_pkg.refresh_mvs.exception: ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (APPS.MSC_PHUB_CATEGORIES_MV_U1) violated
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
2014-08-25 16:28:01: msc_phub_pkg.refresh_mvs(1)
2014-08-25 16:28:01: msc_phub_pkg.check_apcc_setup: cal_code=US:US_CAL, period_set_name=, reporting_currency=USD, category_set_id1=7, category_set_id2=, category_set_id3=, pg_category_set_id=, measure_blocks=1,2,3,5, time_granularity=, currency_conv_type=
2014-08-25 16:28:01: l_new_version_type=
2014-08-25 16:28:01: msc_phub_pkg.check_migrate
2014-08-25 16:28:01: msc_phub_pkg.check_migrate, l_need_migrate=0
2014-08-25 16:28:01: Refreshing MV : MSC_PHUB_DATES_MV starts
2014-08-25 16:28:15: Refreshing MV : MSC_PHUB_DATES_MV ends
2014-08-25 16:28:15: Refreshing MV : MSC_PHUB_CATEGORIES_MV starts
2014-08-25 16:28:16: msc_phub_pkg.refresh_mvs.exception: ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (APPS.MSC_PHUB_CATEGORIES_MV_U1) violated
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+


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