How To Get The SQL Executed By A Framework Page
Last updated on MARCH 08, 2017
Applies to:Oracle Applications Framework - Version 184.108.40.206 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 27-AUG-2013
Let's say you are using a framework page and you are missing some data from an LOV or you can't see the data you'd expect to see on the framework page. One of the first things you might want to do is check what SQL being run by the page and the data being pulled in to it. How do you get the SQL? There are so many different techniques that you can use to do this and in this document I will show the one I have found works best.
How to get the SQL executed by a framework page?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms