Usually its not recommended to change the Oracle apps password from back end, but if you need to change or reset it then use the PL/SQL script below:
DECLARE
v_flag BOOLEAN;
BEGIN
v_flag := fnd_user_pkg.ChangePassword(' OPERATIONS','123456');
END;
COMMIT;
Other Most Useful PLSQL Scripts:
DECLARE
v_flag BOOLEAN;
BEGIN
v_flag := fnd_user_pkg.ChangePassword('
END;
COMMIT;
Other Most Useful PLSQL Scripts:
- PL/SQL Function To Compute The Factorial Of A Number
- PL/SQL Function To Convert A Binary Number To A Decimal Number
- PL/SQL Function To Convert A Decimal Number To A Binary Number
- PL/SQL Function To Convert Ruppies(Numbers) In Words
- PL/SQL Function To Generate The Fibonacci Series
- PL/SQL Procedure For Counting All Tables And Respective Rows From Database
- PL/SQL Procedure To Display Monthly Calender
- PL/SQL Procedure To Reverse A String
- PL/SQL Script To Calculate Weekdays Between Two Given Dates
Good explanation! This post describes about how to change and reset the Oracle application password from back end using PL/SQL script.
ReplyDeleteupgrade sap 6.0