Performance issue for OAF Framework/Self Services Web Pages R12.2
Recently we are facing this issue after login in to EBS navigation on home page very slow It was taking around 5 to 10 min to open the navigation page We enabled the Trace to user level to find the solution for it. Enabling Trace in user Level: Step 1: Go to system administrator -> Profile ->system -> User Enter username and Profile Option “ Initialization SQL Statement – Custom ” and Enter the user name then search Step 2: Just replace the Username for below command and paste the command in profile values Begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER='||'''' ||<Username> ||''''||' EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');End; Step 3: Retest the issue and generate tkprof How to generate Tkprof: Once user retest the issue disable the