EBS R12如何對單個報表進行trace

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.