项目上,经常有请求报红报黄等问题反映到技术顾问这边,但是由于某些权限的限制,有时候哪怕System Administrator职责也只能看到某个Request信息,但是不能查看它的Output File。用下面这个方法可以很方便地查看请求的输出和日志等信息,甚至不用进系统就可以查看了,只需要一个请求编号就可以:
/* 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;
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就可以看到了.
相关推荐
OracleEBS中文数据字典
Oracle EBS中文数据字典.pdf
Oracle EBS 操作手册
Oracle EBS R12中的配置文件及中文说明
ORACLE EBS查看库存现有量SQL
此针对于oracle ebs的值集进行详细的讲解
Integrating_EBS_with_Oracle_Internet_Directory_and_Oracle_Single_Sign-On Oracle EBS 单点登录 方案
Oracle EBS中费用性采购的介绍
这是一份完整的Oracle ebs 项目制造模块培训文档,可以了解Oracle ebs 项目制造模块(PJM)的所有功能及流程。
ORACLE EBS R12 安装步骤详解,讲述ORACLE EBS R12的详细安装步骤,感觉不错,和大家一块分享
win7 ORACLE ebs 需要的文件和具体设置步骤 详细
Oracle EBS 各模块详解 01采购培训 02库存培训 03销售培训 04应付培训 05总帐培训 06应收培训
ORACLE ebs 各个模块的表之间的关联关系,方便大家熟悉ebs系统的表结构
不过,毕竟这个文档的年代已经较久,后来EBS较新版本中的内容可能没有,也可能新版本实际已有变化,故使用时若遇到有疑问的地方,最好和与系统捆绑在一起的在线帮助文档相比较,或与相应版本的“User Guide”的有关...
主要内容是oracle EBS财务模块,就学习ERP挺好的材料,分为五个部分 Oracle EBS财务模块(一)基本功能 Oracle EBS财务模块(二)基本组成模块 Oracle EBS财务模块(三)总账功能 Oracle EBS财务模块(四)账套 ...
OracleEBS中的弹性域讲解与设置
Oracle EBS开发文档(form, report), 写得很不错
本文主要整理了Oracle EBS(11.5.0.10) 中常用的表结构以供开发维护查询。
Oracle EBS 采购请购单接口示例,亲测可用 个人网站 http://a66.site 公众号:LXFIMJ
ORACLEEBS财务全模块操作手册中文版收集.pdf