Wednesday, March 3, 2021

How to check concurrent list all in oracle EBS

select concurrent_program_id, program_application_id, printer,

        program_short_name, argument_text, print_style,

        user_print_style, save_output_flag, row_id,

        actual_completion_date, completion_text, parent_request_id,

        request_type, fcp_printer, fcp_print_style, fcp_required_style,

        last_update_date, last_updated_by, requested_by,

        has_sub_request, is_sub_request, update_protected,

        queue_method_code, responsibility_application_id, responsibility_id,

        controlling_manager, last_update_login, priority_request_id,

        enabled, requested_start_date, phase_code,

        hold_flag, status_code, request_id,

        program, requestor, priority

from fnd_conc_req_summary_v

where 1=1

    and phase_code = 'P' 

    and status_code in ('I', 'Q') 

    and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))

order by request_id desc-- check Concurrent All

select concurrent_program_id, program_application_id, printer,

        program_short_name, argument_text, print_style,

        user_print_style, save_output_flag, row_id,

        actual_completion_date, completion_text, parent_request_id,

        request_type, fcp_printer, fcp_print_style, fcp_required_style,

        last_update_date, last_updated_by, requested_by,

        has_sub_request, is_sub_request, update_protected,

        queue_method_code, responsibility_application_id, responsibility_id,

        controlling_manager, last_update_login, priority_request_id,

        enabled, requested_start_date, phase_code,

        hold_flag, status_code, request_id,

        program, requestor, priority

from fnd_conc_req_summary_v

where 1=1

    and phase_code = 'P' 

    and status_code in ('I', 'Q') 

    and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))

order by request_id desc

No comments:

Post a Comment

How to Create shell script to Start Database and Checking Table Space

 #dr_check_db_ERPGF.sh #!/bin/bash #run ./dr_check_db_ERPGF.sh | tee dr_ERPGF.out echo -e "\n" echo -e "+++++ Start Check Dat...