Debugging Reports in EBS

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;