Blog on Oracle Cloud, Fusion Applications, EBS, OAC, HCM, and AI Data Platform
Provides insights from Oracle resources and personal experience. Opinions are my own
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
Newer Post
Older Post
Home