To reset an Oracle EBS application user password, use the FNDCPASS utility via command line to change it instantly, or use the System Administrator responsibility in the GUI for individual users. For APPS/APPLSYS passwords in R12.2, specialized steps involving adstpall.sh and WLS datasource updates are required
Methods to Reset Oracle EBS Passwords :
FNDCPASS Utility (Command Line – Recommended for Admins):
Use this method to change APPS or specific user passwords from the server terminal :
FNDCPASS apps/<apps_pwd> 0 Y SYSTEM/<system_pwd> USER <username> <new_password>
Example to change user “OPERATOR” password: FNDCPASS apps/apps 0 Y system/manager USER OPERATOR welcome1.
System Administrator Responsibility (GUI)
Log in to EBS as a user with System Administrator privileges (e.g., SYSADMIN).
Navigate to Security > User > Define.
Query the user, enter the new password in the Password field, and save.
PL/SQL Method (Back-end):
Use FND_USER_PKG.ChangePassword to change passwords using SQL*Plus, logged in as the APPS user.
R12.2 APPS/APPLSYS Password Change :
– Shut down services using $INST_TOP/admin/scripts/adstpall.sh.
– Run FNDCPASS to change the APPLSYS password.
– Run AutoConfig.
– Update WLS Data Source in WebLogic Console and restart services.
Comments
Tags: #dbaimmam, #immamDba, #woesofdba, DBAimmam, ImmamDBA, Oracle APPs DBA, Oracle DBA, Oracle EBS, Oracle Ebs Reset Oracle Application User Password, Oracle Ebs Reset Oracle Application User Password By Query, woesOfDba