How can I Restrict Applications Users To Be Signed In Only Once At Any Time
As we know that by default any given user can by default open multiple sessions with Oracle Applications.
Use the following SQL to confirm if the event already exists and is enabled
SQL>select name, status from wf_events evt where name ='oracle.apps.icx.security.session.created';
If the event does not exist, follow the steps to load both the Event itself and also the Event Subscription
The event will not fire for the following users:
- SYSADMIN
- GUEST
- ANONYMOUS
INSTRUCTIONS TO LOAD THE EVENT:
The term +fqdn refers to "Fully Qualified Domain Name".
Release 11i:
From UNIX:
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
From Windows:
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
Release 12:
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
From Windows:
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
Example:-
java oracle.apps.fnd.wf.WFXLoad -u apps apps prdapps.prds.com:1548:GST thin US $FND_TOP/patch/115/xml/US/icxevte.wfx
Oracle Workflow XML Loader 2.6.4.0.0
Connecting to apps@prdapps.prds.com:1548:GST -- UTF8
Connected to prdapps.prds.com.com:1548:GST
Loaded 1 object to the database...
Upload completed successfully.
INSTRUCTIONS TO LOAD THE EVENT SUBSCRIPTION
From UNIX:
Release 11i:
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
From Windows:
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
Release 12:
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
From Windows:
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
Example:-
java oracle.apps.fnd.wf.WFXLoad -u apps apps prdtest.prdapps.prds.com.com:1548:GST thin US \ $FND_TOP/patch/115/xml/US/icxevts.wfx
[appltest@prdtest ~]$ java oracle.apps.fnd.wf.WFXLoad -u apps apps prdapps.prds.com.com:1548:GST thin US $FND_TOP/patch/115/xml/US/icxevts.wfx
Oracle Workflow XML Loader 2.6.4.0.0
Connecting to apps@prdapps.prds.com.com:1548:GST -- UTF8
Connected to prdapps.prds.com.com:1548:GST
Loaded 1 object to the database...
Upload completed successfully.
SQL> select name, status from wf_events evt where name ='oracle.apps.icx.security.session.created';
NAME
--------------------------------------------------------------------------------
STATUS
--------
oracle.apps.icx.security.session.created
ENABLED
Workaround to allow additional Application Users to be allowed more than one concurrent user session.
1. Take a backup of table wf_event_subscriptions
2. Run the following sql to allow the TESTUSER to start more than one user session. Replace TESTUSER for the user to be restricted.
SQL>update wf_event_subscriptions set parameters ='excludedUsers=SYSADMIN,GUEST,ANONYMOUS','TESTUSER' where EVENT_FILTER_GUID = '8FD5D7F235A83E41E03408002092A95D';
SQL>commit;
How to enable or disable the event oracle.apps.icx.security.session.created
1. Login to E-Business and navigate to Workflow Administrator Web Application > Business
Event.Search for oracle.apps.icx.security.session.created
2. Then click on clock symbol under the Subscription column. Use the pencil beside
subscription icx_sec.doNewSessionEvent to access its definition and enable or disable it.
3. Shutdown and restart the Workflow Agent Listener Service.
Reference document (Doc ID 375403.1)
