DBA in the Trenches

Set the following to get a tracefile: SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); Need to run this on the Database Tier select p.value from v$parameter p where 1=1 and p.name like 'user_dump_dest'; tkprof input.trc output.prf EXPLAIN=apps/apps SYS=NO You can know use this in a before report trigger srw.user_exit('FND SRWINIT');   srw.message(200,'XX_DEBUG_PRINT:'||fnd_profile.value('XX_DEBUG_REP'));  if (nvl(fnd_profile.value('XX_DEBUG_PRINT'),'N') = 'Y') then      SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); end if;