SQL Query to Find Requests Handled by Conflict Resolution Manager EBS


SELECT 
    r.request_id,
    r.concurrent_program_id,
    cp.concurrent_program_name,
    cp.user_concurrent_program_name,
    fa.application_name,
    r.phase_code,
    r.status_code,
    r.actual_start_date,
    r.actual_completion_date,
    r.hold_flag,
    r.resubmit_interval,
    r.resubmit_interval_unit_code,
    r.resubmit_end_date,
    r.resubmit_interval_type_code
FROM 
    fnd_concurrent_requests r
JOIN 
    fnd_concurrent_programs cp ON r.concurrent_program_id = cp.concurrent_program_id
JOIN 
    fnd_application fa ON cp.application_id = fa.application_id
WHERE 
    r.phase_code = 'P'  -- 'Pending'
    AND r.status_code = 'Q' -- 'Standby', typically under CRM handling
    AND r.hold_flag = 'N'  -- Not manually held
ORDER BY 
    r.requested_start_date DESC;



To Find Historical CRM Handled Requests:


SELECT 
    request_id,
    requested_start_date,
    actual_start_date,
    ROUND((actual_start_date - requested_start_date)*24*60, 2) AS delayed_minutes
FROM 
    fnd_concurrent_requests
WHERE 
    ROUND((actual_start_date - requested_start_date)*24*60, 2) > 0
    AND phase_code = 'C'  -- Completed
    AND status_code = 'C'  -- Normal
ORDER BY 
    delayed_minutes DESC;



SQL Query to Find Incompatible Concurrent Programs

SELECT 
    fcpt1.user_concurrent_program_name AS "Current Program",
    fcpt2.user_concurrent_program_name AS "Incompatible Program"
FROM 
    fnd_concurrent_programs_tl fcpt1,
    fnd_concurrent_program_serial fcps,
    fnd_concurrent_programs_tl fcpt2
WHERE 
    fcpt1.concurrent_program_id = fcps.concurrent_program_id
    AND fcpt2.concurrent_program_id = fcps.serial_program_id
    AND fcpt1.language = 'US'
    AND fcpt2.language = 'US'
    AND fcpt1.user_concurrent_program_name = '<<Your Concurrent Program Name>>';


Find Conflicting/Incompatible Running Programs at time:

SELECT request_id, concurrent_program_id, requested_start_date, actual_start_date, actual_completion_date
FROM fnd_concurrent_requests
WHERE actual_start_date <= (SELECT actual_start_date 
                            FROM fnd_concurrent_requests
                            WHERE request_id = <<Your Request ID>>)
AND actual_completion_date >= (SELECT requested_start_date 
                               FROM fnd_concurrent_requests
                               WHERE request_id = <<Your Request ID>>);







Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment