Host concurent programs not associated with DB session id

Hi All,

We have submitted host concurrent request( tnap_trinv_report.sh).

Some time the request is completed normal within 2 to 3 minutes.

sometimes the request is running  for long time ( more than 20 hours) and that time when we try to find the associated SID at DB side there is no session found.

-----------------------------------------------------------

SQL> select sid,serial# from v$session where paddr in(select addr from v$process where spid in (select ORACLE_PROCESS_ID  from fnd_concurrent_requests where request_id='14589361'));

no rows selected

-----------------------------------------------------------

But we could see  in v$session that sid with module (01@<pappl/tncus/11.5.0/sql/tnap_trinv_report.sql) running at the database side.