eBS 11i: Enabling Forms Runtime Diagnostics Trace

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.

 

 

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s