ORACLE_SESSION_ID from FND_CONCURRENT_REQUESTS doesn't reference any existing session in v$session
Could you explain the difference between fnd_concurrent_requests.oracle_session_id and fnd_concurrent_processes.session_id please? I can see they can be different and as well sometimes they may not have corresponding row in v$session. Also I can see that session_id related to fnd_concurrent_processes.oracle_process_id is different than fnd_concurrent_processes.session_id.
I ran the below query in my system:
SELECT e.executable_name, r.oracle_session_id request_session_id, (SELECT 'Y' FROM v$SESSION WHERE audsid = r.oracle_session_id) r_session_exists, pc.session_id process_session_id