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.
(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