VER:
Application: EBS R12.0.6
Database: Oracle 10gR2
SQL:
SELECT fcr.request_id
,fcr.enable_trace
, vp1.VALUE
|| '/'
|| LOWER (vp2.VALUE)
|| '_ora_'
|| fcr.oracle_process_id
|| '.trc'
trace_path
FROM fnd_concurrent_requests fcr
,v$parameter vp1
,v$parameter vp2
WHERE vp1.name = 'user_dump_dest'
AND vp2.name = 'db_name'
AND fcr.request_id = &request_id;
REF:
1. Given a concurrent request id how do you find the trace file generated by this request idhttp://allappsdba.blogspot.com/2012/05/2-given-concurrent-request-id-how-do.html