Saturday, 11 August 2012

How to find ICM log on Oracle Apps 11i and 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
Option2:
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=/applprod/comndev/admin/log/DEV_moon1/DEV_0426.mgr
Option3:
Log in to Sysadmin Responsibility
Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.

No comments:

Post a Comment

Number of Visitors