If you want to perform load analysis on how many concurrent request were run each day, the script below was useful to provide such information.

SQL> SELECT sysdate -1, count(*)
FROM apps.fnd_concurrent_requests
WHERE to_char(actual_completion_date,'YYYYMMDD') =
(SELECT to_char(sysdate -1,'YYYYMMDD') FROM dual);

This script will only provide the number of completed concurrent request.