Find from which responsibility user has ran the concurrent program


select distinct
 
user_concurrent_program_name,
 
responsibility_name,
 
user_name, 
 
request_date,
 
argument_text, 
 
request_id,
 
requested_by,
 
phase_code,
 
status_code,
 
a.concurrent_program_id,
 
a.responsibility_id,
 
logfile_name,
 
outfile_name
 
from fnd_concurrent_requests a,
 
fnd_concurrent_programs_tl b,
 
fnd_responsibility_tl c,
 
fnd_user d
 
where a.CONCURRENT_PROGRAM_ID = b.concurrent_program_id
 
and a.responsibility_id = c.responsibility_id
 
and a.requested_by = d.user_id 
 
and user_name like 'sonu'

No comments:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...