Query To Count the number of reports registered In Each Module SELECT fa.application_short_name,Decode (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’,‘Q’, ‘SQLPlus’, ‘H’, ‘Host’, ‘L’, ‘SQLLoader’,‘A’, ‘Spawned’,‘I’, … Read more
Query To Find Scheduled Concurrent Request SELECT cr.request_id,Decode(cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’|| cr.description,cp.user_concurrent_program_name)NAME,argument_text,cr.resubmit_interval,Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’))schedule_type,Decode(Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’)),‘PERIODICALLY’, ‘EVERY ‘|| … Read more
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