Find Concurrent Manager Logfile

Please use below script to find Concurrent Manager Logfile.

 

SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = ‘0’
AND fcp.process_status_code = ‘A’;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."