Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

EM 13c: Custom Information Publisher Report: Error rendering element. Exception: ORA-00942: table or view does not exist

Sean AugustDec 27 2023 — edited Dec 27 2023

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?

Thanks

Comments
Post Details
Added on Dec 27 2023
0 comments
35 views