Hello ,

Solution :

• For the TKPROF
  a) tkprof rawtrace.trc output_file explain=apps/apps/sort=(exeela,fchela) sys=no
  b) rawtrace.trc: Name of trace file
  output_file: tkprof out file
  explain: This option provides the explain plan for the SQL statements
  sort: This provides the sort criteria in which all SQL statements will be sorted. This will bring the bad SQL at the top of the outputfile.
  sys=no: Disables SQL statements issued by user SYS

Regards ,

Mahmoud Morsy

Hello ,

The below query help you :

select usr.user_name apps_username
,ses.osuser
,ses.machine
,i.first_connect "First Connect Date"
,ses.sid
,ses.serial#
,ses.module
,v.spid "Oracle Server Process"
,ses.process "Application Server Process"
,rsp.responsibility_name "Responsibility Name"
,null "Responsibility Start Time"
,fuc.function_name "Function Name"
,i.function_type "Function Type"
,i.last_connect function_start_time
from icx_sessions i
,fnd_logins l
,fnd_appl_sessions a
,fnd_user usr
,fnd_responsibility_tl rsp
,fnd_form_functions fuc
,gv$process v
,gv$session ses
where i.disabled_flag = 'N'
and i.login_id = l.login_id
and l.end_time is null
and i.user_id = usr.user_id
and l.login_id = a.login_id
and a.audsid = ses.audsid
and l.pid = v.pid
and l.serial# = v.serial#
and i.responsibility_application_id = rsp.application_id(+)
and i.responsibility_id = rsp.responsibility_id(+)
and i.function_id = fuc.function_id(+)
and i.responsibility_id not in (select t1.responsibility_id
from fnd_login_responsibilities t1
where t1.login_id = l.login_id)
and rsp.language(+) = 'US'
union
select usr.user_name apps_username
,ses.osuser
,ses.machine
,l.start_time
,ses.sid
,ses.serial#
,ses.module
,v.spid
,ses.process
,rsp.responsibility_name
,r.start_time
,null
,null
,null function_start_time
from fnd_logins l
,fnd_login_responsibilities r
,fnd_user usr
,fnd_responsibility_tl rsp
,gv$process v
,gv$session ses
where l.end_time is null
and l.user_id = usr.user_id
and l.pid = v.pid
and l.serial# = v.serial#
and v.addr = ses.paddr
and l.login_id = r.login_id(+)
and r.end_time is null
and r.responsibility_id = rsp.responsibility_id(+)
and r.resp_appl_id = rsp.application_id(+)
and rsp.language(+) = 'US'
and r.audsid = ses.audsid
union
select usr.user_name
,ses.osuser
,ses.machine
,l.start_time
,ses.sid
,ses.serial#
,ses.module
,v.spid
,ses.process
,null
,null
,frm.user_form_name
,ff.type
,f.start_time function_start_time
from fnd_logins l
,fnd_login_resp_forms f
,fnd_user usr
,fnd_form_tl frm
,fnd_form_functions ff
,gv$process v
,gv$session ses
where l.end_time is null
and l.user_id = usr.user_id
and l.pid = v.pid
and l.serial# = v.serial#
and v.addr = ses.paddr
and l.login_id = f.login_id(+)
and f.end_time is null
and f.form_id = frm.form_id(+)
and f.form_appl_id = frm.application_id(+)
and frm.language(+) = 'US'
and f.audsid = ses.audsid
and ff.form_id = frm.form_id
order by function_start_time

Regards,

Mahmoud Morsy

Hi,

Try the below Query:

[code]
SELECT *
FROM apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r
WHERE r.concurrent_program_id = p.concurrent_program_id
AND r.program_application_id = p.application_id
AND p.user_concurrent_program_name IN (‘OnDemand Gather Schema Statistics’,
‘Gather Schema Statistics’,
‘Gather Schema Statistics (IT_ANALYZE)’)
AND ( r.phase_code = ‘C’
AND r.status_code = ‘C’
AND r.actual_start_date >= sysdate)
[/code]

Regards,

Mahmoud Morsy.

Hi Vipul ,

The solution :

• Remove the files from the following directories
  $ rm -rf $OA_HTML/cabo/images/cache/*
  $ rm -rf  $OA_HTML/cabo/styles/cache/*
• Run  :  perl $FND_TOP/patch/115/bin/ojspCompile.pl –compile -p6 -log /tmp/ojspCompile.log –flush
  
• Remove the cache from browser and retry the Application URL.

Regards,

Mahmoud Morsy.