I want to create a report in OEM 12c Cloud Control in Information Publisher. I have select element as "Table from SQL" and want to select data from "gc$metric_values_latest" view. But when I am writing a sql statement like..
select * from gc$metric_values_latest
Then on execution I am getting the following error "Error rendering element. Exception: ORA-00942: table or view does not exist "
Is this mean that we can not fetch data from gc$metric_values_latest view or we need to do some configuration in order to fetch information from this view. Because I am able to fetch from views like mgmt$metric_current or mgmt$metric_history
So what can be the probable cause of not getting access to gc$metric_values view