+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Oracle EBS R11i, R12.1, R12.2 Installation, Administration (http://www.oraerp.com/forum-5.html)
+---- Thread: Expire Users Automatically after Inactivity (/thread-60.html)
Expire Users Automatically after Inactivity - admin - 12-16-2010
Is there any built-in functionality to automatically expire a user after they have been inactive in Oracle Financials? For example, if a user has not signed in for 90 days, we would like to have them automatically locked out requiring a sysadmin to reactivate them. Thank you.
RE: Expire Users Automatically after Inactivity - Kashif Manzoor - 12-17-2010
(12-16-2010, 09:11 PM)admin Wrote: Is there any built-in functionality to automatically expire a user after they have been inactive in Oracle Financials? For example, if a user has not signed in for 90 days, we would like to have them automatically locked out requiring a sysadmin to reactivate them. Thank you.
this functionality is not natively available with EBS, but can easily be achieved by programming a periodic alert.
An alert on FND_USER table to check for LAST_LOGIN_DATE should work, with a call to FND_USER_PKG to end-date the user account if needed