Hello!

I’m trying to build an alert that will track the number of pending processes per Concurrent Manager.  Does anyknow have the query to do this?

Thanks

Hi,

You can get the script in:
SQL> @$FND_TOP/sql/afimchk.sql

OR

Concurrent Manager Check Script
CCM.sql
This script will diagnose Concurrent Managers and Concurrent Requests
(For all Releases of Apps.)

Regards,
Ajay Kunde