APP-FND-02704: Unable to alter user APPS_NE to change password” while changing APPS password using FNDCPASS
Issue:
Changing apps password using FNDCPASS fails with below error
APP-FND-02704: Unable to alter user APPS_NE to change password.
Oracle error 28003: has been detected in password.
Command to change APPS Password.[Ensure to shut down Application services before changing apps password]
FNDCPASS apps/<apps_pwd> 0 Y system/<system_password> SYSTEM APPLSYS <new_apps_password>
Error Message from Logfile:
Application Object Library: Version : 12.2
Copyright (c) 2013, 2016, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
Current system time is 21-MAY-2022 01:20:12
Arguments
FNDCPASS system/***** SYSTEM APPLSYS *****
APP-FND-02704: Unable to alter user APPS_NE to change password.
Oracle error 28003: has been detected in password.
Concurrent request completed
Current system time is 21-MAY-2022 01:21:22
Cause:
Issue is due to the Password_verify_function enables in dba_profiles for APPS,APPLSYS,APPS_NE users
Solution:
Disable the password verify function for APPS,APPLSYS,APPS_NE users in database profiles.
- Identify the database profile for APPS,APPLSYS,APPS_NE users using below query.
SELECT USERNAME,PROFILE FROM DBA_USERS where USERNAME in (‘APPS’,’APPLSYS’,’APPS_NE’);
SELECT PROFILE,VALUE FROM DBA_PROFILES WHERE PROFILE=’&profile for user’;
- Disable password verify function
alter profile Profile name limit PASSWORD_VERIFY_FUNCTION null;
- Run the FNDCPASS command to change password.
FNDCPASS apps/<apps_pwd> 0 Y system/<password> SYSTEM APPLSYS <new_apps_password>
- After changing apps password, run autoconfig on Middle tier and update EBS datasource for R12.2.x
You can follow the below steps to update apps password in EBS Datasource:
- Start the Application services
- Check the concurrent managers are up and running.
- Revert the changes made in step 2
