DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, March 10, 2016

Query to Get the ICM Manager Logfile Location

STEPS:

* Log-in to the Apps User
* Run Source environment file
* Connect to sqlplus and run this query

SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name
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’;

No comments: