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

Command to change APPS Password.[Ensure to shut down Application services before changing apps password]
FNDCPASS apps/<apps_pwd> 0 Y system/<password> SYSTEM APPLSYS <new_apps_password>
Error Message from Logfile:
+—————————————————————————+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+—————————————————————————+
Current system time is 10-APR-2020 18:43:36
+—————————————————————————+
Arguments
FNDCPASS system/***** SYSTEM APPLSYS *****
+—————————————————————————-+
Working…
APP-FND-02704: Unable to alter user APPS_NE to change password.
Oracle error 28003: has been detected in alterpassword2.
+—————————————————————————+
Concurrent request completed
Current system time is 10-APR-2020 18:43:39
+—————————————————————————+

Cause:
Issue is due to 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.
1. 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’;

2. Disable password verify function

alter profile <profile_name> limit PASSWORD_VERIFY_FUNCTION null;

3. Run the FNDCPASS command to change password.

FNDCPASS apps/<apps_pwd> 0 Y system/<password> SYSTEM APPLSYS <new_apps_password>

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

http://www.appsdbadiaries.com/2022/02/how-to-update-apps-password-in-ebs.html

5. Startup Application services

4. Revert back the changes done in step 2

3 thoughts on ““APP-FND-02704: Unable to alter user APPS_NE to change password” while changing APPS password using FNDCPASS”

Hello, just wanted to mention, I enjoyed this article.
It was inspiring. Keep on posting!

Here is my blog nordvpn coupons inspiresensation (t.co)

Appreciating the persistence you put into your site and detailed information you present.
It’s nice to come across a blog every once in a while that
isn’t the same out of date rehashed information. Wonderful read!
I’ve saved your site and I’m adding your RSS feeds to my Google account.

Have a look at my homepage :: nordvpn Coupons inspiresensation – cfg.me,

WOW just what I was looking for. Came here by searching for nordvpn coupons inspiresensation special coupon code

3 thoughts on ““APP-FND-02704: Unable to alter user APPS_NE to change password” while changing APPS password using FNDCPASS”

Leave a Reply Cancel reply