Query to get request set run details

Query to get request set run details

In this post , we will be discuss about Query to get request set run details. This query will help to extract the details of all Request run requests submitted in oracle application. we will get the complete details of request set run detail using this sql query.We do schedule Concurrent Programs and Request Set in Oracle apps. We will share the SQL query which help us to extract the Request Set running in our Oracle application System. This helps us to monitoring and tracking the things. Please find below the Query to get request set run details.

 

6 Important Table Used by Query to get request set run details

1.fnd_user

2.fnd_printer_styles_tl

3.fnd_concurrent_requests

4.fnd_responsibility_tl

5.fnd_concurrent_programs_tl

6.fnd_concurrent_programs

Query to get request set run details

Example of SQL Query to get request set run details

 

SELECT DISTINCT r.request_id

      , u.user_name requestor

      , u.description requested_by

      , CASE

           WHEN pt.user_concurrent_program_name = 'Report Set'

              THEN DECODE(

                  r.description

                   , NULL, pt.user_concurrent_program_name

                   ,    r.description

                     || ' ('

                     || pt.user_concurrent_program_name

                     || ')'

                  )

           ELSE pt.user_concurrent_program_name

        END job_name

      , u.
email_address

      , frt.responsibility_name requested_by_resp

      , r.request_date

      , r.requested_start_date

      , DECODE(

           r.hold_flag

         , 'Y', 'Yes'

         , 'N', 'No'

        ) on_hold

      , r.printer

      , r.number_of_copies print_count

      , r.argument_text PARAMETERS

      , r.resubmit_interval resubmit_every

      , r.resubmit_interval_unit_code resubmit_time_period

      , TO_CHAR((r.requested_start_date), 'HH24:MI:SS') start_time,

        NVL2(

           r.resubmit_interval

         , 'Periodically'

         , NVL2(

              r.release_class_id

            , 'On specific days'

            , 'Once'

           )

        ) AS schedule_type

   FROM apps.fnd_user u

      , apps.fnd_printer_styles_tl s

      , apps.fnd_concurrent_requests r

      , apps.fnd_responsibility_tl frt

      , apps.fnd_concurrent_programs_tl pt

      , apps.fnd_concurrent_programs pb

  WHERE pb.application_id = r.program_application_id

    AND r.responsibility_id = frt.responsibility_id

    AND pb.concurrent_program_id = pt.concurrent_program_id

    AND u.user_id = r.requested_by

    AND s.printer_style_name(+) = r.print_style 

    AND pb.concurrent_program_id = r.concurrent_program_id

    AND pb.application_id = pt.application_id

    AND pt.user_concurrent_program_name = 'Report Set'

Query to get request set run details