Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
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.

Anil Passi


0 #1 Sachin Goel 2007-11-28 20:46

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

Thanks & Regards
Sachin Goel
0 #2 laksh 2008-02-26 08:52

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

Than ks

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner