Refresh APCC Materialized Views
Hi SMEs
We have R12.1.3 and VCP installed standalone instance along with APCC and Demantra. Recent days we are facing error in Refresh APCC Materialized Views program in data collection.
Log file shows
2020-06-01 20:30:27: Refreshing MV : MSC_PHUB_RESOURCES_MV ends
2020-06-01 20:30:27: msc_phub_pkg.build_items_from_pds(-1)
2020-06-01 20:30:27: msc_phub_pkg.manage_partitions(3, 2, -1, 4)
2020-06-01 20:30:27: msc_phub_pkg.manage_table_partition(3, MSC_APCC_ITEM_D, -1, 4)
2020-06-01 20:30:27: alter table MSC_APCC_ITEM_D truncate partition APCC_ITEM_D_0
2020-06-01 20:30:28: msc_phub_pkg.manage_table_partition(3, MSC_APCC_PEG_ITEM_D, -1, 4)