標籤：
ORACLE EBS中快速查看某個Request的Output File或log等資訊
項目上，經常有請求報紅報黃等問題反映到技術顧問這邊，但是由於某些許可權的限制，有時候哪怕System Administrator職責也只能看到某個Request資訊，但是不能查看它的Output File。用下面這個方法可以很方便地查看請求的輸出和日誌等資訊，甚至不用進系統就可以查看了，只需要一個請求編號就可以：
Sql代碼
- /* Function: GET_URL
- *
- * Purpose: Constructs and returns the URL for a Concurrent Processing
- * log or output file.
- *
- * Arguments:
- * file_type - Specifies the type of file desired:
- * fnd_webfile.process_log = The log of the concurrent process identified by the parameter ID.
- * fnd_webfile.icm_log = The log of the ICM process identified by ID.
- * Or, the log of the ICM process that spawned
- * the concurrent process identified by ID.
- * Or, the log of the most recent ICM process
- * if ID is null.
- * fnd_webfile.request_log = The log of the request identified by ID.
- * fnd_webfile.request_out = The output of the request identified by ID.
- * fnd_webfile.request_mgr = The log of the concurrent process that ran the request identified by ID.
- * fnd_webfile.frd_log = The log of the forms process identified by ID.
- * fnd_webfile.generic_log = The log file identified by ID.
- * fnd_webfile.generic_trc = The trace file identified by ID.
- * fnd_webfile.generic_ora = The ora file identified by ID.
- * fnd_webfile.generic_cfg = The config file identified by ID.
- * fnd_webfile.context_file= Applications Context file identified by ID.
- * fnd_webfile.generic_text= Generic file using text transfer mode.
- * fnd_webfile.generic_binary = Generic file using binary transfer mode.
- * fnd_webfile.request_xml_output = The xml output of Concurrent Request.
- *
- * id - A concurrent process ID, concurrent request ID, or file ID
- * depending on the file type specified.
- * For fnd_webfile.context_file,fnd_webfile.generic_text,
- * fnd_webfile.generic_binary this value is null.
- * gwyuid - The value of the environment variable GWYUID used in constructing the URL.
- * two_task - The database two_task, used in constructing the URL.
- * expire_time - The number of minutes for which this URL will remain valid.
- * source_file - Source file name with full patch
- * source_node - Source node name.
- * dest_file - Destination file name
- * dest_node - Destination node name
- * page_no - Current page number
- * page_size - Number of lines in a page
- * Returns NULL on error. Check the FND message stack.
- */
- FUNCTION GET_URL(FILE_TYPE IN NUMBER,
- ID IN NUMBER,
- GWYUID IN VARCHAR2,
- TWO_TASK IN VARCHAR2,
- EXPIRE_TIME IN NUMBER,
- SOURCE_FILE IN VARCHAR2 DEFAULT NULL,
- SOURCE_NODE IN VARCHAR2 DEFAULT NULL,
- DEST_FILE IN VARCHAR2 DEFAULT NULL,
- DEST_NODE IN VARCHAR2 DEFAULT NULL,
- PAGE_NO IN NUMBER DEFAULT NULL,
- PAGE_SIZE IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
Sql代碼
- SELECT FND_WEBFILE.GET_URL(4, --輸出類型
- 3615219, --請求編號
- ‘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就可以看到了.
ORACLE EBS中快速查看某個Request的Output File或log等資訊(轉)
