Search This Blog

Tuesday, August 2, 2011

How to find No. of request submitted per day in Oracle Application

With the below query we can find the total no. of request submitted per day.

SELECT concurrent_program_name, COUNT(*) 
FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS P 
WHERE R.concurrent_program_id=P.concurrent_program_id  
AND R.actual_start_date= {pick a day}
GROUP BY concurrent_program_name
ORDER BY 2 DESC;

NOTE: give the value for pick a day

No comments: