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

Error while changing the APPS password using FNDCPASS after integrating Database vault with E-Business suite.

[appl@sujeet ~]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPS sonu@321
Log filename : L487675.log

Report filename : O487675.out

[appl@sujeet ~]$ cat L487675.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 28-MAR-2015 23:34:38

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

APP-FND-02700: Invalid APPLSYS user name provided.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 28-MAR-2015 23:34:38

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


Solution:-

Check last update password.

SQL> select oracle_username, last_update_date, enabled_flag, read_only_flag from fnd_oracle_userid where oracle_username like 'AP%' order by 1;

ORACLE_USERNAME                LAST_UPDA E R

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

AP                                      14-MAY-00 N A

APPLSYS                           14-MAY-00 N E

APPLSYSPUB                     14-MAY-00 N C

APPS                                    14-MAY-00 N U

1) This failed because the default profile assigned to APPS schema is EXEMPT_POLICY(custom profile which is preventing the passowrd to be chnaged) as below

SQL> select profile from dba_users where username='APPS';
PROFILE                       
------------------------------
EXEMPT_POLICY

2) Change the profile to DEFAULT
SQL> alter user apps profile default;

then now reset password again using FNDCPASS..

Check profile option DEFAULT.

SQL> select profile from dba_users where username='APPS';

PROFILE

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

DEFAULT

[appl@sujeet ~]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS sonu
Log filename : L487676.log


Report filename : O487676.out

[appl@sujeet ~]$ cat L487677.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 28-MAR-2015 23:56:59

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

Working...


+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 28-MAR-2015 23:56:59

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

[appl@sujeet ~]$ sqlplus apps/sonu

SQL> select oracle_username, last_update_date, enabled_flag, read_only_flag from fnd_oracle_userid where oracle_username like 'AP%' order by 1;

ORACLE_USERNAME                LAST_UPDA E R
------------------------------ --------- - -
AP                             14-MAY-00 N A
APPLSYS                        28-MAR-15 N E
APPLSYSPUB                     14-MAY-00 N C
APPS                           28-MAR-15 N U

********************************************************************************