以sysadmin登录， 职责 system administrator -> Concurrent -> Program -> Define -> F11 -> 
在Program栏位输入报表名称如 HW AR Accounts Receivable Balance Report -> CTRL+F11 -> 查询
出来后点击左下方的check box : Enable Trace -> 点击菜单下的保存图标 -> 退出后以选择合适的
职责提交一个request，报表名选择以上修改的报表，运行后查看数据库user_dump_dest对应的目录
下的含有此request_id 的 trc 文件，并使用如下格式化命令进行转化： 

tkprof  xxx.trc  xxx.txt  explain=apps/apps_passwd  sort='(prsela,exeela,fchela)'  

参考： How To Trace From Form, Report, Program And Others In Oracle Applications (文档 ID 130182.1)

5. TRACING A REPORT
-------------------

Beginning rel 11.x that becomes easy to activate database trace for a single report. You just need to check trace option box in concurrent program definition (under System Administrator responsability).

If trace option is not available or you report is customized you can insert an 'alter session set sql_trace=TRUE' in it to activate database trace.

Principle is to :
- make a copy of your report
- generate a .rex file from .rdf (by command r25convm or r25conv32,
see respectively Note:1070541.6 and Note:1020489.102)
- edit the .rex file and insert the line immediately after ('FND SRWINIT'); :
srw.do_sql('alter session set sql_trace=TRUE');
- insert another line immediately after ('FND SRWEXIT'); to stop tracing :
srw.do_sql('alter session set sql_trace=FALSE');
- regenerate the .rdf file

See excellent Note:1019231.6 for complete procedure.

本文转自ITPUB博客tolywang的博客，原文链接：EBS R12如何对单个报表进行trace，如需转载请自行联系原博主。