Wednesday 2 June 2010

Current ICM logfile and logfile, output file from concurrent request

--To findout the ICM current logfile
SELECT 'LOG=' || fcp.logfile_name LogFile
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'AND fcp.process_status_code = 'A';


--to find the log file and output file from concurrent request
SELECT REQUEST_ID,logfile_name, outfile_name, outfile_node_name, last_update_date
FROM apps.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =&Req_ID

Related Posts by Categories



No comments: