DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, January 12, 2016

Query to find concurrent programs that are running in background




set pages 1000 lines 1000 pagesize 1000;
select a.request_id ,decode(a.phase_code,'R','Running','Normal') Phase, 
to_char(a.actual_start_date,'DD-MON-RRRR HH24:MI:SS') 
Start_time , substr(b.user_concurrent_program_name,1,40) Program
from apps.fnd_concurrent_requests a, apps.fnd_concurrent_programs_tl b
where a.concurrent_program_id = b.concurrent_program_id and 
a.status_code = 'R'
order by Start_time;

No comments: