The problem was solved by reassigning the role. DECLARE LOGIN_ VARCHAR(3200) := upper(:LOGIN;)BEGIN IFSAPP.Fnd_User_Role_API.Set_Role(LOGIN_, 'ROLE_XXXX', TRUE); IFSAPP.Fnd_User_Role_API.Refresh__(LOGIN_); Security_SYS.Refresh_Active_List__(1);END;
1. I see the expected permission sets assigned to users.2. Refreshing the server cache in the application does not work.3. Next day problem gone, permissions work fine. I think there is some scheduled task in the database.
Already have an account? Login
No account yet? Create an account
Enter your 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.