APP-FND-02704: Unable to alter user APPLSYSPUB to change password

 Dear Folks,

Recently we have faced an issue in EBS 12.2 instance where we weren't able to change APPLSYSPUB password and ended up with below error.

APP-FND-02704: Unable to alter user APPLSYSPUB to change password.

Oracle error 28003: `n▒ 8 has been detected in alterpassword2.

Unable to change the password for Oracle user APPLSYSPUB.

Fix

Check APPLSYSPUB belongs to which profile.

SQL>    col USERNAME for a10;

        col ACCOUNT_STATUS for a20;

        col EXPIRY_DATE for a10;

        col PROFILE for a20;

        select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where USERNAME in ('APPLSYSPUB');SQL> SQL> SQL> SQL>

USERNAME   ACCOUNT_STATUS       EXPIRY_DAT PROFILE

---------- -------------------- ---------- --------------------

APPLSYSPUB OPEN                            APPS_USER_PROFILE

Verify "PASSWORD_VERIFY_FUNCTION" RESOURCE_NAME for the above profile.

SQL> select * from dba_profiles where PROFILE='APPS_USER_PROFILE' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';

PROFILE              RESOURCE_NAME                  RESOURCE_TYPE                  LIMIT                                    COM

-------------------- ------------------------------ ------------------------------ ---------------------------------------- ---

APPS_USER_PROFILE    PASSWORD_VERIFY_FUNCTION       PASSWORD                       VERIFY_FUNCTION_11G                      NO

Alter it to NULL.

SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.

and change the APPLSSYPUB password and now it works.

Working...

Password is changed successfully for user APPLSYSPUB.

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+

Concurrent request completed successfully

Rervert back the profile.

SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G;

Profile altered.

Thanks.