Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, August 13, 2015

EBS 11i: Fnd the ICM current logfile


--To find the ICM current logfile

SELECT 'LOG=' || cp.logfile_name LogFile
FROM fnd_concurrent_processes cp, fnd_concurrent_queues cq
WHERE cp.concurrent_queue_id = cq.concurrent_queue_id
AND cp.queue_application_id = cq.application_id
AND cq.manager_type = '0' AND cp.process_status_code = 'A';

No comments: