Trace file for request

Trace file for--request
SELECT ' Trace Name: '
|| DEST. VALUE
|| ‘/‘
|| LOWER (dbnm. VALUE)
|| ' _ora_ '
|| oracle_process_id
|| '. TRC ',
' File Name: ' | | Execname. Execution_file_name,
Execname. Subroutine_name
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 1 = 1
and REQ. request_id = &request_id--parameters
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

Trace file for request