Creating an Enterprise Manager (EM) 13c 13.5.16 Cloud Control Information Publisher report with a custom query that queries the em_lms_dba_featu_usage_stat table gives the following error:
"Error rendering element. Exception: ORA-00942: table or view does not exist ".
Example of such query:
SELECT * FROM EM_LMS_DBA_FEATU_USAGE_STAT table;
The query runs perfectly fine when executing it on the server from the repository database, but when trying to run it from Information Publisher from the Elements tab, it throws the above error message?