Password reset for Apps Foundation user

In my consulting experience i have faced login issues (forgot password) couple of times.Sometimes it is difficult to wait for the admin response.So i will prefer the

following code snippet to reset the apps foundation user password.
DECLARE
    lb_status BOOLEAN;
BEGIN
    lb_status := FND_USER_PKG.CHANGEPASSWORD
                                                            (
                                                                username           => 'XX_DEMO',
                                                                newpassword     => 'apps123'
                                                           );

    IF lb_status
    THEN
        DBMS_OUTPUT.PUT_LINE('Request processed sucessfully'); 
    ELSE
        DBMS_OUTPUT.PUT_LINE('Error while processing the request'); 
    END IF;
END;

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...