After Cloning Oracle Applications And Resetting APPS Password, Discoverer 10g/11g Fails With Error

After Cloning Oracle Applications And Resetting APPS Password, Discoverer 10g/11g Fails With Error: Unable To Connect To Oracle Applications Database (afscpgcs) (Doc ID 788706.1):
=================================================

SYMPTOMS

After successfully cloning an Oracle Applications E-Business Suite instance and changing "APPS" user password, connections to Discoverer fail with error:

"Error:
A connection error has occurred.
- OracleBI Discoverer was unable to authenticate using the password provided. This can happen due
to an invalid password or because the password was lost while using back, forward, or refresh in your browser. Please enter the password again to continue.
- Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)".

SOLUTION

To implement the solution, please execute the following steps:

1. In cloned Oracle Applications instance, login as SYSAdmin and set the Site-Level value for Profile option "Signon Password Case" to "insensitive."
   
2. Stop Oracle Applications tier services and concurrent server.
   
3. Use FNDCPASS to change APPS/APPLSYS password.
   
4. Run autoconfig on Applications tiers so that new APPS password is propagated correctly.
   
5. Restart Applications tier and concurrent servers.
   
6. Reset "Signon Password Case" back to "Sensitive" again.
   
7. After making these changes, connections to Discoverer will succeed without error.