Query To Find a Concurrent Program Enabled with Trace
SELECT A.concurrent_program_name ‘Program_Name’,
Substr(A.user_concurrent_program_name, 1, 40) ‘User_Program_Name’,
Substr(B.user_name, 1, 15) ‘Last_Updated_By’,
Substr(B.description, 1, 25) DESCRIPTION
FROM apps.fnd_concurrent_programs_vl A,
applsys.fnd_user B
WHERE A.enable_trace = ‘Y’
AND A.last_updated_by = B.user_id;
Read More
Query To Find Request Submitted By User:
Query To Find Pending Request in Oracle Apps dba
Query To Find the Reports Finished With Error Code In Oracle Apps DBA
Terminating Report From Backend