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;
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
Concurrent program phase code and
status code Details
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
Post a Comment