WebFeb 23, 2024 · fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcptl where fcr.request_id = x.request_id and fcr.concurrent_program_id = fcp.concurrent_program_id and fcr.program_application_id = fcp.application_id and fcp.application_id = fcptl.application_id and fcp.concurrent_program_id = fcptl.concurrent_program_id and … WebApr 24, 2024 · apps.fnd_concurrent_processes b, gv$process c, gv$session d WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = b.oracle_process_id AND b.session_id=d.audsid AND d.sid = &SID; 11. Find out request id from Oracle_Process Id: select REQUEST_ID,ORACLE_PROCESS_ID,OS_PROCESS_Id from …
ORACLE_SESSION_ID from FND_CONCURRENT_REQUESTS doesn
WebMay 15, 2024 · apps.fnd_concurrent_processes b, gv$process c, gv$session d WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = b.oracle_process_id AND b.session_id=d.audsid AND a.request_id = &Request_ID AND a.phase_code = ‘R’; 5. To find concurrent program name, phase code, and status code for a given request id? WebFeb 9, 2024 · select request_id ,phase_code, status_code from fnd_concurrent_requests where request_id ='333333'; 5. Check which CM is running this request. SELECT request_id, user_concurrent_program_name,... dates of paul\u0027s first missionary journey
How to troubleshoot long running concurrent request in R12.2
WebOct 21, 2024 · Query to find which Concurrent Manager Ran a Specific Concurrent Request 1. Get the request_id 2. Log into SQL*Plus as the APPS user. 3. Run one of the scripts below: For Single Request ID select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c WebFND_CONCURRENT_PROCESSES This table records information about Oracle Applications and operating system processes. FND_CONC_STAT_LIST This table … bizzy phillips net worth