Shulou(Shulou.com)06/01 Report--

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:'| | prog.user_concurrent_program_name

'File Name:' | | execname.execution_file_name | | execname.subroutine_name

'Status:' | | decode (phase_code,'R','Running')

| |'-'| | decode (status_code,'R','Normal')

'SID Serial:' | | ses.sid | |','| | ses.serial#

'Module:'| | ses.module

From fnd_concurrent_requests req, v$session ses, v$process proc

V$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog

Fnd_executables execname

Where req.request_id = & request

And req.oracle_process_id=proc.spid (+)

And proc.addr = ses.paddr (+)

And dest.name='user_dump_dest'

And dbnm.name='db_name'

And req.concurrent_program_id = prog.concurrent_program_id

And req.program_application_id = prog.application_id

And prog.application_id = execname.application_id

And prog.executable_id=execname.executable_id

The production environment runs the request "Purge Obsolete Workflow Runtime Data" regularly, and only keeps a history of 3 days.

Purge Concurrent Request and/or Manager Data

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.