Productlon Issue : FNDCPASS while changing Apps user password , Seems corruption in passwords

[Vithal]

Hi,

 Our Apps password was getting locked , so upon investigating , we found that the APPS password is different from the APPLSYS Password , and hence users are having trouble working.

 We shutdown the system , and tried changing the APPLSYS Password , as it also changes the APPS Password.

 FNDCPASS apps/<pwd> 0 Y system/<pwd> SYSTEM APPLSYS <new pwd> 

 However the FNDCPASS gave an error in the log file

 Please find FNDCPASS Error Snippet :

Working...
FNDCPASS-CANNOT DECRYPT (USER=ANONYMOUS)
FNDCPASS-CANNOT DECRYPT (USER=AUTOINSTALL)
FNDCPASS-CANNOT DECRYPT (USER=CONCURRENT MANAGER)
FNDCPASS-CANNOT DECRYPT (USER=FEEDER SYSTEM)
FNDCPASS-CANNOT DECRYPT (USER=GUEST)
FNDCPASS-CANNOT DECRYPT (USER=INITIAL SETUP)
FNDCPASS-CANNOT DECRYPT (USER=SYSADMIN)
...
FNDCPASS-CANNOT DECRYPT (USER=APPLSYS)
FNDCPASS-CANNOT DECRYPT (USER=APPS)


Please help , its urgent.
Regards,
Vithal.

[ErmanArslansOracleBlog]

1)What is your EBS version?
2)What is the value of SIGNON_PASSWORD_CASE profile?

retry after setting System Profile 'Password Case Option' to 'Insensitive' and update me with the outcome.

[Vithal]

Hi,
EBS Version is 11.5.10.2.

The Issue is Resolved.

I restored the fnd_users and fnd_oracle_userid tables from last cold backup.

And Ran AutoConfig.

Thanks for your help.

Hope someone benefits from this solution.

Regards,
Vithal.

[ErmanArslansOracleBlog]

good!
thanks for sharing..