Core Concurrent Processing - EBS (MOSC)

MOSC Banner

ORACLE_SESSION_ID from FND_CONCURRENT_REQUESTS doesn't reference any existing session in v$session

edited Apr 16, 2012 2:38AM in Core Concurrent Processing - EBS (MOSC) 9 commentsAnswered
Hello.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center