How to Find Last Query in Forms and OAF |Oracle E-Business Suite

Find Last Query executed in form and OAF Page.

Let us check in Forms

The data presented in forms and Oaf page is through database query only, so if you want to find the database query which was executed to get the data then you need to follow the below steps.  

è Open the form and query the record.

è Then go to HELPà DiagnosticsàExamine.

è Then Search for the block name as  “SYSTEM” and field as “LAST_QUERY”

è We can also check the query executed in each block, follow the below steps to check the same.

You will get the below window

Now change the Object to “BLOCK” and select object1 as your block name for e.g. “TGW_HEADER”.

After selecting the object 1 name you will get the last_query performed in the value column.

Now let us check in the OAF Page.

è For checking the last query in OAF, you need to enable the profile option’s.

è Below are the profile options in OAF.

PROFILE NAME	VALUE
Personalize Self-Service Defn	Yes
FND: Personalization Region Link Enabled	Yes
Disable Self-Service Personal	No

If you enable above profile options, you will be able to find the “About this Page” and “Personalization” links in your OAF page.

Now click on the “About this Page” Link, then you find the below page.

Now click on the “Expand All”. It will display all the items in the page and the query used to display those item values.

In OAF a database query is called as VO, VO stands for View Object.

Now on the View Object link then it will display the query used to get the values.