How to limit the User concurrent login sessions in E-Business Suite

In Oracle E-Business suite, a user can login to any number of sessions concurrently. EBS doesnot really restrict the user login sessions.

For ex., a user PLMMGR can login to EBS from two different browsers at the same time and perform actions in both the sessions.

We can however prevent such a concurrency by using the Business Event "oracle.apps.icx.security.session.created "


The event "oracle.apps.icx.security.session.created" if enabled will fire when ever a new session is created.

The event is raised via WF_EVENT.RAISE and it executes a rule function that takes the session_id and the fnd_user.user_id as parameters. This function will execute the following SQL script:

UPDATE ICX_SESSIONS
SET DISABLED_FLAG='Y'
WHERE USER_ID = <fnd_user>
AND SESSION_ID != <session_id>
What it basically does is to invalidate all other sessions of the same user. This way only one session persists for a user at any point of time.

reference: oracle metalink note 375403.1