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”有了更深的了解，不妨來實際操作一番吧！這里是億速云網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！