How to make a FND_USER Non SSO in and SSO enabled EBS Environment


1) Connect as Apps user
2) SQL> @$FND_TOP/patch/115/sql/fndssouu.sql HIMANSHU.SINGH

PL/SQL procedure successfully completed.

Commit complete.
3) Set profile  Applications SSO Login Types at user level to "LOCAL"

4) Reset Password for user using FNDCPASS.

Password is changed successfully for user HIMANSHU.SINGH.
FNDCPASS completed successfully.

5) Login with Non SSO URL