My Oracle Support Banner

Unable To Pass NULL Values Parameters To The Package API FND_USER_PKG (Doc ID 760780.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Application Object Library - Version to [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 :

fnd_user_pkg.UpdateUser (
          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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.