tutorailwale

Query To Find All Reports Status With User Name SELECT /*+ choose */ U.user_name User_name,fcr.request_id, request_id,To_char(Round(( Nvl(fcr.actual_completion_date,SYSDATE) –fcr.actual_start_date ) *1440)) TIME,c.concurrent_program_name|| ‘ – ‘|| Substr(fcrv.program, … Read more

Query To Count Pending Request SELECT/*+ choose */ Count(*)FROM fnd_concurrent_requests fcr,fnd_concurrent_programs c,fnd_conc_req_summary_v fcrvWHERE fcr.concurrent_program_id = c.concurrent_program_idAND fcr.program_application_id = c.application_idAND fcr.concurrent_program_id = fcrv.concurrent_program_idAND fcr.request_id = fcrv.request_idAND … Read more

Query To find Concurrent Program Name, Phase Code And Status Code for a given Request ID: SELECT request_id,user_concurrent_program_name,Decode(phase_code, ‘C’, ‘Completed’,phase_code) phase_code,Decode(status_code, ‘D’, ‘Cancelled’,‘E’, ‘Error’,‘G’, ‘Warning’,‘H’, … Read more

Query To Find a Concurrent Program Enabled with Trace SELECT A.concurrent_program_name ‘Program_Name’,Substr(A.user_concurrent_program_name, 1, 40) ‘User_Program_Name’,Substr(B.user_name, 1, 15) ‘Last_Updated_By’,Substr(B.description, 1, 25) DESCRIPTIONFROM apps.fnd_concurrent_programs_vl A,applsys.fnd_user BWHERE A.enable_trace … Read more

Query To Find Request Submitted By User QUERY TO FIND REQUEST SUBMITTED BY USER:SELECT user_concurrent_program_name,request_date,request_id,phase_code,status_codeFROM fnd_concurrent_requests fcr,fnd_concurrent_programs_tl fcp,fnd_responsibility_tl fr,fnd_user fuWHERE fcr.concurrent_program_id = fcp.concurrent_program_idAND fcr.responsibility_id = … Read more

Query To Find Pending Request in Oracle Apps dba. SELECT request_id, id,Nvl(meaning, ‘UNKNOWN’) status,user_concurrent_program_name pname,To_char(request_date, ‘DD-MON-RR HH24:MI:SS’) submitdFROM fnd_concurrent_requests fcr,fnd_lookups fl,fnd_concurrent_programs_vl fcpvWHERE phase_code = ‘P’AND … 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|| ‘:’|| ctl.user_concurrent_program_name ‘program’FROM applsys.fnd_concurrent_requests a,applsys.fnd_concurrent_processes b,applsys.fnd_concurrent_queues q,applsys.fnd_concurrent_programs c,applsys.fnd_concurrent_programs_tl ctlWHERE a.controlling_manager = b.concurrent_process_idAND a.concurrent_program_id = c.concurrent_program_idAND … Read more

Terminating Report From Backend, We should use data dictionary views v$session and v$process. SELECT oracle_process_id,Decode(status_code, ‘R’, ‘Running’,‘D’, ‘Canceled’,‘E’, ‘Error’,‘X’, ‘Terminated’,‘G’, ‘Warning’,‘T’, ‘Terminating’) ‘Status_code’,phase_code,To_char(actual_start_date, ‘DD-MON-YYYY=>hh24:mi:ss’) ‘Login … Read more

Query To Check Total Scheduled Requests SELECT request_id, id,Nvl(meaning, ‘UNKNOWN’),status,user_concurrent_program_name, pname,To_char(request_date, ‘DD-MON-RR HH24:MI:SS’), submitted,To_char(requested_start_date, ‘DD-MON-RR HH24:MI:SS’) requestedFROM fnd_concurrent_requests fcr,fnd_lookups fl,fnd_concurrent_programs_vl fcpvWHERE phase_code = ‘P’AND (fcr.requested_start_date … 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, –1, NULL,a.parent_request_id)“Parent”,a.concurrent_program_id“Prg Id”,a.phase_code,a.status_code— ,b.os_process_id “OS”— ,vs.sid— ,vs.serial# “Serial#”— ,vp.spid,a.oracle_process_id“spid”,( Nvl(a.actual_completion_date, SYSDATE) – a.actual_start_date ) * … Read more