Monday, September 9, 2013

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..



5 comments :

  1. Hi Erman,

    I am facing similar issue but it 12.2 (upgraded from 12.1.3). I have de-register oid and oam and registered it again and the scripts completed successfully, no errors in the script log file as well. I can see the all records for the sql mentioned. But still I am unable to launch multiple forms using SSO user.

    I can see the lock on FND_USER_PREFERENCES when I launch the second form. Its exactly same issue but unable to fix it.

    Thanks,
    Stephen

    ReplyDelete
  2. Hi Stephen,

    Please use my Forum to create an issue on this. I give tech support from my forum.
    Open your issue in the EBS 12.2 category.
    Forum link: http://ermanarslan.blogspot.com.tr/p/forum.html

    Open your issue by doing the following:
    Enable a Forms session trace and reproduce the issue.
    Attach the trace file to the newly created issue for further review.

    Thanks

    ReplyDelete
  3. Thanks Erman, I managed to fix the issue by applying the patch 22098300

    ReplyDelete
  4. Hi Stephen,
    Thanks for sharing this valuable info. Then there is a lack in the documentation..
    Patch 22098300 is given as a prereq in "Integrating Oracle E-Business Suite Release 12.2 with Oracle Unified Directory 11gR2 (Doc ID 2003483.1)", but it is not there in "Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 11gR1 (Doc ID 1371932.1)"... So this patch should be applied in any case ( implementing OID or Oracle Unified Directory with EBS)..

    ReplyDelete
  5. Yes i have logged SR to update OID document..

    ReplyDelete