ORA-00904 When Run Any AWR or ASH Reports From SQL Developer
(Doc ID 2518648.1)
Last updated on APRIL 28, 2020
Applies to:Oracle SQL Developer - Version 18.1 and later
Information in this document applies to any platform.
When attempt to run any AWR or ASH reports from SQL Developer 18.x, you get the following error:
ORA-00904: "DBMS_WORKLOAD_REPOSITORY"."AWR_SQL_REPORT_HTML": invalid identifier
00904. 00000 - "%s: invalid identifier"
Vendor code 904
However, you can access the database to run queries using other SQL commands. The problem is only when you try to access DBA functions such as AWR or ASH. You already verified that you have Oracle Diagnostics Pack to run the AWR or ASH report.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document