Search Results listener_token

Overview

ORACLESSWA is the Oracle Self-Service Web Applications (SSWA) session and navigation package shipped in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It provides the server-side plumbing that lets a user move between self-service pages, bookmark a page in a way the framework can restore, and establish a trustworthy session when a user arrives through an external single sign-on (SSO) provider rather than the standard EBS login form. The package is declared AUTHID CURRENT_USER, so its statements execute with the privileges of the calling session rather than as APPS. Its header carries the $Header: ICXSSWAS.pls 120.0 signature, indicating an ICX (Interaction Center / self-service) family file with no shipping changes since 2005, which is consistent with its role as a stable, low-churn interface rather than a feature-rich API. The package is documented in ETRM with the API classification OTHER, owner APPS, and ten public procedures and functions.

Key Procedures and Functions

• BOOKMARKTHIS — Records the current self-service location so the user can return to it, using the supplied token and an optional second argument.
• FWKBOOKMARKTHIS — The Oracle Application Framework (OA Framework) variant of the bookmark operation. The source comments note it performs additional work for the current responsibility portlet, including invalidating cached versions associated with the current user.
• SWITCHPAGE — Changes the active page within the self-service framework, using a page name supplied by the caller.
• LISTENER_TOKEN — A function that constructs the listener token for the session. This is the object returned when users search for "listener_token"; it is the package's token-generation entry point rather than a stored column or form field.
• SIGN_ON — SSO callback used to create a valid OSSWA session once an external identity has been accepted, taking the callback URL as input.
• NAVIGATE — Performs navigation for the session.
• CONVERTSESSION — Converts an existing session into the form required by the SSWA framework.
• EXECUTE — Dispatches execution using a function, event, parameter, and location argument, defaulting each to NULL.
• SSOREDIRECT — Returns a string redirect target for SSO, accepting an optional request URL and cancel URL.
• LOGOUT — Terminates the self-service session.

Tables Accessed

Through APPS synonyms the package touches ICX_SESSIONS for session state and ICX_PORTLET_CUSTOMIZATIONS for user portlet layout used by FWKBOOKMARKTHIS, plus FND_USER and FND_FORM_FUNCTIONS for identity and function-security checks. FND_PRODUCT_GROUPS supplies installation context. It additionally uses DBMS_SQL, DBMS_UTILITY, and the HTP, OWA_COOKIE, and OWA_UTIL PL/SQL web toolkit packages to emit HTML and manage cookies during SSO handoff and logout.

Usage Notes

ORACLESSWA is not intended for direct form or concurrent program invocation. It is called by the SSWA and OA Framework runtime, by SSO integrations implementing the sign-on callback and redirect, and occasionally by custom code that must reproduce framework bookmark or navigation behaviour. Two other packages in the instance reference it. Because it relies on OWA/HTF packages, callers must be running inside the mod_plsql (Apache/OC4J) request path, not a database batch job.