\n\t \u9879\u76ee\u4e0a\uff0c\u7ecf\u5e38\u6709\u8bf7\u6c42\u62a5\u7ea2\u62a5\u9ec4\u7b49\u95ee\u9898\u53cd\u6620\u5230\u6280\u672f\u987e\u95ee\u8fd9\u8fb9\uff0c\u4f46\u662f\u7531\u4e8e\u67d0\u4e9b\u6743\u9650\u7684\u9650\u5236\uff0c\u6709\u65f6\u5019\u54ea\u6015System Administrator\u804c\u8d23\u4e5f\u53ea\u80fd\u770b\u5230\u67d0\u4e2aRequest\u4fe1\u606f\uff0c\u4f46\u662f\u4e0d\u80fd\u67e5\u770b\u5b83\u7684Output File\u3002\u7528\u4e0b\u9762\u8fd9\u4e2a\u65b9\u6cd5\u53ef\u4ee5\u5f88\u65b9\u4fbf\u5730\u67e5\u770b\u8bf7\u6c42\u7684\u8f93\u51fa\u548c\u65e5\u5fd7\u7b49\u4fe1\u606f\uff0c\u751a\u81f3\u4e0d\u7528\u8fdb\u7cfb\u7edf\u5c31\u53ef\u4ee5\u67e5\u770b\u4e86\uff0c\u53ea\u9700\u8981\u4e00\u4e2a\u8bf7\u6c42\u7f16\u53f7\u5c31\u53ef\u4ee5\uff1a\n<\/p>\n
\n\t\/* Function: GET_URL
\n\t*
\n\t* Purpose: Constructs and returns the URL for a Concurrent Processing
\n\t* log or output file.
\n\t*
\n\t* Arguments:
\n\t* file_type – Specifies the type of file desired:
\n\t* fnd_webfile.process_log = The log of the concurrent process identified by the parameter ID.
\n\t* fnd_webfile.icm_log = The log of the ICM process identified by ID.
\n\t* Or, the log of the ICM process that spawned
\n\t* the concurrent process identified by ID.
\n\t* Or, the log of the most recent ICM process
\n\t* if ID is null.
\n\t* fnd_webfile.request_log = The log of the request identified by ID.
\n\t* fnd_webfile.request_out = The output of the request identified by ID.
\n\t* fnd_webfile.request_mgr = The log of the concurrent process that ran the request identified by ID.
\n\t* fnd_webfile.frd_log = The log of the forms process identified by ID.
\n\t* fnd_webfile.generic_log = The log file identified by ID.
\n\t* fnd_webfile.generic_trc = The trace file identified by ID.
\n\t* fnd_webfile.generic_ora = The ora file identified by ID.
\n\t* fnd_webfile.generic_cfg = The config file identified by ID.
\n\t* fnd_webfile.context_file= Applications Context file identified by ID.
\n\t* fnd_webfile.generic_text= Generic file using text transfer mode.
\n\t* fnd_webfile.generic_binary = Generic file using binary transfer mode.
\n\t* fnd_webfile.request_xml_output = The xml output of Concurrent Request.
\n\t*
\n\t* id – A concurrent process ID, concurrent request ID, or file ID
\n\t* depending on the file type specified.
\n\t* For fnd_webfile.context_file,fnd_webfile.generic_text,
\n\t* fnd_webfile.generic_binary this value is null.
\n\t* gwyuid – The value of the environment variable GWYUID used in constructing the URL.
\n\t* two_task – The database two_task, used in constructing the URL.
\n\t* expire_time – The number of minutes for which this URL will remain valid.
\n\t* source_file – Source file name with full patch
\n\t* source_node – Source node name.
\n\t* dest_file – Destination file name
\n\t* dest_node – Destination node name
\n\t* page_no – Current page number
\n\t* page_size – Number of lines in a page
\n\t* Returns NULL on error. Check the FND message stack.
\n\t*\/
\n\tFUNCTION GET_URL(FILE_TYPE IN NUMBER,
\n\t ID IN NUMBER,
\n\t GWYUID IN VARCHAR2,
\n\t TWO_TASK IN VARCHAR2,
\n\t EXPIRE_TIME IN NUMBER,
\n\t SOURCE_FILE IN VARCHAR2 DEFAULT NULL,
\n\t SOURCE_NODE IN VARCHAR2 DEFAULT NULL,
\n\t DEST_FILE IN VARCHAR2 DEFAULT NULL,
\n\t DEST_NODE IN VARCHAR2 DEFAULT NULL,
\n\t PAGE_NO IN NUMBER DEFAULT NULL,
\n\t PAGE_SIZE IN NUMBER DEFAULT NULL) RETURN VARCHAR2;\n<\/p>\n
\n\t \n<\/p>\n
\n\t–\u8c03\u7528\u4ee3\u7801\n<\/p>\n
\n\tSELECT FND_WEBFILE.GET_URL(3, –\u8f93\u51fa\u7c7b\u578b
\n\t 523502, –\u8bf7\u6c42\u7f16\u53f7
\n\t 'APPLSYSPUB\/PUB',
\n\t 'FCWW',
\n\t 10)
\n\t FROM DUAL;\n<\/p>\n
\n\t–\u53c2\u6570\u4ecb\u7ecd\n<\/p>\n
\n\t\u7b2c\u4e00\u4e2a\u53c2\u65704\u8868\u793arequest\u7684output,\uff08\u53ef\u6839\u636e\u9700\u8981\u51b3\u5b9a\uff09
\n\t\/* Define file types for get_url *\/
\n\tprocess_log constant number := 1;
\n\ticm_log constant number := 2;
\n\trequest_log constant number := 3;
\n\trequest_out constant number := 4;
\n\trequest_mgr constant number := 5;
\n\tfrd_log constant number := 6;
\n\tgeneric_log constant number := 7;
\n\tgeneric_trc constant number := 8;
\n\tgeneric_ora constant number := 9;
\n\tgeneric_cfg constant number := 10;
\n\tcontext_file constant number := 11;
\n\tgeneric_text constant number := 12;
\n\tgeneric_binary constant number := 13;
\n\trequest_xml_output constant number :=14;\n<\/p>\n
\n\t\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662frequest_id
\n\t\u7b2c\u4e09\u4e2a\u53c2\u6570\u662f\u73af\u5883\u53c2\u6570GWYUID
\n\t\u7b2c\u56db\u4e2a\u53c2\u6570\u662ftwo_task,
\n\t\u7b2c\u4e94\u4e2a\u53c2\u6570\u662furl\u6709\u6548\u7684\u5206\u949f\u6570.
\n\t\u7136\u540e\u5c31\u662f\u628a\u8fd9\u4e2aurl\u590d\u5236\u5230ie\u5c31\u53ef\u4ee5\u770b\u5230\u4e86.\n<\/p>\n
\n\t\u8f6c\u8f7d\u81ea\uff1ahttps:\/\/zhangzhongjie.iteye.com\/blog\/1815442<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9879\u76ee\u4e0a\uff0c\u7ecf\u5e38\u6709\u8bf7\u6c42\u62a5\u7ea2\u62a5\u9ec4\u7b49\u95ee\u9898\u53cd\u6620\u5230\u6280\u672f\u987e\u95ee\u8fd9\u8fb9\uff0c\u4f46\u662f\u7531\u4e8e\u67d0\u4e9b\u6743\u9650\u7684\u9650\u5236\uff0c\u6709\u65f6\u5019 … \u7ee7\u7eed\u9605\u8bfbOracle EBS\u4e2d\u5feb\u901f\u67e5\u770b\u67d0\u4e2a\u8bf7\u6c42\u7684Output File\u6216log File\u7b49\u4fe1\u606f\uff08\u8f6c\u8f7d\uff09<\/span>