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:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...