Concurrent manager log file locations in R12.2


Concurrent manager log file location:
Concurrent manager log files are located under $APPLCSF and $APPSLOG home

[oracle@VIS ~]$cd $APPLCSF

[oracle@VIS conc]$pwd
/apps/applmgr/fs_ne/inst/VIS/logs/appl/conc

[oracle@VIS conc]$cd log/

[oracle@VIS log]$pwd
/apps/applmgr/fs_ne/inst/VIS/logs/appl/conc/log
[oracle@VIS log]$

Internal concurrent manager log file:
[oracle@VIS log]$ls -lrt *$TWO_TASK*

Standard manager log file:
[oracle@VIS log]$ls -lrt w*.mgr

Conflict resolution manager log file:
[oracle@VIS log]$ ls -lrt c*.mgr

Output post processer log file:
[oracle@VIS log]$ps -ef |grep OPP

Concurrent program related some basic SQL queries

How to find concurrent program status?
SQL> select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’1234567’;

How to find concurrent request output and log file location?
SQL> select LOGFILE_NAME, OUTFILE_NAME from fnd_concurrent_requests where request_id='1234567';

How to find which concurrent manger ran a specific concurrent request?
SQL> select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a,fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID and a.CONCURRENT_PROCESS_ID = c.controlling_manager and c.request_id ='856272604';

How many rows are in FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES tables?
select count(*) from FND_CONCURRENT_REQUESTS;
select count(*) from FND_CONCURRENT_PROCESSES;


Concurrent program phase code and status code Details

STATUS_CODE Column:

A Waiting
B Resuming
C Normal
D Cancelled
E Error
F Scheduled
G Warning
H On Hold
I Normal
M No Manager
Q Standby
R Normal
S Suspended
T Terminating
U Disabled
W Paused
X Terminated
Z Waiting

PHASE_CODE column

C Completed
I Inactive
P Pending
R Running



Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2