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.

Login to Apps User and source environment file
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:
Log in to Sysadmin Responsibility
Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.

No comments:

Post a Comment

Number of Visitors