VPC patch has been applied in our EBS environment (12.1.2) which has impacted tables being used for
Recently VPC patch has been applied in our EBS environment (12.1.2) which has impacted tables being used for APCC BI reports.
We understand that many tables are deleted or modified as part of this patch, we have already raised SR on this SR# 3-6360377661, please refer to this for more details.
Below is the list of materialized views delted:
MSC_CALENDAR_DTL
MSC_PHUB_FISCAL_PERIODS_MV
MSC_PHUB_FISCAL_QUARTERS_MV
MSC_PHUB_FISCAL_YEARS_MV
MSC_PHUB_MFG_CAL_DATES_MV
and some of the columns deleted from below tables:
MSC_RESOURCES_F (owning_department_id,category_set_id,sr_category_id)
We understand that many tables are deleted or modified as part of this patch, we have already raised SR on this SR# 3-6360377661, please refer to this for more details.
Below is the list of materialized views delted:
MSC_CALENDAR_DTL
MSC_PHUB_FISCAL_PERIODS_MV
MSC_PHUB_FISCAL_QUARTERS_MV
MSC_PHUB_FISCAL_YEARS_MV
MSC_PHUB_MFG_CAL_DATES_MV
and some of the columns deleted from below tables:
MSC_RESOURCES_F (owning_department_id,category_set_id,sr_category_id)
0