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 22.214.171.124.1 (Production)
PL/SQL Version 126.96.36.199.0 (Production)
Oracle Virtual Graphics System Version 188.8.131.52.0 (Production)
Oracle Multimedia Version 184.108.40.206.1 (Production)
Oracle Tools Integration Version 220.127.116.11.0 (Production)
Oracle Tools Common Area Version 18.104.22.168.0
Oracle CORE Version 22.214.171.124.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 !!