Home » Applications » Oracle Fusion Apps & E-Business Suite » View SQL statements underlying forms
View SQL statements underlying forms [message #95694] Fri, 09 April 2004 03:57 Go to next message
SANDY
Messages: 60
Registered: April 1998
Member
How can I view the SQL statements that are running behind a specific form in Oracle applications 11?  I do not have access to trace files in oradata/.../udump.  Client is XP. 
Re: View SQL statements underlying forms [message #95714 is a reply to message #95694] Mon, 19 April 2004 09:15 Go to previous message
Eric G.
Messages: 32
Registered: November 2003
Member
Sandy,

You can often find the underlying SQL from a form through the EXAMINE function.

A little article on page 6 of the March 2004 Atlanta Oracle Apps Users Group newsletter,
"How to get a base table or view from a screen where “Record History” is not available", lists the steps nicely:

- Click ‘Help’ from the menu, and ‘Examine’.
- Enter the ‘APPS’ password.
- Select ‘system’ for ‘block’ and ‘last_query’ for ‘field’.
- The ‘value’ will display a query that shows the base table or view.

The web address for this newsletter is:
http://www.atloaug.org/newsletters/AtloaugNews2004Mar.doc
Previous Topic: Oracle Financial GL/AP, OFA, Oracle ADI Network latency requirement
Next Topic: ERP Request
Goto Forum:
  


Current Time: Thu Mar 28 13:33:50 CDT 2024