oracle erp 특정 Concurrent Program 수행정보 확인 Scripts

- 특정 Concurrent Program 수행정보 확인 Scripts -- 변수 설명 :CONCURRENT_PROGRAM_NAME select fcr.REQUEST_ID, fcpv.CONCURRENT_PROGRAM_NAME,fcpv.USER_CONCURRENT_PROGRAM_NAME, fcr.REQUESTED_START_DATE, fcr.ACTUAL_START_DATE "Start Time", fcr.ACTUAL_COMPLETION_DATE "End Time", decode(fcr.ACTUAL_COMPLETION_DATE,null, round((sysdate-fcr.ACTUAL_START_DATE)*24*60*60), round((fcr.ACTUAL_COMPLETION_DATE-fcr.ACTUAL_START_DATE)*24*60*60)) "Runtime(Sec)", fcr.ARGUMENT_TEXT "Parameter", --fcr.REQUESTED_BY, fu.user_name, fu.description "Requestor", fcr.RESUBMIT_INTERVAL||','|| decode(RESUBMIT_INTERVAL_UNIT_CODE,'MINUTES','M','HOURS','H','DAYS','D','MONTHS','M',null)||','|| decode(RESUBMIT_INTERVAL_TYPE_CODE,'START','S','END','E',null) "SCHEDULE", '*'||oracle_process_id||'*' "Trace", fcr.PHASE_CODE, fcr.STATUS_CODE from fnd_concurrent_requests fcr, fnd_concurrent_programs_vl fcpv, fnd_user fu where fcr.CONCURRENT_PROGRAM_ID=fcpv.CONCURRENT_PROGRAM_ID -- and PHASE_CODE='C' -- and STATUS_CODE='C' and fcpv.CONCURRENT_PROGRAM_NAME='KVRC1010' and fu.user_id=fcr.REQUESTED_BY order by REQUEST_ID desc; 예전에 효인선생님한테 받았음 아주 유용하게 잘썼어요.