This discussion is archived
3 Replies Latest reply: Aug 22, 2013 6:27 AM by Abdul Wahid RSS

How to find exact query executed by reports with parameters

Abdul Wahid Pro
Currently Being Moderated


I am running a report which errors out with below log messages.


REP-0004: Warning: Unable to open user preference file.

REP-0300: ORACLE error occurred.

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-300: ORACLE error occurred.


In toad, the query is not giving any error message.

I want to know what exact query is being executed by oracle report server.

How can I find exact query executed?


Abdul Wahid


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