****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
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