A simple quick report to display last login of all users would be.SELECT t.user_id, max(r.modified_date) last_logonFROM FNDRR_USER_CLIENT_PROFILE_TAB T, FNDRR_CLIENT_PROFILE_VALUE_TAB rWHERE t.USER_ID not like 'IFS%'and ordinal = 0and fnd_user_api.Get_Active(user_id) = 'TRUE'and r.profile_id (+) = t.profile_idgroup by t.user_id ThanksRaj
Hi, I am trying to understand your issue. You have granted FND_CONNECT role? You are able to login user via sql but not in IFS. FND_CONNECT role is required for user.I hope this help.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.