Query to find Total Concurrent Request Submitted on a Daily Basis

This script will help to find the total Concurrent Request Getting completed on a daily basis.
You can add more conditions based on your requirement.


select trunc(request_date) "Date",count(1) "Total Request Completed" from fnd_concurrent_requests where phase_code='C'  group by trunc(request_date) order by 1 desc;


If you like please follow and comment