Unable To Pass NULL Values Parameters To The Package API FND_USER_PKG
Last updated on MARCH 08, 2017
Applies to:Oracle Application Object Library - Version 188.8.131.52 to 184.108.40.206 [Release 11.5]
Information in this document applies to any platform.
You want to run the API Fnd_User_Pkg.UpdateUser in order to update the two fields x_password_accesses_left and x_password_lifespan_accesses with the value NULL like :
x_user_name => l_user_name,
x_owner => null,
x_password_accesses_left => null,
x_password_lifespan_accesses => null,
x_password_date => sysdate);
After running fnd_user_pkg.UpdateUser, the two columns password_accesses_left and password_lifespan_accesses of the table FND_USER are not updated to null and stay at their original values.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms