----------------------------------- -Pending with Standard Manager Count ----------------------------------- select count(cwr.request_id) "pending with Standard Manager" FROM apps.fnd_concurrent_worker_requests cwr, apps.fnd_concurrent_queues_tl cq, apps.fnd_user fu WHERE (cwr.phase_code = 'P' OR cwr.phase_code = 'R') AND cwr.hold_flag != 'Y' AND cwr.requested_start_date <= SYSDATE AND cwr.concurrent_queue_id = cq.concurrent_queue_id AND cwr.queue_application_id = cq.application_id and cq.LANGUAGE='US' AND cwr.requested_by = fu.user_id and cq.user_concurrent_queue_name in ( 'Standard Manager') /
Tuesday, September 17, 2013
Pending Concurrent Requests count with Standard Manager
Subscribe to:
Post Comments (Atom)
NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL
Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...
-
I got a task to estimate RMAN backup size. How much 3days RMAN backup occupy? How long it will take to complete? Is the backup siz...
-
I got the below issue while Cloning ORACLE HOME from source to target. I have copied the binaries from source and initiated adcfclone. It ...
-
We have received an alert in the morning that the Primary Database is out of Sync. Primary and Standby are with difference of 9 archives. ...
No comments:
Post a Comment