Showing posts with label EBS Logs R12. Show all posts
Showing posts with label EBS Logs R12. Show all posts

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.