Wednesday, July 29, 2009

How to enable user’s Trace in EBusiness Suite?

  1. Login to Ebusiness Suite and Select System Administrator Responsibility
  2. Set profile for particular user i.d. JAISINGH Go to 'System Responsibility' à Profile à System
  3. Set profile 'Initialization SQL Statement – Custom' at user level to

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

  4. Exit application after change
  5. Ask user to produce issue
  6. Go to db parameter user_dump_dest location and search for *JHSINGH*.trc

Reference: Meatlink Note 787724.1

No comments: