hello,
i need to create a custom Field which gets me he current user in Ifs. that help me to identify who create a part (in inventory Part)
thank you.
Best answer by paul harland
View original
current user Ifs
Userlevel 3
+7
Userlevel 7
+24
Hi
Often you can use the substitution variable #USER_ID#
More generally you can use fnd_session_api.get_fnd_user()
Userlevel 3
+7
It works !!! Great .
thank you so much :)
Userlevel 3
+7
my idea is to be able to retrieve the history of users who have created new parts and I see with this custom field that I always get the current user .. it is not a persistent field.
thanks for your help
Userlevel 7
+24
you can make the field persistent/text, then use this code as the default value (either context substitution variable or PL/SQL expression).
That way you can capture who created a record.
Best to also make the field non-editable through the client.
Userlevel 3
+7
great ! thank you so much .
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.