Your Oracle Apps 11i/R12/12i instance is currently integrated with Oracle Single Sign-On (SSO) & Oracle Internet Directory (OID) and you would like to remove integration (so that apps 11i/R12 instead of redirection to SSO, authentication happens at FND_USER).

Broad level steps to deregister apps (11i/R12) from SSO

1. Deregister Oracle Apps (11i/R12) from OID and SSO using
–> txkrun.pl -script=SetSSOReg -deregister=Yes

2. Remove any reference regarding SSO / OID from Oracle Apps (11i/R12)
–> txkrun.pl -script=SetSSOReg –removereferences=Yes

3. Change Profile Option at “Site level”
“Application SSO Type” (APPS_SSO) -> Change it to “SSWA”
“Application SSO Login Type” -> Change it to “Local”

4. Restart Services on Middle Tier

./adstpall.sh apps/apps_pass
./adstrtal.sh apps/apps_pass

5. Finally Reset password of all users whose ENCRYPTED_USER_PASSWORD is set to EXTERNAL

Identify users
SQL> select user_name , ENCRYPTED_USER_PASSWORD from fnd_user where ENCRYPTED_USER_PASSWORD=’EXTERNAL’;

and then reset password using (replace apps & sysyem password and VISION/WELCOME with username and user’s new password)

FNDCPASS apps/apps 0 Y system/manager USER   VISION  WELCOME

—

If you want only few users to login locally(default login method still SSO) then

1. Change Profile Option at User level
“Application SSO Type” (APPS_SSO) -> Change it to “SSWA”
“Application SSO Login Type” -> Change it to “Local”

2. Reset password of specific users  (If ENCRYPTED_USER_PASSWORD is set to EXTERNAL)

SQL> select user_name , ENCRYPTED_USER_PASSWORD from fnd_user where ENCRYPTED_USER_PASSWORD=’EXTERNAL’ and user_name like ‘&enter_User_Name’;

reset password using (replace apps & sysyem password and VISION/WELCOME with username and user’s new password)

FNDCPASS apps/apps 0 Y system/manager USER   VISION  WELCOME

3.Finally login using AppsLocalLogin URL

http(s)://hostname.domainname:port/OA_HTML/AppsLocalLogin.jsp

Popularity: 8% [?]

Share This