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



Last updated on July 17th, 2015 at 06:05 pm

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?

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 := ‘XXXX’;
fnd_user_pkg.updateuser(x_user_name =>
l_user_name, X_OWNER => ‘SEED’, x_password_date =>sysdate);
end;
/
On the above SQL statement, replace ‘XXXXX’
by the username created on the Define Users forms.
For example , for user OEXPERT 
set serveroutput on
declare
l_user_name varchar2(2000);
begin
l_user_name := ‘OEXPERT’;
fnd_user_pkg.updateuser(x_user_name =>
l_user_name, X_OWNER => ‘SEED’, x_password_date =>sysdate);
end;
/

Leave a Reply