How to find out what is the Logical Unit of users table?
I am trying to create an event to send an email every time the user is changed.
When accessing the user and opened the “System Info” it come out blank.
Is there a way to create this custom event on IFS? Or is it needed to be done into the database?
Thank you in advance.
It depends on which attribute you are trying to trap a change to.
Tables of interest are:
fnd_user is the user table, but it has only the ID and Active flag with Description
fnd_user_role is the permissions granted table
user_finance is the company connections
user_profile is the profile
user_allowed_site is the site connections
There are definitely others which is why going from the Create User view doesn’t show anything under System Info, it is probably a dozen or more tables joined to give that view on the detail screen.
Thanks ShawnBerk,
I used the table fnd_user_tab to create a trigger to send an email from there.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.