EBS application user not able to login check

When any application user not able to login check :

From login page it shows  error then check FND_USER table check  “password_date”  value if it expired then change it  as below procedure,

1.Login server as applmgr user

2.Source env file in APPL_TOP

3.And put command

$>sqlplus apps/apps

4.Check FND_USER table

SQL>select user_name,password_date from fnd_table wher user_name=’STAPLES’ ;

If it expired by date then run command

5.$>FNDCPASS apps/apps 0 Y system/manager USER  STAPLES 123456

Where STAPLES is application user and 123456 is password.

Now check from application page to login as this user it work then. 

Best practices for using FNDCPASS

Before using FNDCPASS and changing the passwords from default to some thing else, always follow the following best practices.

1) Always keep the back of tables FND_USER and FND_ORACLE_USERID. You can take back of these tables using CREATE TABLE — AS SELECT * FROM —.
You must have backup of these tables before running FNDCPASS. In case if FNDCPASS fails then it might corrupt the passwords of your application and worst can happen that the application wont come up. So always be cautions about this command.

(You may keep an export dump of these two tables )

2) Never update apps, applsys or any schema password directly from database using the alter command. Always use FNDCPASS. System password can be set directly using ALTER command in database.

3) To change APPS/APPLSYS Password , we need to get CM services DOWN.

Best Practices

1) Keep the backup of tables FND_USER and FND_ORACLE_USERID.
You can take back of these tables using
Sql> CREATE TABLE FND_USR_BKP as SELECT * FROM FND_USER. and in the same
way for FND_ORACLE_USERID.

In worst case scenario, if FNDCPASS fails then it might corrupt the passwords of your application and the bad could happen is, the application is not coming up. So always be cautions about this command.

2) If possible then, also keep an export dump of these two tables, FND_USER and
FND_ORACLE_USERID.

3) Verify each argument you are providing to FNDCPASS. Like verify that apps and
system passwords you are what you suppose to provide??

4) Never update apps, applsys or any schema password directly from database using
the alter command. Always use FNDCPASS. But System password can be set
directly using ALTER command in database.

5) Try to check for any customized hardcoded package or procedure in database by
running the query below.

SQL> select name,text from all_source
where text like ‘%conn%apps%’

For More Reference: Metalink Note 159244.1