My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.