| View SQL statements underlying forms [message #95694] |
Fri, 09 April 2004 03:57  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
