How to change Oracle applications user password programmatically

Generally Oracle applications user password is reset/changed through the System administrator> Define user form.

But if you would like to do the same programmatically then this is the way.

Use the following script.

begin
if fnd_user_pkg.changepassword(username => ‘USER’
,newpassword => ‘pwd’) then

null;
end if;

commit;

end;

 

Note :USER is the User Name, pwd is the new password that you would like to set.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s