When you try to take the query from the Administration Tab we used to get an error like No Log Found.
In order to see our query we have to set the log level to 7 in RPD.
Setting Log Level in RPD:
We have to check the Logging Level in three places in RPD.
Step 1 : Open RPD by using the credentials.
Step 2 : Go to Tools–>Options–>Repository
Here set the Log Level to 7 in System Logging Level.
Step 3 : Go to Manage–>Identity–>weblogic and set the Logging level to 7 here.
Step 4 : Sometimes we used to define the Log Level in Initialization Blocks.
Go to Variables–>Session–>Initialization Blocks–Log Level.
Edit the Data Target and set the Log Level to 7.