Wednesday, 31 May 2023

Find SID, Serial from Concurrent Request id in EBS

select 
    sess.sid,
    sess.serial#,
    sess.sql_hash_value,
    sess.status
from 
    apps.fnd_concurrent_requests FCR, 
    v$session sess
where 
    fcr.oracle_session_id = sess.audsid
and 
    fcr.request_id = &sreqid