How to generate FRD trace

##############################################
STEPS TO TAKE FRD TRACE IN 11.5.10 AND R12
##############################################

Solution
----------
In 11i
------

1.   Login to your Instance Unix session as Apps.

2.   Login to System Administrator Responsibility in Oracle Applications.

3.   Add the following profile to the USER LEVEL as follows

(e.g.)  ICX: Forms Launcher = http://celalnx32.us.oracle.com:10403/dev60cgi/f60cgi?&record=collect&log=ABC.log

4.    Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.

5.    Reproduce the Forms-Issue.

6.    Exit the application.

7.    Locate the file in the directory set by variable $FORMS_TRACE_PATH.



In R12
------

1. Login to your Instance .

2.Copy the value for the profile 'ICX: Forms Launcher' from Site level.

3. Append the copied value with the "?record=collect" and paste it at the user level field.
(Eg):http://celalnx20.us.oracle.com:10106/forms/frmservlet?record=collect

4. Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.

5. Go to Help->About Oracle Applications, go to the section 'Forms Server Environment Variables'
There you should see a value in FORMS_TRACE_DIR. Note down the value.

6. Reproduce the Issue.

7. Now you get the FRD trace from the file located in the directory noted in FORMS_TRACE_DIR.


Note: By default, this directories named as forms_<pid>.trc where pid is the process identifier.
Collect _<form_process_id>

for ex:

here i collected for user UK10 in ORQ3 by setting the ICX: Forms Launcher profile at user level.. and the log will be created at
$LOG_HOME/ora/10.1.2/forms/collect_value
ex: collect_31731
 --------------------------------------------------------------------------------------------------------
                                                                                   OR
--------------------------------------------------------------------------------------------------------

The steps I have followed :-
1. Login as oracle application user
2. Go to $FND_TOP/secure
3. java oracle.apps.fnd.security.AdminAppServer apps/ \AUTHENTICATION ON DBC=
Please check the below example :-
4. java oracle.apps.fnd.security.AdminAppServer apps/ffdev21 \AUTHENTICATION ON DBC=ffus.com_ffus.dbc
Output will be :-
AUTHENTICATION ON executed successfully – ffus.com_ffus.dbc
5. In the command prompt echo $FORMS60_TRACE_PATH
It will give you the trace path. Make sure the path is set.
6. Open internet explorer
Type the url below :-
http://:/dev60cgi/f60cgi/?&record=collect&log=$FORMS60_TRACE_PATH/
even you can change =$FORMS60_TRACE_PATH and can have your own path but make sure that path has got read and write permission .It is advisable to have default path.
Example is below :-
http://ffus.com:8000/dev60cgi/f60cgi/?&record=collect&log=$FORMS60_TRACE_PATH/faoracle.frd
Now you can generate FRD trace depend upon your situation
It will generate FRD trace file in your $FORMS60_TRACE_PATH directory with the name supplied by you in URL.
After finishing the the entire task make sure that you disable the trace :-
The steps are as follows:-
Note :- It has got security issues ,so make it disable.
1.Login as oracle application user
2.Go to $FND_TOP/secure
3. java oracle.apps.fnd.security.AdminAppServer apps/ \AUTHENTICATION OFF DBC=
4. java oracle.apps.fnd.security.AdminAppServer apps/ffdev21 \AUTHENTICATION OFF DBC=ffus.com_ffus.dbc
Output will be :-
AUTHENTICATION OFF executed successfully – ffus.com_ffus.dbc
Alternative Steps:
Backup and open $APPL_TOP/admin/_.xml context file
2. Update the context variable:
s_appserverid_authentication
By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF
Make it ON
3. Run Autoconfig to instantiate the change.
You should now be able to access forms directly again using the f60cgi call.
4. After you have finished your Forms debugging, please reset
s_appserverid_authentication to SECURE and re-run Autoconfig
or Refer this link