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.
Solved
current user Ifs
+8Best answer by paul harland
Hi
Often you can use the substitution variable #USER_ID#
More generally you can use fnd_session_api.get_fnd_user()
+24Hi
Often you can use the substitution variable #USER_ID#
More generally you can use fnd_session_api.get_fnd_user()
+8
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
+24you 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.
+8great ! thank you so much .
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.