Trace enable program details:
SELECT A.CONCURRENT_PROGRAM_NAME "Program Name",
SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,40) "User Program Name",
SUBSTR(B.USER_NAME,1,15) "Last Updated By",
SUBSTR(B.DESCRIPTION,1,25) DESCRIPTION
FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPLSYS.FND_USER B
WHERE A.ENABLE_TRACE='Y'
AND A.LAST_UPDATED_BY=B.USER_ID;
ALTER SESSION SET nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
SELECT
USER_CONCURRENT_PROGRAM_NAME,
RESPONSIBILITY_NAME,
REQUEST_DATE,
ACTUAL_START_DATE,
ACTUAL_COMPLETION_DATE,
ARGUMENT_TEXT,
REQUEST_ID,
PHASE_CODE,
STATUS_CODE,
LOGFILE_NAME,
OUTFILE_NAME,
OUTPUT_FILE_TYPE
FROM
FND_CONCURRENT_REQUESTS FCR,
FND_CONCURRENT_PROGRAMS_TL FCP,
FND_RESPONSIBILITY_TL FR,
FND_USER FU
WHERE
FCR.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND FCR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
AND FCR.REQUESTED_BY = FU.USER_ID and ACTUAL_START_DATE='05-OCT-2024 10:10:10'
ORDER BY REQUEST_DATE DESC;
SELECT distinct t.user_concurrent_program_name,
r.REQUEST_ID,u.USER_NAME,
to_char(r.ACTUAL_START_DATE,'dd-mm-yy hh24:mi:ss') "Started at",
to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss') "Completed at",round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60)) Etime,
decode(r.PHASE_CODE,'C','Completed','I','Inactive','P ','Pending','R','Running','NA') phasecode,
decode(r.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') "Status",r.argument_text "Parameters"
FROM
apps.fnd_concurrent_requests r ,
apps.fnd_concurrent_programs p ,
apps.fnd_concurrent_programs_tl t,
apps.fnd_user u, apps.fnd_conc_req_summary_v v
WHERE
r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID
AND r.actual_start_date >= (sysdate-103)
--AND r.requested_by=22378
AND r.PROGRAM_APPLICATION_ID = p.APPLICATION_ID
AND t.concurrent_program_id=r.concurrent_program_id
AND r.REQUESTED_BY=u.user_id
AND v.request_id=r.request_id
--AND r.request_id ='2260046' in ('13829387','13850423')
and t.user_concurrent_program_name like '%Purge%'
order by to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss');
Kill all processes of FNDLIBR.
ps -ef |grep FNDLIBR | grep -v grep | awk '{print $2}' | xargs kill -9
SELECT a.request_id,
d.sid,
d.serial#,d.sql_id,
d.osuser,
c.spid AS db_spid,
d.inst_id AS rac_instance
FROM apps.fnd_concurrent_requests a
JOIN apps.fnd_concurrent_processes b ON a.controlling_manager = b.concurrent_process_id
JOIN gv$process c ON c.pid = b.oracle_process_id
JOIN gv$session d ON d.audsid = b.session_id
WHERE a.request_id in ('142555872','142555871');
SELECT concurrent_program_id,
user_concurrent_program_name
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name LIKE '%TAS%BETC%';
UPDATE fnd_concurrent_requests
SET phase_code = 'C', -- Completed
status_code = 'X', -- Terminated
completion_text = 'Forcefully terminated by Ram'
WHERE concurrent_program_id = 346365
AND phase_code = 'R';
COMMIT;
