{"id":3148,"date":"2012-04-20T05:29:32","date_gmt":"2012-04-20T09:29:32","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=3148"},"modified":"2012-05-04T01:27:12","modified_gmt":"2012-05-04T05:27:12","slug":"osso_oebs-integration-issue-in-cluster-node","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/","title":{"rendered":"OSSO_OEBS Integration issue in cluster node"},"content":{"rendered":"<p>Hi All,<\/p>\n<p>OSSO_OEBS integration issue in cluster node which had been there for more than a year has been fixed. Here, we have covered the details about the issue and its solution.<\/p>\n<h2>Environment details:<\/h2>\n<h3>Oracle Single Sign on Server<\/h3>\n<h3>\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<\/h3>\n<p>Oracle application single sign on server 10.1.4.3 (HTTP, OC4J, and OID), OAM10g, OAS 10g and OIM 9.2 services existing in two nodes and it\u2019s clustered. DB is in RAC mode.<\/p>\n<p>OIM deployed in oracle application server. In our project OIM is a master source, user will create first in OIM and provisioned to respective tracks through connectors. Here, we are creating user in OIM and provisioning to OID and OEBS.<\/p>\n<h3>E-Business suite App tier<\/h3>\n<h3>\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013<\/h3>\n<p>It\u2019s a multi node environment (12.1.3 unified APPL TOP) with forms, Application listener, web services and (concurrent) Report server existing in two nodes and it\u2019s clustered. DB is in RAC mode. We have integrated OAM with OSSO using following document OAM 10g: Integrating Oracle Application Server Single Sign-On with Oracle Access Manager Step by Step [ID 979827.1]<\/p>\n<p>Before OEBS version is 12.0.6 and then we tried to integrate OSSO with OEBS using this <strong>Integrating Oracle E-Business Suite Release 12 with Oracle Internet Directory and Oracle Single Sign-On 10gR3 (10.1.4.3) (Doc ID 376811.1)<\/strong><\/p>\n<p>Based on this above doc, we have executed following points in OEBS server.<\/p>\n<p>1. Execute the following command<\/p>\n<pre>$FND_TOP\/bin\/txkrun.pl -script=SetSSOReg -provisiontype=2<\/pre>\n<p>Error occurred when execute the above script. The issue is<\/p>\n<pre>java.sql.SQLException: Io exception: The Network Adapter could not establish the connection.<\/pre>\n<p>Regarding this issue we have raised ticket with oracle, finally they have confirmed that it\u2019s a product bug and they mentioned that, integration will be work if DB is in active\/passive mode but our environment having active-active mode. After some month OEBS team enhance the product version into 12.1.3 from 12.0.6. Then we tried to re-execute the script again. This time, OSSO registration get succeed but unable to login into OEBS application.<\/p>\n<p><strong>Following workarounds help us to fix the above issues.<\/strong><\/p>\n<h2>Troubleshooting tips:<\/h2>\n<ol start=\"1\">\n<li>Upgrade the version from 12.0.6 to 12.1.3<\/li>\n<li>Register the OEBS with OSSO using following command in OEBS server<\/li>\n<\/ol>\n<pre>$FND_TOP\/bin\/txkrun.pl -script=SetSSOReg -provisiontype=2<\/pre>\n<ol start=\"3\">\n<li>Verify the SSO system profile information<\/li>\n<\/ol>\n<p>Application SSO LDAP Synchronization <strong>enabled<\/strong><\/p>\n<p>Applications SSO Auto Link User <strong>enabled<\/strong><\/p>\n<p>Applications SSO Enable OID Identity Add Event <strong>enabled<\/strong><\/p>\n<p>Applications SSO Login Types <strong>SSO<\/strong> (SYSADMIN and GUEST should be LOCAL)<\/p>\n<p>Applications SSO Type <strong>Sswa w\/sso<\/strong><\/p>\n<p>Applications SSO Linking Source of Truth <strong>Oracle internet directory<\/strong><\/p>\n<ol start=\"4\">\n<li>After this, we tried to login into OEBS application using <a href=\"http:\/\/hostname.domain:port\/OA_HTML\/AppsLocalLogin\">http:\/\/hostname.domain:port\/OA_HTML\/AppsLocalLogin<\/a><\/li>\n<li>Redirect to OSSO for authentication.<\/li>\n<li>Getting following error after OSSO authentication.<\/li>\n<\/ol>\n<pre>\u201cYour Oracle E-Business Suite account has not been linked with the Single Sign-On account that you just entered.\u201d<\/pre>\n<ol start=\"7\">\n<li>Is not really an error. What the message is saying ORCLGUID attribute in OID for this user does not match the USER_GUID in the FND_USER table. This issue can occur when the E-Business suite users are not manually loaded into OID. Let\u2019s look at an example user 45156<\/li>\n<\/ol>\n<pre>FILENAME = fnd_user.txt<\/pre>\n<pre>1142 45156 29-OCT-11 1113 23-OCT-11 -1 102203 ZHE5B953B16EEDDA73606A216471D88061774105720DEA99234346BE6032628653AF90E6519B1C997166ABEE0C9C0425DA4F ZHF4168873BC5DE2A0D465244A87AF8A53022146263DCF5F13E429AD99201C89D6B5496179C96063C703199389BA5E2A3653 0 23-OCT-11 23-OCT-11 135 5204<\/pre>\n<pre>&gt;&gt;&gt;&gt;From the SQL output we can see that no USER_GUID is set for the user 45156, However looking at OID for that user<\/pre>\n<pre>ldapsearch -h hostname -p 389 -D \"cn=orcladmin\" -w admin123 -s subtree -b \"\" \"uid=45156\" orclguid<\/pre>\n<pre>--------------------------------------------------------------------------------------------------------------------<\/pre>\n<pre>-bash-3.00$ .\/ldapsearch -h hostname -p 389 -D \"cn=orcladmin\" -w admin123 -s subtree -b \"\" \"uid=45156\" orclguid<\/pre>\n<pre>cn=45156,cn=employee,cn=users,dc=co,dc=in<\/pre>\n<pre>orclguid=AF8FD9D684051D61E040640A4D2568B5<\/pre>\n<pre>We can see that the orclGUID is set<\/pre>\n<pre>FND_USER = NULL(no value is match in OEBS)<\/pre>\n<pre>OID = AF8FD9D684051D61E040640A4D2568B5<\/pre>\n<p>We should be able to bypass this issue by setting \u201cApplications SSO Auto Link\u201d to enable and this setting will help user signing in via SSO already exists in the FND_USER then the orclguid and USER_GUID are matched. Here it\u2019s already enabled, so finger crossed again.<\/p>\n<ol start=\"8\">\n<li>We have \u201cApplications SSO Auto Link\u201d set to enabled but auto link is still not working<\/li>\n<\/ol>\n<p>The most likely cause for this issue is discussed in<\/p>\n<p>\u201cApplications SSO Auto Link User\u201d (APPS_SSO_AUTO_LINK_USER) Profile option doesn\u2019t work and still ask to manually link the user (Doc ID 399117.1)<\/p>\n<ol start=\"9\">\n<li>Login to Oracle Applications as \u201cSYSADMIN\u201d user through the Oracle Applications Local Login Homepage:<\/li>\n<\/ol>\n<p><a href=\"http:\/\/hostname.domain:port\/OA_HTML\/AppsLocalLogin.jsp\">http:\/\/hostname.domain:port\/OA_HTML\/AppsLocalLogin.jsp<\/a><\/p>\n<ol start=\"10\">\n<li>Select \u201cSystem Administrator\u201d responsibility.<\/li>\n<li>Select the \u201cSecurity: User\u201d, select \u201cDefine\u201d function.<\/li>\n<li>Query for the user 45156<\/li>\n<li>Remove the value in the \u201cend date\u201d field if found.<\/li>\n<li>Re-test the login using user 45156<\/li>\n<\/ol>\n<p>If the &#8220;Your Oracle E-Business Suite account has not been linked with the Single Sign-On account that you just entered.&#8221; error still occurs then perform the steps below<\/p>\n<ol start=\"15\">\n<li>Log a telnet session into one of the E-Business suite web tiers<\/li>\n<li>Open a SQLplus session as the APPS user and then run the commands below<\/li>\n<\/ol>\n<p>SQL&gt; set server output on<\/p>\n<p>SQL&gt; @$FND_TOP\/patch\/115\/sql\/fndssouu.sql 45156;<\/p>\n<p>You should see message similar to the following:<\/p>\n<p>PL\/SQL procedure successfully completed.<\/p>\n<p>Commit complete.<\/p>\n<ol start=\"17\">\n<li>Re-test the login using user 45156 and it\u2019s succeeded.<\/li>\n<\/ol>\n<p>I hope this blog will help you.Thanks<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi All, OSSO_OEBS integration issue in cluster node which had been there for more than a year has been fixed. [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[32,40,42],"tags":[],"class_list":["post-3148","post","type-post","status-publish","format-standard","hentry","category-others","category-sso","category-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>OSSO_OEBS Integration issue in cluster node -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OSSO_OEBS Integration issue in cluster node -\" \/>\n<meta property=\"og:description\" content=\"Hi All, OSSO_OEBS integration issue in cluster node which had been there for more than a year has been fixed. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-20T09:29:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-05-04T05:27:12+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/\",\"name\":\"OSSO_OEBS Integration issue in cluster node -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2012-04-20T09:29:32+00:00\",\"dateModified\":\"2012-05-04T05:27:12+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OSSO_OEBS Integration issue in cluster node\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OSSO_OEBS Integration issue in cluster node -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/","og_locale":"en_US","og_type":"article","og_title":"OSSO_OEBS Integration issue in cluster node -","og_description":"Hi All, OSSO_OEBS integration issue in cluster node which had been there for more than a year has been fixed. [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/","article_published_time":"2012-04-20T09:29:32+00:00","article_modified_time":"2012-05-04T05:27:12+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/","url":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/","name":"OSSO_OEBS Integration issue in cluster node -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2012-04-20T09:29:32+00:00","dateModified":"2012-05-04T05:27:12+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/04\/20\/osso_oebs-integration-issue-in-cluster-node\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"OSSO_OEBS Integration issue in cluster node"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/3148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=3148"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/3148\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=3148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=3148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=3148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}