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
- 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
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 184.108.40.206.1 (Production)
PL/SQL Version 220.127.116.11.0 (Production)
Oracle Virtual Graphics System Version 18.104.22.168.0 (Production)
Oracle Multimedia Version 22.214.171.124.1 (Production)
Oracle Tools Integration Version 126.96.36.199.0 (Production)
Oracle Tools Common Area Version 188.8.131.52.0
Oracle CORE Version 184.108.40.206.0 – Production
TSE Startup Time : 1230616643390353000
TSE Handshake Duration : 1230616643393408000
##### CTIME STARTS HERE
WINDOW NONAME START START
Opened file: /slot/ems1978/appmgr/hz1mq100appl/fnd/11.5.0/forms/US/FNDSCSGN.fmx
ON-LOGON Trigger Fired:
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 !!
2 thoughts on “Forms Runtime Diagnostics – Oracle Apps 11i”
Very good article. Thanks for providing such great tip.
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!