How to Stop the Force Password Reset on Creation of User Account

How to Stop the Force Password Reset on Creation of User Account

After the creation of an e-business suite user, how to stop the force password reset on the user's first log in to the application?

Solution

After the creation of  the user from the Define Users forms, the following SQL statement can be used to disable the force password reset on the user's first log in:

set serveroutput on

declare

l_user_name varchar2(2000);

begin

l_user_name := 'PDUVAL';

fnd_user_pkg.updateuser(x_user_name => l_user_name, X_OWNER => 'SEED', x_password_date =>sysdate);

end;

/

On the above SQL statement, replace 'PDUVAL' by the username created on the Define Users forms.