Too many Workflow Background Processes running
Hello Guys,
Every month I create a report to submit to my higher authorities. In the report there is a section called "Total Concurrent Requests Processed".
I use the query :
select count(*) from FND_CONCURRENT_REQUESTS where trunc(request_date) between '01-Aug-2015' and '31-Aug-2015' order by request_date desc;
to find the number out. I only need to report this number.
But since 2 months, I have been finding a very huge number of concurrent requests being run in my environment. Here are the approx. stats of last FOUR Months.
MAY JUNE JULY AUGUST
57000 45000 172000 1318000
I investigated this issue and found out that the "Workflow Background Process" is the Program that has been running on a huge number of times out of this. I'm not sure why.