Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Behind Oracle Reports (EBS 12.1 Unix)
SQL Behind Oracle Reports [message #400920] Thu, 30 April 2009 06:57
urwethe
Messages: 11
Registered: November 2008
Location: New Jersey
Junior Member
Hi,
How can I find the SQL code that runs behind any given Oracle report from my client PC?

For example, in some of the on-line lookup applications, after looking up information,
I can select
Help/Diagnostics/Examine

Block: SYSTEM
Field: Last_Query

and this will return the SQL statement that happens behind the scenes.

I want to accomplish the same thing, perhaps from a log file, that shows me the SQL that is generated when a report is run.

Smile
Previous Topic: Users can access only those selected Items from many items
Next Topic: Applications not working...
Goto Forum:
  


Current Time: Mon Dec 05 05:00:24 CST 2016

Total time taken to generate the page: 0.07758 seconds