Script to find all the Concurrent Programs which are Trace Enabled.

Below Query will help out in finding all the Concurrent programs which are Trace Enabled.

sqlplus apps/<password>

set linesize 600
set pages 1000 lines 1000
col Short_Name for a30
select a.CONCURRENT_PROGRAM_ID, b.USER_CONCURRENT_PROGRAM_NAME "Program_Name", a.CONCURRENT_PROGRAM_NAME "Short_Name", a.APPLICATION_ID
from fnd_concurrent_programs a, fnd_concurrent_programs_tl b
where a.CONCURRENT_PROGRAM_ID=b.CONCURRENT_PROGRAM_ID and a.ENABLE_TRACE='Y';