ORACLE EBS中快速查看某个Request的Output File或log等信息

浏览数：22 / 时间：2015年06月12日

项目上，经常有请求报红报黄等问题反映到技术顾问这边，但是由于某些权限的限制，有时候哪怕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就可以看到了.