My Oracle Support Banner

After Cloning Running FNDCPASS and AFPASSWD When Attempting to Change APPS/APPLSYS and Sysadmin Users Passwords Generates PASSWORD VERIFICATION FOR APPS Error (Doc ID 2433710.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Basic SysAdmin functions, maintenance

After cloning environment, run FNDCPASS to reset APPS/APPLSYS and Sysadmin Users Passwords are Failing.
Patch 19127427 is applied in environment.

FNDCPASS apps/apps_passwd 0 Y system/system_passwd SYSTEM APPLSYS new_passwd

 

The following error appears:
ERROR IN PASSWORD VERIFICATION FOR APPS

 

Instead of FNDCPASS, use AFPASSWD.

AFPASSWD generates the error below:

AFPASSWD -f SYSADMIN
Enter the ORACLE password of Application Object Library 'APPSUSER':
Enter the ORACLE password of Application Object Library 'APPSUSER':
Connected successfully to APPS.
Log file: <log file name>.log
Enter new password for user [SYSADMIN]:
Verify new password for user [SYSADMIN]:

+----------------------------------------------------------------------------+
Application Object Library - AFPASSWD
+----------------------------------------------------------------------------+
Copyright (c) 2006, Oracle. All rights reserved.
+----------------------------------------------------------------------------+
Current system time is 08-AUG-18 23:21:00

+----------------------------------------------------------------------------+
Working...
This password is not managed by Oracle Applications so it can not be changed here.
Unable to change the password for fnd_user SYSADMIN.
AFPASSWD completed with errors.
+----------------------------------------------------------------------------+
Current system time is 08-AUG-18 23:21:25

+----------------------------------------------------------------------------+
_____________________________________________

 

Follow Removing Credentials from a Cloned EBS Production Database (Doc ID 419475.1) to resolve the error for users that are failing.

 

But still unable to change Sysadmin user password.

Receive error below:
FNDCPASS apps/pwd 0 Y system/pwd USER sysadmin pwd

Current system time is 25-JUN-2012 01:42:24
+---------------------------------------------------------------------------+

APP-FND-01564: ORACLE error 6502 in changepassword

Cause: changepassword failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_WEB_SEC", line 1372
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was: begin :r := fnd_web_sec.change_password(:u,:p); end; and was executed from the file &ERRFILE.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.