Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at support@funoracleapps.com

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

No comments

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

No comments :

Post a Comment