Forms Runtime Diagnostics – Oracle Apps 11i

Many times we face issue with the form and we have to carry out the debugging at runtime as we give input to the form. This kind of situations can be handeled easily using FRD (Forms Runtime Diagnostics). This feature is available in 11i as well as in R12. In this post we will see how to enable the diagnostics and view the trace files in Oracle Apps 11i. You can also check one of my old post about generating forms trace files in Oracle E-Business Suite R12.

The following method applies to 11.5.10 and above.

Step 1) Check the value of “ICX:Forms launcher” profile option.

Current value set for this profile in my environment is : http://rws60090rems.us.oracle.com:8078/dev60cgi/f60cgi

Step 2) Append the ICX:Forms launcher profile value with the “Forms Runtime Diagnostics (FRD)” variables. Following are the different variables available in FRD

  • record=all
  • config=debug
  • log=<logfile path>

So the new “ICX: Forms Launcher” profile value will become : http://rws60090rems.us.oracle.com:8078/dev60cgi/f60cgi?record=all&log=/tmp/avdeo_frd.log

Step 3) Close the forms and then go to the home page and open the form you want to work upon. No need to bounce the forms services.

Once you open the form you will see the dialog as shown below

untitled

Also you will be able to see the trace file at the location given by variable “log=” In my case the trace file is present in /tmp directory.

The content of the trace file is as shown below

===================================================================

Forms Runtime Performance/Diagnostics Collection
File Name: /tmp/avdeo_frd.log
Process ID: 29403
Client IP: 10.176.87.235:50951
Forms 6.0 (Forms Runtime) Version 6.0.8.24.1 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Multimedia Version 6.0.8.20.1 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 – Production

TSE Startup Time : 1230616643390353000
TSE Handshake Duration  : 1230616643393408000
##### CTIME STARTS HERE
# C
WINDOW NONAME START START

Opened file: /slot/ems1978/appmgr/hz1mq100appl/fnd/11.5.0/forms/US/FNDSCSGN.fmx

ON-LOGON Trigger Fired:
Form: FNDSCSGN

State Delta:
FORM FNDSCSGN
STATUS     NEW
BLOCK PROGRESS_INDICATOR
STATUS     NEW
RECSTATUS  “”
FIELD TEXT
CANVAS     PROGRESS_INDICATOR
GEOMETRY   100,250:4000,400
ENABLED    TRUE
NAVIGABLE  TRUE
INSERTABLE TRUE
QUERYABLE  TRUE
UPDATEABLE TRUE
FIELD PERCENT_COMPLETE
CANVAS     PROGRESS_INDICATOR
.

.

===================================================================

If you don’t give the variable “log=” in “ICX:Forms Launcher” profile option then the trace file will be located in $FORMS60_TRACE_PATH location.

Hope this helps !!

About these ads

2 thoughts on “Forms Runtime Diagnostics – Oracle Apps 11i

  1. Intimately, the post is actually the freshest on that laudable topic. I match in with your conclusions and also will certainly thirstily look forward to your approaching updates. Just saying thanks definitely will not just be enough, for the excellent lucidity in your writing. I can immediately grab your rss feed to stay informed of any kind of updates. Solid work and also much success in your business enterprize!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s