Configure SSO for Apex Application

Sometime back I discussed about Apex (earlier HTMLDB) Installation, Click Here to know more about apex Installation . Today I am going to cover how to configure Single Sign-On for Apex Applications. If you are new to Oracle SSO (Single Sign-On) and want to know more about Oracle SSO Click Here for Overview of Oracle SSO

There are mainly three major steps in configuring Apex / HTMLDB
–Register Apex as Partner Application in SSO Server
–Install SSO SDK on Apex Server
–Register SSO details on Apex Middle Tier

Assumptions in below configuration
Below configuration is based on following assumptions, You may need to change things as per your apex/sso version.

— Apex version discussed below is for 2.0.2.0.0 (Change schema name flows_020200 according to your version)
— Apex is installed on 10g AS , if you don’t see ssosdk902.zip then get it from 10g AS middle tier — You have access to Oracle SSO Server with Admin privileges (orcladmin) account
–You have access to schema under which Apex was installed , In my discussion below database schema name for Apex is “apex
— URL to access Apex Application is http: // apex_server_name/pls/apex

Configure Apex as Partner application in Oracle SSO Server

Type URL as http: // ssoserver.com/pls/orasso & login as orcladmin, you will see screen like

Click on SSO Server Administration & then you will get Administration Screen

Under that click on “Administer Partner Application

Click on Add Partner Application

You will come to Partner application Login Screen enter following details & click on “OK

Name : SSO Apex
HOME URL : http: // apex_server_name/pls/apex
Success URL : http: // apex_server_name/pls/apex/wwv_flow_custom_auth_sso.process_success
Log Out URL : http: // apex_server_name/pls/apex/apex

and click on OK, you will get screen with values like ID, Token, Encryption Key, Login URL, Single Sign-Off URL … Keep a note of these values as these will be used during Apex Registration process in Next Steps

Remaining Steps: Installing SSO SDK in Apex & Registering Apex with SSO Partner Application created above coming in Next Topic …

About the Author Masroof Ahmad

Leave a Comment:

23 comments
Add Your Reply