How to modify or reset an External Applications SSO stored password?

What are External Applications?

External Applications do not delegate the authentication to the SSO server. Instead they display HTML forms that ask for username & passwords. Each External application may require a unique  username & password. 

You can configure SSO server to provide username and password to external applications on user's behalf once the user has logged into the SSO server.

Users have the option of storing external credentials in the SSO database.

Steps to do:

Deleting entry from wwsso_appuserinfo_t table

By removing the wwsso_appuserinfo_t entry for the specific APP_ID and SSO_USERNAME will cause the login page to prompt for a username and password the next time the external application link is used. The login and password are kept in the SSO server table called wwsso_appuserinfo_t. You need to know the sso_username, app_id, and the app_name for the external application whose password needs to be reset.

1. Launch SQLPLUS and connect as the ORASSO user to the metadata repository database. 
2. Execute the following sql statement
select app_id,app_name from wwsso_application_info_t;

This will return all the Registered External Applications.

Usage Example:

APP_ID APP_NAME

----------------------------------------------------- ----------

1BB95C43F626ABDED2496C0212CF7351 Self Service

4B4513196912E8F3B7B34B34CFABC6B5 Crystal New

95920AA96F51B6F81FE5708A8A251B03 Crystal Enterprise 10

E5B57C938938AD0C01A86FBF4E7C2F50 BMCSoftware

3.Execute the following sql statement

select sso_username from wwsso_appuserinfo_t;

This will return the SSO usernames that are registered with SSO.

Usage Example:

SSO_USERNAME

----------------------------------------------------

TESTUSER

USER

4.Execute the following sql statement

delete from wwsso_appuserinfo_t where app_id = <value from step 2> and sso_username= <value from step 3>

commit;

5.Now launch the External Application & you will be prompted to enter username and password.