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就可以看到了.