Skip to main content

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.

Hi

Often you can use the substitution variable #USER_ID#

More generally you can use fnd_session_api.get_fnd_user()


It works !!! Great .

thank you so much :) 


 

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


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.


great ! thank you so much .


Reply