Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
Expire Users Automatically after Inactivity - Printable Version

+- 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