DECLARE
v_user_name VARCHAR2(30):=upper('HCM'); --HCM is username of my oracle Apps.
v_new_password VARCHAR2(30):='welcome1';
v_status BOOLEAN;
BEGIN
v_status := fnd_user_pkg.ChangePassword ( username => v_user_name, newpassword => v_new_password );
IF v_status =true THEN
dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END IF;
END;
v_user_name VARCHAR2(30):=upper('HCM'); --HCM is username of my oracle Apps.
v_new_password VARCHAR2(30):='welcome1';
v_status BOOLEAN;
BEGIN
v_status := fnd_user_pkg.ChangePassword ( username => v_user_name, newpassword => v_new_password );
IF v_status =true THEN
dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END IF;
END;
/ oracle-apps-functional-online-training
ReplyDeleteHyderabadsys oracle-apps-functional online training completely unique & genuine training programe instution.so we give any one student to software cource 100% genine.Hyderbadsys oracle-apps-functional online training completely IT sector.we have lot of employees are working hear.so we can give practical knowledge to the students. after complete the course we give with certification, so it is useful to select multy national companies easily. Hyderbadsys oracle-apps-functional online training charge fees is economical cost,compare to other training instutions. Hyderbadsys oracle-apps-functional online training give complete live projects to the students.it is vey useful to the students.
Hyderbadsys oracle-apps-functional online training have superb trainer to the students Hyderbadsys oracle-apps-functional online training on the web training give a best training for oracle oaf in India. so we're prepared to give best training to students. so student have any problems & droughts’ easily can clarify. we have lot of batches. hence students can take any batch, for that student convince. so he can select any batch. Hyderbadsys oracle-apps-functional online training E-Training give teaching to the all students 24/7 per day. A solid strategy for entering, cleanup and updating the information for the sales force online training
+India: +91 9030400777
Usa: +1-347-606-2716
Email: contact@Hyderabadsys.com
#201, Near by RTO office,
Kondapur, Hitech city,
Hyderabad, 500084,India.