Trace Analyzer, also known as TRCANLZR or TRCA,

From the below note-id download the trace Analyzer.

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces [ID 224270.1]

Unzip the trca on db node:
Install the trace Analyzer : follow the installation doc in the trca directory

Run trace Analyzer:

$cd /home/oracrp/trca/run
login as apps user
sql > start trcanlzr.sql CRP2_ora_29564.trc

provide the trace file to be analyzed as given above
once the trace analyzer is completed you will get the trca_*.zip file in the same directory.

Terminate the concurrent Request

Login to db as apps user

update applsys.fnd_concurrent_requests
   set phase_code = 'C',
       status_code = 'X',
    actual_completion_date = sysdate
  where request_id = '&R';

Enter the Request-id.

commit;

exit

Enable Trace for Application User

Login to ebs as sysadmin

Navigate to profile option
Profile value : Initialization SQL Statement - Custom
Username :  Application user for whom you want to generate Trace
click on Find

Under username column put this..

BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||'username_instance' ||''''||' EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 '||''''); END;

Note : Level cane be 4,8,12 depends on your requirement

Example :

BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||'Waseem_CRP1' ||''''||' EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 '||''''); END;

Save it. Inform the User logout and login back.

tracefile name will be : waseem_CRP1.trc

trace will be generated under--udump