OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Behind Oracle Reports (EBS 12.1 Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 09:15:48 CDT 2024