如何查詢某個 request 輸出檔案
資料來源:這裡
SELECT fnd_webfile.get_url(4, 21345489, 'APPLSYSPUB/PUB', 'FCWW', 10) FROM dual; |
第一個參數4表示request的output,(可根據需要決定)
/* Define file types for get_url */
process_log constant number := 1;
icm_log constant number := 2;
request_log constant number := 3;
request_out constant number := 4;
request_mgr constant number := 5;
frd_log constant number := 6;
generic_log constant number := 7;
generic_trc constant number := 8;
generic_ora constant number := 9;
generic_cfg constant number := 10;
context_file constant number := 11;
generic_text constant number := 12;
generic_binary constant number := 13;
request_xml_output constant number :=14;
第二個參數是request_id
第三個參數是環境參數GWYUID
第四個參數是two_task,
第五個參數是url有效的分鐘數.
然後就是把這個url複製到ie就可以看到了.