{"id":2098,"date":"2010-08-24T11:30:09","date_gmt":"2010-08-24T15:30:09","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/"},"modified":"2016-12-15T12:03:37","modified_gmt":"2016-12-15T16:03:37","slug":"integration-of-e-business-suite-with-oracle-single-sign-on","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/","title":{"rendered":"Integration of E-Business suite with Oracle Single Sign-on"},"content":{"rendered":"

I have done the integration of E-Business suite with Oracle Single Sign-on today and would like to post few integration details of the same.<\/p>\n

In my case, I am using EBS 12.0.6<\/strong> and the pre-requisites is that OID should be upgraded to 10.1.4.3<\/strong>. The patch 5855635<\/strong> should be applied in E-Business Suite machine\u00a0 if the E-Business suite is running on AIX machine.<\/p>\n

Note: You might need to check the certification matrix the exact OID version compatible for E-Business version.<\/span><\/p>\n

All we need is to register the OID with the E-Business instance. A script <\/strong>txkrun.pl<\/strong> <\/code>needs to be run for this, which will register the E-Business application in Oracle Single Sign-On server of the OID instance and registers the OID details in E-Business Suite database.<\/p>\n

For eg:\u00a0<\/strong><\/p>\n

[code language=”bash”]<\/p>\n

$FND_TOP\/bin\/txkrun.pl -script=SetSSOReg<\/code><\/p>\n

[\/code]<\/p>\n

Note: Several other parameters can be provided in the above command based on your requirement. Investigate that in the metalink article given below.<\/span><\/p>\n

The sample output of the above script is shown below.<\/p>\n

Enter the host name where Oracle iAS Infrastructure database is installed ? OID_HOSTNAME
\nEnter the LDAP Port on Oracle Internet Directory server ? OID_PORT<\/p>\n

Enter SSL LDAP Port on Oracle Internet Directory server ? OID_SSL_PORT
\nEnter the Oracle Internet Directory Administrator (orcladmin) Bind password ?
\nEnter the instance password that you would like to register this application instance with ?
\nEnter Oracle E-Business apps database user password ?<\/p>\n

You can observe that first input to be given is the hostname where Oracle iAS Infrastructure database is installed. This means you should enter the Database hostname if OID and DB are residing on different machines which is the same in our case. In fact, we should provide the OID hostname and not DB hostname.<\/p>\n

After OID registration is completed successfully, check the OSSO application whether the EBS is registered as partner application or not and restart the OC4J_Security service.<\/p>\n

Create an EBS user in OID (not an admin user) as shown below,<\/p>\n

for e.g. username=operations, password=welcome1<\/strong><\/p>\n

When you access the E-Business console, it will display OSSO login page for login details and upon submitting those details, it will show another login page which is to map the operations user in E-Business, the second login page will appear only for the first time you access the E-Business console after OID registration.<\/p>\n

For subsequent access of E-Business console, any OID user trying to login will be mapped to operations user of E-Business application.<\/p>\n

Helpful Articles:<\/strong><\/p>\n

Metalink Note: 376811.1<\/strong><\/span><\/p>\n

We provided a dedicated module for Troubleshooting where we cover Logging in WebGate<\/strong>, OHS<\/strong>, EBS Accessgate<\/strong>, DIP<\/strong>, OAM<\/strong>, and OID<\/strong> in our EBS-OAM\/OID Integration Training<\/a> , more about training here<\/a><\/p>\n

If you have not yet downloaded FREE eBook – 7 Docs every Oracle Apps DBA must read for EBS R12 integration with OAM\/OID for SSO<\/a> get a copy in your eMail.<\/p>\n

\"banner__\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I have done the integration of E-Business suite with Oracle Single Sign-on today and would like to post few integration […]<\/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":[445],"tags":[304,31,301],"class_list":["post-2098","post","type-post","status-publish","format-standard","hentry","category-ebs-r12-oam-integration","tag-e-business-suite","tag-oid","tag-osso"],"yoast_head":"\nIntegration of E-Business suite with Oracle Single Sign-on -<\/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\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integration of E-Business suite with Oracle Single Sign-on -\" \/>\n<meta property=\"og:description\" content=\"I have done the integration of E-Business suite with Oracle Single Sign-on today and would like to post few integration […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-24T15:30:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-15T16:03:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/\",\"name\":\"Integration of E-Business suite with Oracle Single Sign-on -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png\",\"datePublished\":\"2010-08-24T15:30:09+00:00\",\"dateModified\":\"2016-12-15T16:03:37+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integration of E-Business suite with Oracle Single Sign-on\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & 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":"Integration of E-Business suite with Oracle Single Sign-on -","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\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/","og_locale":"en_US","og_type":"article","og_title":"Integration of E-Business suite with Oracle Single Sign-on -","og_description":"I have done the integration of E-Business suite with Oracle Single Sign-on today and would like to post few integration […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/","article_published_time":"2010-08-24T15:30:09+00:00","article_modified_time":"2016-12-15T16:03:37+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/","url":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/","name":"Integration of E-Business suite with Oracle Single Sign-on -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png","datePublished":"2010-08-24T15:30:09+00:00","dateModified":"2016-12-15T16:03:37+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/11\/banner__-1024x154.png"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/08\/24\/integration-of-e-business-suite-with-oracle-single-sign-on\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Integration of E-Business suite with Oracle Single Sign-on"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & 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\/2098","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=2098"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/2098\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=2098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=2098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=2098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}