Search Results getnls_parameter

Overview

FND_SESSION_MANAGEMENT is the core session-tracking package in Oracle E-Business Suite, responsible for creating, validating, and maintaining web user sessions within the Oracle Applications framework. It is owned by APPS and classified as an OTHER API. In EBS 12.1.1 and 12.2.2 it underpins the ICX (Internet Computing Architecture) session model, generating session identifiers, transaction identifiers, and cross-site identifications (XSID), and raising or completing the associated workflow events that control session lifecycle. Because the Applications Framework (OAF), Forms-based HTML pages, and the login servlet all rely on the package, it is one of the most heavily referenced utilities in the technology stack, referenced by 15 other packages in the EBS schema.

Key Procedures and Functions

• NEWSESSIONID and NEWXSID — generate a unique session_id (via fnd_crypto.SmallRandomNumber) and a URL-encoded XSID, looping against ICX_SESSIONS to ensure uniqueness.
• NEWTRANSACTIONID — two overloads that return a unique transaction_id, validated against ICX_TRANSACTIONS, optionally scoped to a supplied session.
• CREATESESSION and CREATETRANSACTION — persist new session and transaction rows.
• NEWSESSIONRAISEEVENT, DONEWSESSIONEVENT, VALIDATESESSION_PRAGMA and VALIDATESESSIONPRIVATE — manage the workflow event that signals session creation/completion and enforce session validation via a pragma wrapper and private implementation.
• CONVERTGUESTSESSION — promotes an anonymous guest session to an authenticated one.
• REMOVETRANSACTION — deletes a transaction record at end of use.
• SETSESSIONPRIVATE, INITIALIZESSWAGLOBALS and UPDATESESSIONCONTEXT — initialise and maintain server-side session context.
• GETID — returns the current session identifier.
• PUTSESSIONATTRIBUTEVALUE, GETSESSIONATTRIBUTEVALUE and CLEARSESSIONATTRIBUTEVALUE — read, write, and clear session attributes.
• GETSESSIONCOOKIENAME — returns the cookie name used to track the session in the browser.
• GETNLS_PARAMETER — retrieves the NLS parameter value (for example language, territory, or character set) associated with the session, reading from FND_LANGUAGES to resolve naming-language settings. This is the function commonly referenced by customisations that need to honour the user's session-level NLS configuration.

Tables Accessed

Session state is persisted in ICX_SESSIONS and ICX_TRANSACTIONS, while ICX_SESSION_ATTRIBUTES stores per-session key/value data and ICX_PARAMETERS holds framework parameters. FND_USER and FND_NODES supply user and middle-tier node information. FND_LANGUAGES and FND_FORM_FUNCTIONS serve the NLS and function-security lookups, including for GETNLS_PARAMETER. Workflow integration uses WF_EVENT_T, WF_EVENT_SUBSCRIPTIONS, WF_PARAMETER_LIST_T and WF_PARAMETER_T. ICX_PORTLET_CUSTOMIZATIONS supports portal-level session behaviour, and DUAL plus PLITBLM support PL/SQL internal operations.

Usage Notes

FND_SESSION_MANAGEMENT is invoked implicitly by the EBS login flow, the Oracle Applications Framework, and enabled Forms sessions rather than being called directly by end users. Custom code should call the documented API functions (for example GETNLS_PARAMETER or GETSESSIONATTRIBUTEVALUE) rather than querying the underlying ICX tables, since the package encapsulates the required validation and event handling. Its role in session creation and validation means it executes on every web request in a 12.1.1 or 12.2.2 environment, making its parameters and attributes the authoritative source for session-scoped NLS and context values.