How to get Trace File path in backend in oracle apps

How to get Trace File
When you enable SQL trace in a session for the first time, the Oracle server process handling that session will create a trace file in the directory on the database server designated by the user_dump_dest initialization parameter. As the server is called by the application to perform database operations, the server process will append to the trace file. 

Query:

------------

select name,value from V$PARAMETER where name = 'user_dump_dest';

--

How to find Trace File Names in Oracle apps based on request id

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 = 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; 

 

--