Script that will list all Concurrent programs for which trace is enabled – output should be Program Name / Shortname / Application



#Script to list the concurrent programs with trace enabled
output_log=/tmp/practice/log.txt
export output_log

sqlplus -S
apps/xxxxxxx << EOF

spool $output_log

set pages 1000
lines 1000

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

exit;
spool off
EOF
Recent Posts