Tuesday, March 19, 2019

ICM log file location in R12 oracle EBS

                      ****ICM log file location in EBS R12****


All concurrent log files stay at the location $APPLCSF/$APPLLOG

1) Login into Apps environment and source the env file.

2) Go to $APPLCSF/$APPLLOG location

3) ls -lrt *$TWO_TASK*

[****@*****log]$ ls -lrt *$TWO_TASK*
-rw-r--r-- 1 24852359 Mar 20 01:07 KAPI_0801.mgr

4) Identify the internal concurrent manager log file (SID_MMDR.mgr)

5) If you want to identify other manager log files.

******Standard manager log:  wxxxx.mgr.   (xxxx represents Process ID )

                      EX :: -rw-rw-r-- 1 ****** 624100 Mar 20 01:09 w19983.mgr

***** Conflict resolution manager log :: cxxx.mgr  

                   EX: [***@*****log]$ ls -ltr c*.mgr
                              -rw-rw-r-- 1 **** ***1021 Nov  4 01:00 c19947.mgr

***** Transaction manager log:  txxxx.mgr

                  EX :: -rw-rw-r-- 1 *** *** 2672 Feb 28 13:24 t19939.mgr



Option 2
======

You can identify ICM log file using 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';

EX ::

SQL> 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';
  2    3    4    5    6  
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
--------------------------------------------------------------------------------
ICM_LOG_NAME=/u01/app/****/KLSPI/inst/apps/KLSPI_servername/logs/appl/conc/lo
g/KLSPI_0801.mgr

Option 3
======

We can identify ICM log file from frontend.

Log in to Sysadmin Responsibility

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

Thanks
Sreeharsha.



No comments:

Post a Comment