EBS-- Cannot Launch Multiple Forms Sessions After Registering with SSO Due to Lock on FND_USER_PREFERENCES

To resolve this error, you need to populate fnd_user_preferences with the necessary OID configuration values..

First, check your OID/SSO registration;

SELECT * FROM fnd_user_preferences
WHERE user_name=’#INTERNAL’ AND module_name= ‘OID_CONF’;

If no rows returned then it means your configuration is missing;
If there are few rows, check them, ensure all the configuration values are present.

Here is an example configuration;

PREFERENCE_NAME	PREFERENCE_VALUE
CREATE_BASE	cn=Users,dc=ofis,dc=erman,dc=com
CREATE_BASE_opt_mode	STATIC
DEFAULT_CREATE_BASE	cn=Users,dc=ofis,dc=erman,dc=com
DEFAULT_CREATE_BASE_opt_mode	STATIC
DEFAULT_REALM	dc=ofis,dc=erman,dc=com
DEFAULT_REALM_opt_mode	STATIC
FIXUP	NONE
FIXUP_opt_mode	STATIC
PLUGIN_VERSION	1.1
RDN	cn
RDN_opt_mode	STATIC
REALM	dc=ofis,dc=erman,dc=com
REALM_opt_mode	STATIC

If you find any missing configuration values;

Execute the following with Apps;
execute fnd_oid_plug.setPlugin;

This will populate your missing values;

Check  fnd_user_preferences again; this time you should see the missing values are present.

Check the following EBS profiles, and ensure they are set like below;

Applications SSO Type: SSWAw/SSO
Applications SSO Auto Link User: Enable
Applications SSO Login Types: Both
Application SSO LDAP Synchronization: Enable
Applications SSO Enable OID Identity Add Event: Enable
Link Applications user with OID user with same username: Enable

Now reregister you EBS to OID;

$FND_TOP/bin/txkrun.pl -script=SetSSOReg -deregister=yes

$FND_TOP/bin/txkrun.pl -script=SetSSOReg

Tested and verified. This should fix the problem..