1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice
sujoyb

Sql query to find all scheduled concurrent requests 2011-03-22

Sql query to find all scheduled concurrent requests

  1. sujoyb
    We have been using this script for sometime now for finding all scheduled concurrent programs.

    [highlight=sql]SELECT fcr.request_id,
    DECODE(fcpt.user_concurrent_program_name,
    'Report Set',
    'Report Set:' || fcr.description,
    fcpt.user_concurrent_program_name) CONC_PROG_NAME,
    argument_text PARAMETERS,
    NVL2(fcr.resubmit_interval,
    'PERIODICALLY',
    NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,
    DECODE(NVL2(fcr.resubmit_interval,
    'PERIODICALLY',
    NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),
    'PERIODICALLY',
    'EVERY ' || fcr.resubmit_interval || ' ' ||
    fcr.resubmit_interval_unit_code || ' FROM ' ||
    fcr.resubmit_interval_type_code || ' OF PREV RUN',
    'ONCE',
    'AT :' ||
    TO_CHAR(fcr.requested_start_date, 'DD-MON-RR HH24:MI'),
    'EVERY: ' || fcrc.class_info) PROG_SCHEDULE,
    fu.user_name USER_NAME,
    requested_start_date START_DATE
    FROM apps.fnd_concurrent_programs_tl fcpt,
    apps.fnd_concurrent_requests fcr,
    apps.fnd_user fu,
    apps.fnd_conc_release_classes fcrc
    WHERE fcpt.application_id = fcr.program_application_id
    AND fcpt.concurrent_program_id = fcr.concurrent_program_id
    AND fcr.requested_by = fu.user_id
    AND fcr.phase_code = 'P'
    AND fcr.requested_start_date > SYSDATE
    AND fcpt.LANGUAGE = 'US'
    AND fcrc.release_class_id(+) = fcr.release_class_id
    AND fcrc.application_id(+) = fcr.release_class_app_id;[/highlight]