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=’||””||JAPANOY_CONV’ ||””||’ EVENTS =’||””||’ 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 ‘||””); END;

Save it. Inform the User logout and login back.
tracefile name will be : JAPANOY_CONV.trc
trace will be generated under–udump
Advertisements

About this entry