Value Chain Planning - EBS (MOSC)

MOSC Banner

Refresh APCC Materialized Views

edited Jul 29, 2020 5:04AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center