Script to check for scheduled concurrent requests in Oracle Apps 11i

Posted by on Jul 6, 2011 in 11i, Databases, Oracle, Oracle E-Business Suite | No Comments

Just a quick script that I wrote to report on concurrent requests that are scheduled to run in the future:

select
	fcr.request_id,
	fcr.parent_request_id,
	fu.user_name requestor,
	to_char(fcr.requested_start_date, 'MON-DD-YYYY HH24:MM:SS') START_DATE,
	fr.responsibility_key responsibility,
	fcp.concurrent_program_name,
	fcpt.user_concurrent_program_name,
	decode(fcr.status_code,
		'A', 'Waiting',
		'B', 'Resuming',
		'C', 'Normal',
		'D', 'Cancelled',
		'E', 'Error',
		'F', 'Scheduled',
		'G', 'Warning',
		'H', 'On Hold',
		'I', 'Normal',
		'M', 'No Manager',
		'Q', 'Standby',
		'R', 'Normal',
		'S', 'Suspended',
		'T', 'Terminating',
		'U', 'Disabled',
		'W', 'Paused',
		'X', 'Terminated',
		'Z', 'Waiting') status,
	decode(fcr.phase_code,
		'C', 'Completed',
		'I', 'Inactive',
		'P', 'Pending',
		'R', 'Running') phase,
	fcr.completion_text
from
	fnd_concurrent_requests fcr,
	fnd_concurrent_programs fcp,
	fnd_concurrent_programs_tl fcpt,
	fnd_user fu,
	fnd_responsibility fr
where
	fcr.status_code in ('Q', 'I') and
	fcr.hold_flag = 'N' and
	fcr.requested_start_date > sysdate and
	fu.user_id = fcr.requested_by and
	fcr.concurrent_program_id = fcp.concurrent_program_id and
	fcr.concurrent_program_id = fcpt.concurrent_program_id and
	fcr.responsibility_id = fr.responsibility_id
order by
	fcr.requested_start_date,  fcr.request_id;

References

Concurrent Processing – What are the Meaning of the Codes in the STATUS_CODE and PHASE_CODE Columns of FND_CONCURRENT_REQUESTS Table? [ID 152209.1]