Query to find Total Concurrent Request Submitted on a Daily Basis

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.

Script:

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;

Output:

If you like please follow and comment