Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Tuesday, April 16, 2013

Query to find Last Query executed on the form


List the invoices for Trading Partner 'CDS, Inc' from the application.

Payables Manager > Invoices > Inquiry > Invoices > give "CDS, Inc" in the Trading Partner Name field > Find

Now we want to find the database query executed in the backend to show this data for you. Then goto

NAVIGATION:

Help > Diagnostics > Examine
Enter the following values:
Block: SYSTEM
Field: LAST_QUERY

Value filed displays the Query for you.
Copy the query and executed in SQL Developer/TOAD/SQL Plus to check the same data!


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)