Introduction
This blog explains how to reset the Oracle apps password from the backend.
#Code#
BEGIN
FND_USER_PKG.UPDATEUSER (X_USER_NAME => ‘USERNAME’
, X_OWNER => ‘APPS’
, X_UNENCRYPTED_PASSWORD => ‘Pasword@123’
, X_PASSWORD_DATE => SYSDATE);
END;
BEGIN
FND_USER_PKG.ENABLEUSER (‘USERNAME’);
END;
Conclusion
This query will be useful for enabling and resetting the password
Recommended Posts
