1.Find which programs are stucked in OPP using below query.
set lines 200;
set pages 300;
SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,v$session d,
apps.fnd_concurrent_programs_tl e
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id=e.concurrent_program_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.phase_code = ‘R’
and d.sql_id=’fnpyvpk41nd5s’
order by 7 desc;
2. This query return the value if any program got stuked in OPP.
3. If any program was stucked in OPP , Go to application node CONCURRENT PROGRAMS log location.
cd $APPLCSF/log
list the recent OPP logs using ls -lrt *OPP*
4. View the log files and check the errors using vi command.
Error Example.
5. If you found the error means , send the error to user and terminate the request.
