Technology Stack - EBS (MOSC)

MOSC Banner

R12.2.8 : unable to compile views due to insufficient privileges error

edited Jan 16, 2019 4:02AM in Technology Stack - EBS (MOSC) 6 commentsAnswered

Hello,

We have upgraded from R12.1.3 to R12.2.8.    After upgrade,  the environment was fine.    However,  now we find lot of  invalid views in our database.     These views was valid  after the upgrade but turned invalid    When we are trying to compile the views we are getting

select name,text from dba_errors where text like '%1031%;

WIP_CUMULATIVE_SCRAP_V

ORA-01031: insufficient privileges

MRP_LINE_SCH_AVAIL_V

ORA-01031: insufficient privileges

CSD_EID_REPAIRS_V

ORA-01031: insufficient privileges

There are around 100 views with same error .   Tried the following.   

Bounced database

executed recreate grants and synonyms from adadmin

Please let us know, how to resolve this issue

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