EBS R12怎么對(duì)單個(gè)報(bào)表進(jìn)行trace

本篇內(nèi)容主要講解“EBS R12怎么對(duì)單個(gè)報(bào)表進(jìn)行trace”，感興趣的朋友不妨來看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強(qiáng)。下面就讓小編來帶大家學(xué)習(xí)“EBS R12怎么對(duì)單個(gè)報(bào)表進(jìn)行trace”吧!

以sysadmin登錄， 職責(zé) system administrator -> Concurrent -> Program -> Define -> F11 ->
在Program欄位輸入報(bào)表名稱如 HW AR Accounts Receivable Balance Report -> CTRL+F11 -> 查詢
出來后點(diǎn)擊左下方的check box : Enable Trace -> 點(diǎn)擊菜單下的保存圖標(biāo) -> 退出后以選擇合適的
職責(zé)提交一個(gè)request，報(bào)表名選擇以上修改的報(bào)表，運(yùn)行后查看數(shù)據(jù)庫(kù)user_dump_dest對(duì)應(yīng)的目錄
下的含有此request_id 的 trc 文件，并使用如下格式化命令進(jìn)行轉(zhuǎn)化：

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.

到此，相信大家對(duì)“EBS R12怎么對(duì)單個(gè)報(bào)表進(jìn)行trace”有了更深的了解，不妨來實(shí)際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！