Search Results fnd_session_values_pk1

Overview

The FND_SESSION_VALUES table is a core technical repository within the Oracle E-Business Suite (EBS) Application Object Library (FND). Its primary role is to persist servlet session state data for the application's web-tier components. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is essential for maintaining user-specific data across HTTP requests, enabling the stateless HTTP protocol to support stateful application interactions. It is owned by the APPLSYS schema and functions as a backing store for session attributes managed by the Oracle Applications Framework (OAF) and other Java-based servlets, ensuring data continuity and user context preservation throughout a logged-in session.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is centered around a session identifier. The primary documented column is ICX_SESSION_ID, which forms the table's primary key (FND_SESSION_VALUES_PK1). This column stores the unique identifier for a user's application session, typically corresponding to the session ID managed by the mod_plsql or Java servlet engine. While the specific content columns are not detailed in the excerpt, such tables commonly store serialized attribute name-value pairs, timestamps for creation and last access, and potentially the serialized state of application modules or pages. The data stored is proprietary and transient, tied directly to the lifecycle of an active user session.

Common Use Cases and Queries

This table is primarily accessed by the EBS application runtime rather than through direct end-user queries. Key operational use cases include session management, troubleshooting, and administrative cleanup. System administrators may query it to diagnose session-related issues, monitor active session counts, or purge orphaned session data. A typical diagnostic query would join on the ICX_SESSIONS table using the ICX_SESSION_ID to correlate session values with user information.

• Sample Query for Active Session Context: SELECT sv.icx_session_id, s.user_id, s.last_connect FROM fnd_session_values sv, icx_sessions s WHERE sv.icx_session_id = s.session_id AND s.disabled_flag != 'Y';
• Use Case - Orphaned Data Cleanup: Identifying session values for which the parent session record no longer exists, often performed during system maintenance.

Related Objects

The primary documented relationship for the FND_SESSION_VALUES table is through its primary key, ICX_SESSION_ID. This column is a foreign key reference to the ICX_SESSIONS table, which is the master repository for all EBS user session information. The relationship, defined by the FND_SESSION_VALUES_PK1 constraint, ensures referential integrity between a session's persisted values and its core metadata (such as user ID, start time, and timeout). Consequently, any join or analysis of FND_SESSION_VALUES will almost invariably involve the ICX_SESSIONS table to provide meaningful user and session context. Other related objects may include FND_SESSIONS and underlying Java servlet framework packages that read from and write to this persistent store.