Thursday, February 25, 2010

How does one enable trace for all actions that occur for a user?

The instructions for enabling the event trace follow:
a. First enable trace for a specific user:
- Bring up the Core application - System Administrator responsibility
- Move to Profile/System
- Check off the USER box - and enter your username that you are using when getting the error
- Search on the following profile option - 'Initialization SQL Statement - Custom'

Please set this at the user level with the following string:
BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET
TRACEFILE_IDENTIFIER='||''''|| '4269824.999' || '''' || ' EVENTS =' || '''' || ' 10046 TRACE NAME
CONTEXT FOREVER, LEVEL 12 '|| ''''); END;

(Cut and paste the above sql statement into the User Level profile option: "Initialization SQL - Custom")
This must be one complete line of text - so may be best to copy the string into notepad prior to putting it into the profile.

b. Once the profile is set, please change responsibilities and directly go and reproduce the problem.
To locate the trace file, use the following sql in sqlplus:
SQL> select name, value from v$parameter where name like 'user_dump_dest';

c. Note that a similar technique can be used for enabling trace with binds for a user in SQL*Plus. The commands would look like the following:
SQL> ALTER SESSION SET TRACEFILE_IDENTIFIER='577' EVENTS ='10046 TRACE NAME CONTEXT FOREVER,LEVEL 12';
SQL> select 'x' from dual; -- or any SQL that you want to trace
SQL> alter session set sql_trace = false;

3 comments:

  1. Thanks for sharing for more information visit
    CALFRE

    ReplyDelete
  2. I have just read your site, Very interesting to read this article, If you are looking for best Oracle financials low price of fee for on-line coaching.
    Oracle fusion financials training

    ReplyDelete
  3. Casino & Resort - Mapyro
    Casino & 성남 출장마사지 Resort in Cherokee. View reviews, hours, directions, opening hours and contact information for Casino & Resort in Cherokee, What are the check-in and check-out 군포 출장안마 times at Casino & Resort?Can I cancel my winnings for free at Casino & Resort and play 김해 출장마사지 your favorite 구리 출장샵 slots 김제 출장마사지 games?

    ReplyDelete