Search Results default_user

Overview

APP_SESSION is a core Oracle E-Business Suite package that governs session establishment and identity resolution within the APPS schema. Its primary business function is to bootstrap and manage ICX (Oracle Applications Framework session) sessions for authenticated users, bridging Oracle Single Sign-On (SSO) identities to EBS security contexts. The package body, delivered under header revision AFSCSESB.pls, contains the initialization logic that sets the current schema to the APPS database user (identified by ORACLE_ID = 900 in FND_ORACLE_USERID) at the start of a connection. This ensures that all subsequent session operations execute under the correct schema context, a prerequisite for consistent privilege and synonym resolution across the EBS application tier.

Key Procedures and Functions

The package exposes six documented procedures and functions:

• INITIALIZE — Sets the session's current schema to the APPS schema by resolving the schema name from FND_ORACLE_USERID for ORACLE_ID 900 and issuing an ALTER SESSION statement. This is the foundational entry point invoked when a connection is established.
• GET_ICX_COOKIE_NAME — Returns the cookie name that carries the ICX session identifier, delegating to FND_SESSION_MANAGEMENT.GETSESSIONCOOKIENAME. Consumers use it to locate or set the correct session cookie.
• CREATE_ICX_SESSION — Creates or re-establishes an ICX session for an identified user based on their SSO GUID, optionally re-using a prior cookie value, and applying responsibility and security group context. It raises SSO_USER_UNKNOWN, SESSION_CREATION_FAILED, or SECURITY_CONTEXT_INVALID when validation fails. Output is the new ICX cookie value.
• VALIDATE_ICX_SESSION — Confirms that an existing ICX session is still valid, supporting session continuation and integrity checks.
• GET_ALL_LINKED_USERS — Returns the set of users linked to a given identity, supporting multi-account and proxy scenarios.
• GET_DEFAULT_USER — Resolves the default user associated with a session or identity, a function commonly referenced in login and personalization logic.

Tables Accessed

The package reads and writes several core EBS tables through APPS synonyms. FND_USER supplies user identity and account records. FND_APPLICATION and FND_RESPONSIBILITY provide responsibility and application context used to construct valid security contexts. FND_SECURITY_GROUPS defines the security group dimension applied to the session. FND_ORACLE_USERID supplies the APPS schema name used during initialization. ICX_SESSIONS stores and maintains active ICX session records, while PLITBLM serves as a PL/SQL table-backed buffer used internally.

Usage Notes

APP_SESSION is invoked primarily during login and session establishment flows, including SSO authentication, Oracle Applications Framework pages, and forms-based responsibilities. Custom code that programmatically establishes or validates an EBS session—such as single sign-on integrations, portal bridges, or automated test harnesses—calls CREATE_ICX_SESSION and VALIDATE_ICX_SESSION. The package is referenced by three other packages, indicating reuse across session-management utilities. Because GET_DEFAULT_USER and GET_ALL_LINKED_USERS resolve identity relationships, they are frequently consulted by personalization and security routines. Developers should treat the package as a supported internal API; direct modification is not advisable, and error conditions should be handled explicitly given the documented exceptions raised during session creation.