Query to find the Top Concurrent Job/Requests generating Big Output Files

Query to find the Top Concurrent Job/Requests generating Big Output Files

This script will be identifying completed concurrent request which are generating big size output files. Please change the condition based on your requirements.

Script:

SELECT

   distinct fcr.request_id,

   user_concurrent_program_name,

    responsibility_name,

    request_date,

    argument_text,

    request_id,

    phase_code,

    status_code,

    logfile_name,

    outfile_name,

    output_file_type,

    hold_flag,

    user_name,

    fcr.ofile_size,

    fcp.creation_date

FROM

    fnd_concurrent_requests fcr,

    fnd_concurrent_programs_tl fcp,

    fnd_responsibility_tl fr,

    fnd_user fu

WHERE

    fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id

    and fcr.responsibility_id = fr.responsibility_id

    and fcr.requested_by = fu.user_id

    and Phase_code='C'

    and fcp.language='US'

    and fcr.ofile_size is NOT NULL

    ORDER BY fcr.ofile_size desc;

If you like please follow and comment