<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Technical Articles arrow Miscellaneous Technology arrow Debug Forms in Oracle eBusiness Suite
This website has now moved to http://apps2fusion.com

Debug Forms in Oracle eBusiness Suite | Print |  E-mail
Written by Anil Passi   
Thursday, 01 November 2007
It’s hard to be a complete Oracle Applications Consultant, unless you know the enough tricks
to debug Oracle eBusiness Suite. Some of the debugging techniques in EBS are documented,
but yet many of the very practical debugging techniques aren’t documented anywhere.

This article is the third in the series of debugging techniques that I would like to explain.
The previous articles on debugging can be referenced using these links
1. Understanding Common FND Logging
2. Seven different techniques to debug OA Framework

In this article, we will see PowerPoint presentations to debug Oracle Forms in eBusiness Suite.

Where do we start?
If you wish to debug and know SQL & DML Statements that get executed from Oracle Form,
then it is best to run the SQL*Trace for that forms session. However you must keep in mind
that pl/sql statements like IF THEN ELSE etc never get captured in the SQL*Trace.
To debug those, you are at the mercy of there being enough FND_Log messages that exist
to capture execution points.

What are the various techniques that can be applied to debug Oracle Forms?
1. Run SQL Trace to debug Oracle Forms.
Have a look at this PowerPoint presentation for a practical example.
In this example, we try to answer a question such as “Why that LOV [List of Values in EBS D2K screen] not bringing back the desired records”?
Click here to see the presentation for the demo of this technique

2. How to find out the last SQL statement that was fired when Execute Query was executed on a block.
Click here to see the presentation for the demo of this technique

3. Use FND Logging to debug messages in Oracle form Triggers and in the attached pll files.
This technique will also give you insight of the debug messages generated from Pl/SQL or Workflows or business events, in
case any of these were invoked as a result of an action in Oracle Forms.
Understanding Common FND Logging

There are further techniques that can be applied [like those based on FND_Messaging], but I shall discuss those in future series of debugging articles.

Comments (2)add
How to Upgrade Forms 6i to Forms 10G
written by Sachin Goel , November 28, 2007

Can you please provide me any documentation and training material for Oracle Forms 6i upgrade to Oracle Forms 10G.

Thanks & Regards
Sachin Goel
written by laksh , February 26, 2008

can you please provide me the documentation and ppt for oracle forms 6i and it should cover all the basics of forms....

You must be logged in to a comment. Please register if you do not have an account yet.