R12.2.8 : unable to compile views due to insufficient privileges error
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