Script to get Trace details for a concurrent request along with the log file and output file location details<\/p>\n
SELECT 'Request id: ' <\/code><\/p>\n","protected":false},"excerpt":{"rendered":" Script to get Trace details for a concurrent request along with the log file and output file location details SELECT ‘Request id: ‘ || request_id, ‘Trace id: ‘ || oracle_process_id, ‘Trace Flag: ‘ || req.enable_trace, ‘Trace Name: ‘ || dest.VALUE || ‘\/’ || LOWER (dbnm.VALUE) || ‘_ora_’ || oracle_process_id || ‘.trc’, ‘Prog. Name: ‘ || […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-4104","post","type-post","status-publish","format-standard","hentry","category-sysadmin-aol"],"yoast_head":"\n<\/p>\n
\n || request_id,
\n 'Trace id: '
\n || oracle_process_id,
\n 'Trace Flag: '
\n || req.enable_trace,
\n 'Trace Name: '
\n || dest.VALUE
\n || '\/'
\n || LOWER (dbnm.VALUE)
\n || '_ora_'
\n || oracle_process_id
\n || '.trc',
\n 'Prog. Name: '
\n || prog.user_concurrent_program_name,
\n 'File Name: '
\n || execname.execution_file_name
\n || execname.subroutine_name,
\n 'Status : '
\n || DECODE (phase_code, 'R', 'Running')
\n || '-'
\n || DECODE (status_code, 'R', 'Normal'),
\n 'SID Serial: '
\n || ses.sid
\n || ','
\n || ses.serial#,
\n 'Module : '
\n || ses.module ,
\n TO_CHAR(req.actual_start_date,'DD-MON-YYYY HH24:MI:SS') Request_start_date ,
\n TO_CHAR(req.actual_completion_date,'DD-MON-YYYY HH24:MI:SS') Request_completion_date ,
\n req.logfile_name ,
\n req.outfile_name ,
\n req.argument_text parameters_passed
\nFROM fnd_concurrent_requests req,
\n v$session ses,
\n v$process PROC,
\n v$parameter dest,
\n v$parameter dbnm,
\n fnd_concurrent_programs_vl prog,
\n fnd_executables execname
\nWHERE req.request_id = :p_request_id
\nAND req.oracle_process_id = proc.spid(+)
\nAND proc.addr = ses.paddr(+)
\nAND dest.NAME = 'user_dump_dest'
\nAND dbnm.NAME = 'db_name'
\nAND req.concurrent_program_id = prog.concurrent_program_id
\nAND req.program_application_id = prog.application_id
\nAND prog.application_id = execname.application_id
\nAND prog.executable_id = execname.executable_id
\n;<\/p>\n