How To Get The SQL Executed By A Framework Page (Doc ID 556491.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Applications Framework - Version 11.5.10.0 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

Goal

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?


Solution

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