How to turn on debug mode on a user profile

Turning on Debug in the proflie option 

1. Search for the profile option - "Initialization SQL Statement - Custom"
2. Copy the entry below and add it to the option value at User level, ensure this is done for the user you are interested in debuging:

 "begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET EVENTS=''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'' tracefile_identifier=''WAPPSDBA'' max_dump_file_size=''unlimited'''); end;"

3. The generated output will be found in the user dump location e.g %WAPPSDBA.trc
4. Remove the entries from "Initialization SQL Statement - Custom" at user level when you are done debugging the user activity.