Search Results fnd_sessions_pk

Overview

The FND_SESSIONS table is a core technical table within the Oracle E-Business Suite (EBS) Application Object Library (AOL). Owned by the APPLSYS schema, it functions as a real-time registry for active user and process sessions within the application. Its primary role is to provide a centralized repository for session-level data, enabling the system to manage, monitor, and maintain the state of concurrent user interactions and background processes. This table is integral to the foundational architecture of EBS, supporting session tracking, security context, and the association of concurrent manager processes with their runtime sessions.

Key Information Stored

The table's structure is designed to capture essential session identifiers and attributes. The primary key, SESSION_ID, uniquely identifies each active session. While the full column list is not detailed in the provided metadata, based on its standard implementation, FND_SESSIONS typically stores critical data points such as the session creation timestamp, the associated user ID (often linking to FND_USER), the process ID (PID) of the operating system process, the terminal identifier, and the session's current state. The presence of the SESSION_ID column as a foreign key in the FND_CONCURRENT_PROCESSES table explicitly confirms its role in linking submitted concurrent requests to their executing session context.

Common Use Cases and Queries

This table is primarily accessed for system administration, performance monitoring, and troubleshooting. Common operational queries include identifying long-running or stalled sessions, auditing user activity, and diagnosing issues with concurrent managers. A typical query involves joining with FND_USER to resolve session IDs to usernames and with FND_CONCURRENT_REQUESTS to analyze running jobs.

• Identifying Active Sessions: SELECT s.session_id, u.user_name, s.creation_time FROM fnd_sessions s, fnd_user u WHERE s.user_id = u.user_id;
• Investigating Concurrent Manager Sessions: SELECT cp.concurrent_process_id, s.session_id FROM fnd_concurrent_processes cp, fnd_sessions s WHERE cp.session_id = s.session_id;
• Session Cleanup: Administrators may reference this table to identify and terminate orphaned or abnormal sessions that are no longer active but still hold system resources.

Related Objects

FND_SESSIONS has a direct and documented relationship with several key AOL objects. The most significant is its parent-child relationship with the FND_CONCURRENT_PROCESSES table, where FND_SESSIONS.SESSION_ID is referenced as a foreign key. This links every running concurrent manager process to an entry in the sessions table. Furthermore, sessions are intrinsically linked to user identity via the FND_USER table, typically through a USER_ID column. For comprehensive session analysis, queries often also involve FND_CONCURRENT_REQUESTS to understand the specific job being processed within a session. The table's primary key constraint, FND_SESSIONS_PK, enforces the uniqueness of the SESSION_ID.