Thursday, 16 July 2015

SQL query for Concurrent Request Paused Jobs

SELECT DISTINCT cr.request_id, cr.description,
                cp.user_concurrent_program_name, u.user_name,
                cr.actual_start_date
           FROM apps.fnd_lookup_values lv,
                apps.fnd_concurrent_programs_vl cp,
                apps.fnd_executables e,
                apps.fnd_concurrent_requests cr,
                apps.fnd_user u
          WHERE e.executable_id = cp.executable_id
            AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
            AND lv.lookup_code = e.execution_method_code
            AND cr.concurrent_program_id = cp.concurrent_program_id
            AND cr.requested_by = u.user_id
            AND u.user_name IN ('TFADMIN', 'BIADMIN', 'SYSADMIN')
            AND cr.status_code = 'W'
            AND cr.phase_code = 'R'
            AND TRUNC (cr.actual_start_date) >= TRUNC (SYSDATE - 1)
       ORDER BY cr.actual_start_date DESC, cr.request_id;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete