{"id":1520,"date":"2010-02-19T02:27:01","date_gmt":"2010-02-19T06:27:01","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/"},"modified":"2010-02-19T02:27:01","modified_gmt":"2010-02-19T06:27:01","slug":"oracle-sso-provisioning-for-apex","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/","title":{"rendered":"Oracle SSO provisioning for APEX"},"content":{"rendered":"

This section deals with provisioning Oracle SSO for APEX application.
\n1. Register APEX as partner application in Oracle Application server.
\nNote some of the details as shown below.
\nID: 80F63272
\nToken: 51J0903680F63272
\nEncryption Key: EBBD933BC541FAFF
\nLogin URL: http:\/\/directory_server_hostname:7777\/pls\/orasso\/orasso.wwsso_app_admin.ls_login<\/a>
\nSingle Sign-Off URL: http:\/\/<\/a>directory_server_hostname<\/a>:7777\/pls\/orasso\/orasso.wwsso_app_admin.ls_logout<\/a>
\nName : APEX<\/strong>
\nHome URL : http:\/\/apex_hostname:8080\/apex<\/a>
\nSuccess URL : http:\/\/<\/a>apex_hostname<\/a>:8080\/apex\/wwv_flow_custom_auth_sso.process_success<\/a>
\nLogout URL :http:\/\/<\/a>apex_hostname<\/a>:8080\/apex<\/a>
\nThis Application Name APEX<\/strong> will be used in 5th step while associating SSO application name in the Authentication scheme.
\n2. Next step is to install SDK package and configuration.
\nExtract the sdk902.zip file present in middle tier to the local machine.
\nLogin as FLOWS_xxxx user and execute @loadsdk.sql.
\nThen logout and login again, and execute @regapp.sql by inputting some parameters of Partner application.
\nEnter value for listener_token: HTML_DB:sbpdb.idc.oracle.com:8080
\nEnter value for site_id: 80F63272
\nEnter value for site_token: 51J0903680F63272
\nEnter value for login_url: http:\/\/<\/a>directory_server_hostname<\/a>:7777\/pls\/orasso\/orasso.wwsso_app_admin.ls_login<\/a>
\nEnter value for encryption_key: EBBD933BC541FAFF
\nEnter value for ip_check: N
\nIt is important that listener_token should be in the format HTML_DB:hostname_where_apex_installed:port_no_apex_listens<\/strong>.
\nWhen the registration is successful, then the result will be as shown below:
\nRegistration successful.
\nListener token: HTML_DB:sbpdb.idc.oracle.com:8080
\nSite id : 80F63272
\nSite token : 51J0903680F63272
\nEncryption key: EBBD933BC541FAFF
\nLogin URL : http:\/\/<\/a>directory_server_hostname<\/a>:7777\/pls\/orasso\/orasso.wwsso_app_admin.ls_login<\/a>
\nLogout URL : http:\/\/<\/a>directory_server_hostname<\/a>:7777\/pls\/orasso\/orasso.wwsso_app_admin.ls_logout<\/a>
\nIP check : N
\n3. Third step is to execute custom_auth_sso_902.sql and custom_auth_sso_902.plb as FLOWS_xxxx user.
\n4. Grant execute permissions as shown below:
\ngrant execute on wwv_flow_custom_auth_sso to APEX_PUBLIC_USER;
\n5. Login to APEX console, and create Authentication scheme with name CUSTOM SSO and map the SSO Partner application as APEX (as in the first step).<\/p>\n

Congrats, you have finished SSO configurations for APEX.
\nNow login to apex application (for eg, http:\/\/<\/a>apex_hostname<\/a>:8080\/apex\/f?p=104:2<\/a>) and check SSO login page will be displayed.<\/p>\n","protected":false},"excerpt":{"rendered":"

This section deals with provisioning Oracle SSO for APEX application. 1. Register APEX as partner application in Oracle Application server. […]<\/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":[40],"tags":[],"class_list":["post-1520","post","type-post","status-publish","format-standard","hentry","category-sso"],"yoast_head":"\nOracle SSO provisioning for APEX -<\/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\/02\/19\/oracle-sso-provisioning-for-apex\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SSO provisioning for APEX -\" \/>\n<meta property=\"og:description\" content=\"This section deals with provisioning Oracle SSO for APEX application. 1. Register APEX as partner application in Oracle Application server. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-02-19T06:27:01+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=\"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\/02\/19\/oracle-sso-provisioning-for-apex\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/\",\"name\":\"Oracle SSO provisioning for APEX -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2010-02-19T06:27:01+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SSO provisioning for APEX\"}]},{\"@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":"Oracle SSO provisioning for APEX -","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\/02\/19\/oracle-sso-provisioning-for-apex\/","og_locale":"en_US","og_type":"article","og_title":"Oracle SSO provisioning for APEX -","og_description":"This section deals with provisioning Oracle SSO for APEX application. 1. Register APEX as partner application in Oracle Application server. […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/","article_published_time":"2010-02-19T06:27:01+00:00","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\/02\/19\/oracle-sso-provisioning-for-apex\/","url":"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/","name":"Oracle SSO provisioning for APEX -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2010-02-19T06:27:01+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/02\/19\/oracle-sso-provisioning-for-apex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle SSO provisioning for APEX"}]},{"@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\/1520","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=1520"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1520\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=1520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=1520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=1520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}