Quick view of information such as output file or log of a request in ORACLE EBS (GO)

Quickly view information such as output file or log for a request in ORACLE EBS

On the project, there are often requests to report yellow and other issues reflected on the technical consultant side, but due to certain restrictions, sometimes even the system administrator responsibility can only see a request information, but cannot view its output File. The following method can be very convenient to view the output of the request and log information, and even do not need to enter the system can be viewed, only a request number can be:

SQL code

/* 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 would 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 code

SELECT Fnd_webfile. Get_url (4, --Output type

3615219, --Request number

' Applsyspub/pub ',

' FCWW ',

10)

From DUAL;

The first parameter, 4, indicates the output of request, which can be determined as needed

/* 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;

The second parameter is a request_id

The third parameter is the environment parameter Gwyuid

The fourth parameter is Two_task,

The fifth parameter is the number of minutes that a URL is valid.

Then just copy this URL to IE and you can see it.

Quick view of information such as output file or log of a request in ORACLE EBS (GO)