Running through the tutorial “Creating Time Series Calculations in Analytic Views” I hit ORA-00942 “Table or view does not exist”.
My user can select from the tables as expected e.g. av.sales_fact so I suspect the underlying setup is missing direct tab privs?
This is supported by a lack of direct table privs and only roles. This impacts all the statements to create PLSQL objects.