Oracle EBS R12 - 根据request_id查trace文件的SQL

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 id
http://allappsdba.blogspot.com/2012/05/2-given-concurrent-request-id-how-do.html