I have two cocnurrent programs say TEST_PROG1, TEST_PROG2.
if i am submitting TEST_PROG1 then oracle session id and oracle process id are popluating in fnd_concurrent_requests table
where as if iam doing the same with TEST_PROG2 then oracle session id and oracle process id are populating as null.
Is there any configuration problem with the second problem?
And if i amtrying to kill the request of TEST_PROG2, Using the below query
FROM fnd_concurrent_requests r,
WHERE 1 =1
AND r.request_id = 2998345;
AND r.oracle_session_id = s.audsid(+);
AND r.request_date > TRUNC(SYSDATE-1)
AND r.status_code NOT IN ('C','E','D','X');
which is returning null .But iam using serial#, audsid to kill the session
l_sql := 'alter system kill session '''|| l_sid || ','||l_serial_number||'''';
but iam unable to kill the session as thwy are getting null from the above sql.
Please help me to resolve this.
I have seen the metalink 735119.1 that was provided in the given link. There is a query
FROM v$session ses,
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
WHERE request_id = &request_id);
But for my request, oracle_process_id is inserting as null
can you please help me in this.
Please post the details of the application release, database version and OS.
Does this happen to all concurrent programs or specific ones only?
Is this a custom concurrent program? If yes, please see Unable to get trace for custom reports in 184.108.40.206
Followed the link shared and in one of your replied i found the below I am not sure why there are no values stored in FND_CONCURRENT_REQUESTS table (for some columns) when you submit such reports, and I believe if this is resolved you will be able to see the trace files generated. So, is it possible to register any of these custom reports in one of the standard responsibilities and see if the values in the table are populated and/or the trace file get generated then?
I have added my concurrent program to US HRMS Reports & Processes request group. But still the same problem