If you are new here, you may want to subscribe to the following feeds How to see the SQL behind DBI self service pages?
Written by Nilesh JethwaWith the Oracle Forms, it is easy to see behind the forms which view/table is involved. You can also see how the columns are mapped to the fields on the forms.
This became an issue when the self service html forms started dominating the scene. One of the reason I hate the self service pages is there is no easy way to see the SQL code behind, atleast there was no mechanism provided by Oracle to do this in a easy way.
Recently, I came to know the trick to see the code behind Daily Business Intelligence Financial Pages. All you have to do is set the following profiles.
FND: Debug Log Enabled to Yes
FND: Debug Log Level to Error
FND: Debug Log Module to BIS%
This might work for other modules too but not sure yet. This does not mean I am going to change my opinion about self service applications. The UI is the worst if you compare it to the GUI forms - Ugly long URLs in the browser - Takes far more number of mouse clicks and page navigations to get things done compared to the GUI forms.
Posted in DBI |
2 Comments to “How to see the SQL behind DBI self service pages?”
Leave a Comment
Free Dashboards and KPI examples
March 29th, 2007 at 4:35 pm
Hi Niliesh,
If you want to see the code behind the DBI pages.
Just goto “Daily business intelligence Administrator” responsibility
and click on “Enable/Disable Debugging”
Now open the page and see view source.
It will give you the query with the parameters to be replaced with bind variables.
Thanks
kittu
March 29th, 2007 at 5:12 pm
Hi Kittu,
Thanks for the tip. I will remember and use this.
Regards
Nilesh