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

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

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);
    end;
    /

 

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.

Cause

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