Tuesday, November 6, 2018

How to find ICM log on Oracle R12

All Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.

The following bellow options are available to get the latest log files.


Option1:

Login to Apps User and source environment file

cd $APPLCSF/$APPLLOG
ls -lrt *$TWO_TASK*
  • Internal Concurrent Manager Log:_MMDD.mgr
Here you can see other list of log files which are related to concurrent mangers.The name conversation for the concurrent manger log files are
  • Standard manager log: w.mgr
  • Transaction manager log: t.mgr 
  • Conflict Resolution manager log: c.mgr

Where: is the concurrent process id of the manager?

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';

Sample Output:

'ICM_LOG_NAME='||FCP.LOGFILE_NAME
--------------------------------------------------------------------------------
ICM_LOG_NAME=/clu01/testprdapp/fs_ne/inst/<HN>_wapmlofap01/logs/appl/conc/log
/test_1106.mgr


Log in to Sysadmin Responsibility

Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.

No comments: