Unlike 11i 10.7 does not have any utility for changing passwords for application users. Follow the steps below to change the password of any application user on 10.7. Example is shown for sysadmin user.
1. Find the encrypted value that ICX_CALL.CRCHASH is returning for the SYSADMIN password
In SQL*Plus as APPS owner:
SQL> variable x number
SQL> execute :x :=icx_call.crchash('SYSADMIN', 'sysadmin');
PL/SQL procedure successfully completed
SQL> print x
2. Change SYSADMIN's encrypted password to the value returned for x.
SQL> update fnd_web_users
set password = 'VALUE RETURNED FOR X'
where username = 'SYSADMIN';
3. Login as SYSADMIN/sysadmin. This should now be successful.
NOTE: Take a backup of FND_WEB_USERS before changing the password.
If the above procedure does not work or if you do not find the scripts then you must be on a lower version of AOL, try the following (This should work).
1. Take a backup of table FND_USER.
2. Execute update,
update fnd_user set ENCRYPTED_FOUNDATION_PASSWORD ='9B7E9A1B0F4C1E5012D34265F7F3DFDD6779CF66449A9ED9EE6AC8BA978BC1C5',
ENCRYPTED_USER_PASSWORD='AB5A8B42AC7F4CB4537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'
where user_name=’SYSADMIN’;
3. Login as USERNAME: SYSADMIN
PASSWORD: SYSADMIN
1. Find the encrypted value that ICX_CALL.CRCHASH is returning for the SYSADMIN password
In SQL*Plus as APPS owner:
SQL> variable x number
SQL> execute :x :=icx_call.crchash('SYSADMIN', 'sysadmin');
PL/SQL procedure successfully completed
SQL> print x
2. Change SYSADMIN's encrypted password to the value returned for x.
SQL> update fnd_web_users
set password = 'VALUE RETURNED FOR X'
where username = 'SYSADMIN';
3. Login as SYSADMIN/sysadmin. This should now be successful.
NOTE: Take a backup of FND_WEB_USERS before changing the password.
If the above procedure does not work or if you do not find the scripts then you must be on a lower version of AOL, try the following (This should work).
1. Take a backup of table FND_USER.
2. Execute update,
update fnd_user set ENCRYPTED_FOUNDATION_PASSWORD ='9B7E9A1B0F4C1E5012D34265F7F3DFDD6779CF66449A9ED9EE6AC8BA978BC1C5',
ENCRYPTED_USER_PASSWORD='AB5A8B42AC7F4CB4537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'
where user_name=’SYSADMIN’;
3. Login as USERNAME: SYSADMIN
PASSWORD: SYSADMIN
Comments
Regards,
Deepak