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 220.127.116.11 to 18.104.22.168 [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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms