Странице

Ознаке

четвртак, 21. март 2013.

Concurrent manager log location


With the following query you can get log location of concurrent manager:
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';
-----------------------------------------------------------------------

'ICM_LOG_NAME='||FCP.LOGFILE_NAME                                            
--------------------------------------------------------------------------------
ICM_LOG_NAME=/d02/oracle/TEST/inst/apps/TEST_prod2/logs/appl/conc/log/TEST_0321.
mgr

default location
$APPLCSF/$APPLLOG
Another possible location
$FND_TOP/log 

Нема коментара:

Постави коментар

Напомена: Само члан овог блога може да постави коментар.