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