How to find object name given in a problematic query
The AWR report will contain the SQL_ID.  You can query V$SQL with this to locate additional metadata such as the MODULE, ACTION, PARSING_USER_ID.  Also, if the SQL came from a stored procedure, the PROGRAM_ID, PROGAM_LINE# columns point to the (stored procedure) object concerned.

I've got an example of the latter on my blog

https://connor-mcdonald.com/2016/01/20/problematic-sql-plsql-is-your-friend/