Hardik’s Info

One can enable user level trace using following steps for any Self Service Web Applications…

1. Change profile value ‘Initialization SQL Statement - Custom’ at user level to below string,

BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||'your_identifier' ||''''||' EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 '||''''); END;

2. Reproduce the issue 3. Trace file can be found at the location given by following query,

SQL> select name, value from v$parameter where name like 'user_dump_dest';

4. Search for the file name having ‘your_identifier’
5. Remove the profile value once you are done
6. Generate tkprof for the given trace file

For more details, please refer Metalink Note 296559.1

- Hardik

Share This

Technical
Posted by Hardik

This entry was posted on Monday, March 5th, 2007 at 5:14 pm and is filed under Technical. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.