Hi!
I’m looking for a way to track changes in permission sets on users. I.e I’d like to see who changed a permission set on a user and when.
I can’t find a suitable configuration in History Log or a table to set up a custom event on.
Does anyone have an idea as for how to solve this?
Solved
History Log on User Permission set
+6Best answer by ludovic.rougean
Hi, you must activate the log of the table FND_USER_ROLE_TAB. It may not be available by default.
Make sure to select show Foundation1 Component. Then it works as usual and you can track any modification of access rights related to permission sets.
Hi, you must activate the log of the table FND_USER_ROLE_TAB. It may not be available by default.
Make sure to select show Foundation1 Component. Then it works as usual and you can track any modification of access rights related to permission sets.
+6Hi all!
I must have missed RMB Show Foundation1 Component. I simply couldn’t find the table.
But now it’s all up and running. Thank you!
You need to RMB in the history log navigator and display F1 components.
Then you can turn on logging on FND_USER_ROLE_TAB.
+6Hi again!
I’ve activated the FND_USER_ROLE_TAB in history log for all Insert, Update and Delete on ROLE column. I’ve also pressed save, but for some reason the test changes I make are not logged.
When checking the actual table, changes are made in ROLE column:
But history log dos not show any logs from the table.
I’ve successfully activated other tables for history logging, and I can’t remember that there was anything else I needed to to in order to activate them. Am I missing something?
+6Link wrote:
Hi
the logs are reoported in the table history_log_tab.
Thank you! I can see the changes in this table, but should they not be visible also in IEE View History Log?
Hi
in this case I don’t think so.
What you can do is to use the shortcut Ctrl + F9 to show the history logs.
Kind regards
1 person likes this
+6Ok, thank you! At least I can track changes now. :)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.