We can use the below API for changing the EBS(fnd_user) user password.
apps.fnd_user_pkg.changepassword
Sample Script:
DECLARE
v_user_name VARCHAR2 (100) := 'HSINGH';
v_new_password VARCHAR2 (100) := :NEWPASSWORD;
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
DBMS_OUTPUT.put_line (
'Password is changed successfully for the user=> ' || v_user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while restting password for user and the Error Detail is '
|| SQLERRM);
END;
The script can also be modified to reset bulk ebs user passworda. The below is a sample script, You need to modify as per you need.
Refer below syntax
DECLARE
v_status BOOLEAN;
CURSOR user_name_list
IS
SELECT user_name
FROM fnd_user
WHERE NVL (end_date, SYSDATE + 1) > SYSDATE
AND user_name NOT IN ('SYSADMIN',
'GUEST',
'XML_USER',
'APPSMGR',
'PORTAL30',
'PORTAL30_SSO');
BEGIN
FOR user_name_list IN c_user
LOOP
BEGIN
v_status :=
fnd_user_pkg.ChangePassword (
username => user_name_list.user_name,
newpassword => 'welcome123');
-- dbms_output.put_line('password successfully changed for' || user_name_list.user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while resetting password for users and the Error Detail is '
|| SQLERRM);
END;
END LOOP;
END;
apps.fnd_user_pkg.changepassword
Sample Script:
DECLARE
v_user_name VARCHAR2 (100) := 'HSINGH';
v_new_password VARCHAR2 (100) := :NEWPASSWORD;
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
DBMS_OUTPUT.put_line (
'Password is changed successfully for the user=> ' || v_user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while restting password for user and the Error Detail is '
|| SQLERRM);
END;
The script can also be modified to reset bulk ebs user passworda. The below is a sample script, You need to modify as per you need.
Refer below syntax
DECLARE
v_status BOOLEAN;
CURSOR user_name_list
IS
SELECT user_name
FROM fnd_user
WHERE NVL (end_date, SYSDATE + 1) > SYSDATE
AND user_name NOT IN ('SYSADMIN',
'GUEST',
'XML_USER',
'APPSMGR',
'PORTAL30',
'PORTAL30_SSO');
BEGIN
FOR user_name_list IN c_user
LOOP
BEGIN
v_status :=
fnd_user_pkg.ChangePassword (
username => user_name_list.user_name,
newpassword => 'welcome123');
-- dbms_output.put_line('password successfully changed for' || user_name_list.user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while resetting password for users and the Error Detail is '
|| SQLERRM);
END;
END LOOP;
END;
2 Comments
Thank you for providing an informative post and keep delivering more details. I am sure I learn much from your new stuff right here!
ReplyDeleteOracle DBA Training in Chennai
oracle dba training
Advanced Excel Training in Chennai
Spark Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Pega Training in Chennai
Embedded System Course Chennai
Unix Training in Chennai
Oracle DBA Training in T Nagar
Oracle DBA Training in OMR
Great Article. Thank you for sharing! Really an awesome post for every one.
ReplyDeleteIEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.
Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
Post a Comment