Query To Find Request Submitted By User
QUERY TO FIND REQUEST SUBMITTED BY USER:
SELECT user_concurrent_program_name,
request_date,
request_id,
phase_code,
status_code
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_responsibility_tl fr,
fnd_user fu
WHERE fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.responsibility_id = fr.responsibility_id
AND fcr.requested_by = fu.user_id
AND user_name = ‘username’ — “Enter The User Name”
AND actual_start_date > SYSDATE – 2
ORDER BY request_date ASC;
— “Enter The SYSDATE for how many days you want to generate the request, Here 2 means for 2 days”
Read More about Oracle Apps Scripts:
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