EBS R12怎么对单个报表进行trace

本篇内容主要讲解“EBS R12怎么对单个报表进行trace”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“EBS R12怎么对单个报表进行trace”吧!

以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.

到此，相信大家对“EBS R12怎么对单个报表进行trace”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！