ATP Data Collections Fails After 12.2.6.1 Upgrade (Doc ID 2240819.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

QUESTION #1
We have upgraded to 12.2.6.1 one of our instances for test purpose.
MSC: Source Setup Required is set to Yes.
Latest recommended patches ARE applied.
However, tThe first ATP Data Collections trying to setup GOP is failing in 'Collections Views' and a few 9 other View creation concurrent requests
from Create Collections Setup Views to Create Collections Repair Order Views

Each request to create views errors on the very first view it tries to create with error like

***** Creating View MRP_AP_BILL_OF_RESOURCES_V ********
 from CRP_BILLS_OF_RESOURCES x
  *
ERROR at line 11:
ORA-01720: grant option does not exist for 'CRP.CRP_BILLS_OF_RESOURCES#'

Other views that errored were

***** Creating View MRP_AP_DESIGNATORS_V ********
***** Creating View MRP_AP_CATEGORY_SETS_V ******
******* Creating View MRP_AP_ASSIGNMENT_SETS_V ********
***** Creating View MRP_AD_ERO_WIP_JOB_SUPP_V ********
***** View MRP_AD_ROUTINGS_V ********
***** Creating View MRP_AP_CAL_WEEK_START_DATES_V ********
***** View MRP_AD_MPS_SUPPLIES_V ********
***** View MRP_AD_WIP_JOB_SUPPLIES_V ********

It appears that this could happen on any views
 
QUESTION #2
MSRFWOR: Refresh Collection Snapshots
is failing with this error

Let e know whether I should open another SR for this.
**Starts**07-FEB-2017 12:32:23
**Ends**07-FEB-2017 12:35:35
ORA-12048: error encountered while refreshing materialized view "APPS"."BOM_BOMS_SN"
ORA-30372: fine grain access policy conflicts with materialized view
ORA-06512: at "APPS.FND_CORE_LOG", line 45
ORA-06512: at "APPS.FND_CORE_LOG", line 462
ORA-06512: at "APPS.FND_PROFILE", line 61
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT", line 5
ORA-06512: at "APPS.MRP_SN_BOMS_T1", line 3
ORA-04088: error during execution of trigger 'APPS.MRP_SN_BOMS_T1'
ORA-12048: error encountered while refreshing materialized view "APPS"."BOM_BOMS_SN"
ORA-30372: fine grain access policy conflicts with materialized view

Database Server
----------------------------------------
RDBMS : 12.1.0.2.0
Oracle Applications : 12.2.6
 

Solution

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