[Oracle EBS] Change EBS User Password Using PL/SQL

If you have a locked EBS user account or need to change the user passwords using FND_USER_PKG.changePassword API with PL / SQL then you can use the following script

declare
begin
if FND_USER_PKG.changePassword ('USERNAME','NEW_PASSWORD') 
then
 dbms_output.put_line(1); 
else 
 dbms_output.put_line(2) ;
end if;
end;

Don't forget to commit.

Artikel Terkait :