[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 :

• [Oracle EBS] ORA-01591 In-Doubt Transactions
• [Oracle EBS] Query to list Reports assigned to a Responsibility
• [Oracle EBS] Query Period Status
• [Oracle EBS] Query To Find Application Name And Short Name
• [Oracle EBS] GL Journals Stuck With Funds Status In Process
• [Oracle EBS] Fixed Asset Error APP-OFA-48392 in Asset Workbench
• [Linux] Transfer Files Or Folder Using SCP
• [PostgreSQL] Truncate Table and Reset Sequence