Apps DBA

Query To Count Pending Request SELECT/*+ choose */ Count(*)FROM fnd_concurrent_requests … Read more

Query To find Concurrent Program Name, Phase Code And Status … Read more

Query To Find a Concurrent Program Enabled with Trace SELECT … Read more

Query To Find Request Submitted By User QUERY TO FIND … Read more

Query To Find Pending Request in Oracle Apps dba. SELECT … Read more

Query To Find the Reports Finished SELECT a.request_id ‘Req Id’,a.phase_code,a.status_code,actual_start_date,actual_completion_date,c.concurrent_program_name|| … Read more

Terminating Report From Backend, We should use data dictionary views … Read more

Query To Check Total Scheduled Requests SELECT request_id, id,Nvl(meaning, ‘UNKNOWN’),status,user_concurrent_program_name, … Read more

Query To Check List Of Running Requests SELECT q.concurrent_queue_nameqname,f.user_name,a.request_id“Req Id”,Decode(a.parent_request_id, … Read more