Find Concurrent manager logs on Oracle App
Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.
cd $APPLCSF/$APPLLOG
For ICM Log –> ls -lrt *$TWO_TASK*
For Standard manager Log –> ls -lrt w*.mgr
For Conflict Resolution manager Log –> ls -lrt c*.mgr
We can also get the ICM manager logfile location with below 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';
Sample Output:
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
-----------------------------------------------------------
ICM_LOG_NAME=/ebis/ebisapps/ebiscomn/admin/log/PRODDB_ebis/PRODDB_0417.mgr
No comments:
Post a Comment