EBS R12如何对单个报表进行trace

最新推荐文章于 2018-11-25 22:51:50 发布

cuixie2370

最新推荐文章于 2018-11-25 22:51:50 发布

阅读量121

点赞数

EBS R12.1.3

以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博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1151543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1151543/