This discussion is archived
5 Replies Latest reply: Oct 25, 2012 11:15 PM by Roshni Shankar RSS

Facing error while creating report in OEM 12c Cloud Control

Roshni Shankar Newbie
Currently Being Moderated
Hi All,

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 "

What can be the issue for this. Please suggest..

Thanks in Advacnce!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points