Friday, April 12, 2013

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';