[EBS]查看某個Request的Output File

 

Oracle EBS標準功能中request執行完後只能看到自己執行的結果(view output), 

系統人員有時要幫忙查看問題就顯得有些麻煩...

2023更新: Responsibility>Application Developer > Concurrent > Requests > 可以Find其他人執行的結果

查看有個function可以取到request的output, 取得EBS report網址:

SELECT fnd_webfile.get_url(
                           file_type   => 4,                --輸出類行
                           id          => 60240818,         --Request_id
                           gwyuid      => '',               --不使用 (環境參數)
                           two_task    => '',               --不使用 (Two Task)
                           expire_time => 10                --URL保留分鐘數
                          ) url
  FROM dual;

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

DECLARE

   l_request_id   NUMBER := :P_REQ_ID;                       -- The request id

   l_two_task     VARCHAR2 (256);

   l_gwyuid       VARCHAR2 (256);

   l_url          VARCHAR2 (1024);

BEGIN

   -- Get the value of the profile option named, Gateway User ID (GWYUID)

   --- l_gwyuid := fnd_profile.VALUE ('APPLSYSPUB/PUB');

   SELECT   profile_option_value

     INTO   l_gwyuid

     FROM   fnd_profile_options o, fnd_profile_option_values ov

    WHERE       profile_option_name = 'GWYUID'

            AND o.application_id = ov.application_id

            AND o.profile_option_id = ov.profile_option_id;

   -- Get the value of the profile option named, Two Task(TWO_TASK)

   SELECT   profile_option_value

     INTO   l_two_task

     FROM   fnd_profile_options o, fnd_profile_option_values ov

    WHERE       profile_option_name = 'TWO_TASK'

            AND o.application_id = ov.application_id

            AND o.profile_option_id = ov.profile_option_id;

   l_url :=

      fnd_webfile.get_url (file_type     => fnd_webfile.request_out, -- for out file

                           ID            => l_request_id,

                           gwyuid        => l_gwyuid,

                           two_task      => l_two_task,

                           expire_time   => 500-- minutes, security!.

                           );

   DBMS_OUTPUT.put_line (l_url);

END;