Your Doorstep to the Temple of Oracle

Oracle EBS

APP-FND-01496 Results From FNDCPASS Chaning The APPLSYS password

Posted by appsdba11i on April 22, 2011

APP-FND-01496 Results From FNDCPASS Chaning The APPLSYS password

AFTER manually using the ‘alter user’ in sqlplus the following error occurs in the log for every application user account:

ERROR
APP-FND-01496: Cannot access application ORACLE password
Cause: Application Object Library was unable access your ORACLE password.

The APPLSYS (APPS) password became corrupted using ALTER USER because an applications session was not maintained at the same time. This apps session is necessary to change the APPLSYS password in:
‘Security> Oracle> Register’ WHILE being in SQL*PLUS as the SYSTEM user.

The supported method is use of FNDCPASS.

To implement the solution, please execute the following steps:

1. Restore the FND_ORACLE_USERID and FND_USER tables from a backup.

2. Then run FNDCPASS to change the APPLSYS password. Ex.

FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS WELCOME

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s