eBS: Enabling forms runtime diagnostics trace (FRD)

To enable forms diagnostics with e-business 11i, in a situation where forms does not open, for example after a platform migration, proceed as follow:

First check that value for the ICX:Forms launcher profile option, probably with the ids specified below. Correct as you go, depending the version and the environment history:

SELECT profile_option_value
FROM fnd_profile_option_values
WHERE level_id            = 10001
  AND profile_option_id   = 3769
  AND level_value         = 0
;

Then update the profile option, at the site level, for convenience.

UPDATE fnd_profile_option_values
SET profile_option_value = 'http://<ebs_url>/dev60cgi/f60cgi?record=all'||CHR(38)||'log=record.log'
WHERE level_id           = 10001
 AND profile_option_id   = 3769
 AND level_value         = 0
;
COMMIT
;

Then launch a forms and check that there is a record.log trace file in $ORACLE_HOME/forms60/log

Once your troubleshooting time is done, revert the profile option to the original value.