Tuesday 18 June 2019

How to find ICM log file on Oracle EBS 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:  SID_MMDD.mgr   (Example: UAT_0923.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:                   wxxxx.mgr      (Example : w20863.mgr)
·                     Transaction manager log:                txxxx.mgr       (Example : t20847.mgr )
·                     Conflict Resolution manager log:     cxxxx.mgr       (Example : c20852.mgr )
Where xxxx 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.


Source: Internet/R&D

No comments:

Post a Comment