Conc Request Info:
SELECT logfile_name, logfile_node_name, outfile_name, outfile_node_name,
controlling_manager
FROM fnd_concurrent_requests
WHERE request_id = &&request_id
Internal Concurrent Manager log file and node name:
SELECT logfile_name "Filename", node_name "Nodename"
FROM (SELECT *
FROM fnd_concurrent_processes
WHERE queue_application_id = 0 AND concurrent_queue_id = 1
ORDER BY concurrent_process_id DESC)
WHERE ROWNUM = 1
Scheduled Reqs Info :
select request_id from fnd_concurrent_requests
where status_code in ('Q','I')
and requested_start_date > SYSDATE
and hold_flag = 'N';
UR's Key Run ;-)
No comments:
Post a Comment