Friday, November 11, 2016

Concurrent Program Queries



Some of the queries we can use:


select prog.user_concurrent_program_name,
prog.concurrent_program_name,
appl.application_name,
prog.description,
exe.executable_name,
exe.execution_file_name,
decode( exe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader', exe.execution_method_code)
from apps.fnd_executables exe,
apps.fnd_application_tl appl,
apps.fnd_concurrent_programs_vl prog
where prog.application_id = appl.application_id
AND exe.executable_id = prog.executable_id
AND prog.user_concurrent_program_name = 'Autoinvoice Import Program';


Status for submitted concurrent requests:




SELECT DISTINCT fcp.user_concurrent_program_name,
                fcp.concurrent_program_name,
                fcr.request_id,
                fcr.request_date,
                flv.meaning status,
                fcr.status_code,
                fcr.completion_text,
                fcr.logfile_name,
                fcr.outfile_name,
                fcr.argument_text
  FROM apps.fnd_concurrent_programs_vl fcp,
       apps.fnd_concurrent_requests    fcr,
       apps.fnd_lookup_values          flv
 WHERE fcr.concurrent_program_id = fcp.concurrent_program_id
   AND trunc(fcr.last_update_date) = trunc(SYSDATE)
   AND user_concurrent_program_name like '%Create%Sett%'
   AND flv.lookup_code = fcr.status_code
   AND flv.lookup_type = 'CP_STATUS_CODE'
   AND flv.language = 'US'
 ORDER BY fcr.request_date,
          fcr.request_id DESC;

Concurrent program request log file with location

select logfile_name from apps.fnd_concurrent_requests 
where request_id = &request_id;


FND_CONCURRENT_REQUESTS status columns



PHASE_CODE

C - Completed
I - Inactive
P - Pending
R - Running

STATUS_CODE

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.

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...