Query To Find the Reports Finished With Error Code In Oracle Apps DBA
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
Apps DBA
Terminating Report From Backend
Terminating Report From Backend, We should use data dictionary views … Read more
Query To Check Total Scheduled Requests
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
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