DOYENSYS Knowledge Portal




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




Friday, February 12, 2016

ICM Log Files location can be found from SQL Query


SELECT logfile_name FROM (
SELECT fcp.logfile_name,fcp.concurrent_process_id,fcp.last_update_date,fcp.creation_date,fcp.session_id,
fcp.process_status_code
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'
ORDER BY SESSION_ID DESC)
A WHERE 1=1 AND ROWNUM<4;




1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.