How to restrict single session per user in 11i and R12

To implement an “Single Session per User” restriction that one user credential can not be used simultaneously. In Oracle E-Business Suite release 11i, a patch was required (#3861070). This patch installed the oracle.apps.icx.security.session.created event and the event subscription to enable a single login per user . If a specific user logs in to the application and a previous, valid session is still active, the previous session(s) are immediately invalidated by the event. Please notice that, for evident reasons, the event will not fire for the following users:

Sysadmin
Guest
Anonymous

Please make sure that, the classpath environment variable is correctly set and that the location of the java executable is included in the PATH environment variable.

Release 11i:

Load the event with the command:
java oracle.apps.fnd.wf.WFXLoad -u < apps_un > < apps_pw > < apps_dbserver.+fqdn >:< db_port >:< SID >  thin US \
$ICX_TOP/patch/115/xml/US/icxevte.wfx

Load the event subscription:
java oracle.apps.fnd.wf.WFXLoad -u < apps_un > < apps_pw > < apps_dbserver.+fqdn >:< db_port >:< SID > thin US \
$ICX_TOP/patch/115/xml/US/icxevts.wfx

In Oracle E-Business Suite release 12, there is no need to apply any patch as the files required are already present in the filesytem. The instructions are below:

Load the event with the command: java oracle.apps.fnd.wf.WFXLoad -u < apps_un> < apps_pw> < apps_dbserver.+fqdn>:< db_port>:< SID> thin US \ $FND_TOP/patch/115/xml/US/icxevte.wfx

Load the event subscription: java oracle.apps.fnd.wf.WFXLoad -u < apps_un> < apps_pw> < apps_dbserver.+fqdn>:< db_port>:< SID> thin US \ $FND_TOP/patch/115/xml/US/icxevts.wfx

You can enable/disable the business event through the System Administrator > Business Events screen (SYSADMIN user only) by searching for the word ’security’. It will pull up the oracle.apps.icx.security.session.created event. Click on the Update icon and enable/disable. You then need to close all browsers for the change to take affect.

Related Posts by Categories