How to reset Oracle Apps frontend User ID Password

Oracle Apps front-end User ID Password

DECLARE flag_value BOOLEAN; BEGIN flag_value := fnd_user_pkg.changepassword(username=> ‘sujeet‘ ,newpassword => ‘jha‘); IF flag_value THEN DBMS_OUTPUT.PUT_LINE(‘The password reset successfully’); ELSE DBMS_OUTPUT.PUT_LINE(‘The password reset has failed’); END IF; END; / COMMIT;

No comments:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...