If you dont hear from us within 24 hours, please feel free to send a follow up email to info@xecurify.com
Contents
Oracle E-Business Single Sign-On (SSO)
Oracle E-Business Suite is a major product line of Oracle Corporation. Oracle EBS is a combined set of business applications for automating customer relationship management (CRM), Enterprise Resource Planning (ERP) and Supply Chain Management (SCM) processes within organizations.
As we have officially been recognized as a Global Modernized Oracle Partner Network
(OPN) Partner, you can rest assured that all of our integrations on the Oracle Stack fulfill the highest competencies set by Oracle for their trusted advisors like miniOrange.
"miniOrange Oracle EBS SSO connector enables the Single Sign-On (SSO) between Oracle EBS and any IDPs without the need to purchase and install Oracle Access Manager (OAM) and Oracle Internet Directory (OID) license."
EBS SSO connector enables the Single Sign-On (SSO) integration between any Oracle application and IDPs (Identity Providers) like miniOrange, ADFS, Active Directory, Azure AD, Google, Okta, Onelogin, Ping Idenity, Centrify and many more. It also provide SSO support for web applications which do not provide support for federated Single Sign-On (SSO) protocol such as SAML or OAuth 2.0. SSO connector gives you the flexibility of extending your existing SAML SSO integration to Oracle EBS as well. This is possible due to its capability to act as a broker between multiple IdP's & your configured applications. This states that you can perform seamless SSO integration for Oracle EBS with your existing authentication platform.
Authentication Flow for miniOrange Oracle EBS SSO (Single Sign-On) Solution:
1. The User tries to access the Oracle E-Business Suite, either directly at the AppsLogin endpoint or via a bookmarked URL.
2. Oracle EBS redirects the request to the miniOrange SSO Connector for authentication.
3. The SSO Connector sends a SAML authentication request to configured IDP.
4. The User is Prompted to enter their SSO (IDP) credentials.
5. Configured IDP sends SAML response to miniOrange SSO Connector.
6. The Connector checks the value of the username/email attribute fetched from the IDP against the FND_USER table in the Oracle EBS Database.
7. After successful authentication, a session is created for the user in Oracle EBS.
8. User is redirected to Oracle EBS as a logged-in user.
Connect with External Source of Users
miniOrange provides user authentication from various external sources, which can be Directories (like ADFS, Microsoft Active Directory, Azure AD, OpenLDAP, Google, AWS Cognito etc), Identity Providers (like Shibboleth, Ping, Okta, OneLogin, KeyCloak), Databases (like MySQL, Maria DB, PostgreSQL) and many more.
Get Free Installation Help - Book a Slot
You can request a trial version of the connector and miniOrange offers 1 hour free help through a consultation call with our System Engineers to Install or Setup Oracle E-Business SSO solution in your environment with 30 days trial.
For this, you need to just send us an email at idpsupport@xecurify.com to book a slot and we'll help you setting it up in no time.
Video Setup Guide
Follow the Step-by-Step Guide given below for Oracle E-Business Single Sign-On (SSO)
This short tutorial walks you through starting up the sso connector in standalone mode, setting up the initial
admin account, and logging into the miniOrange admin dashboard.
Pre-Requisites:
Java 8 (JDK 1.8): When you install JAVA 8, only JRE 1.8 would be present.
Note: Tomcat is already included in this distribution (zip file), you don’t have to install it
separately.
Installation of JDK 1.8 requires login through the oracle account. If you
don't have the oracle account, you can directly install JDK 1.8 from
here.
If JAVA is already installed and Environment Varibles are set correcty on your system, then you dont
need to follow this step, you can directly go to step 1.2.
Note - Once the Java installation is complete, check that the JAVA_HOME environment variable
has been set correctly.Open a command prompt and type echo %JAVA_HOME% and hit Enter. If
you see a path to your Java installation directory, the JAVA_Home environment variable has been set
correctly.If nothing is displayed, or only %JAVA_HOME% is returned, you'll need to set the JAVA_HOME
environment variable manually.
Set Java environment variables i.e. JAVA_HOME and JRE_HOME and path
variables. Lets say JDK software is installed on your computer, for example, at C:\Program
Files\Java\jdk1.8.0_221 then JAVA_HOME and JRE_HOME paths can be as mentioned -
JAVA_HOME - C:\Program Files\Java\jdk1.8.0_221
JRE_HOME - C:\Program Files\Java\jdk1.8.0_221\jre
To Save these variables, right click My Computer and select Properties > Advanced
System Settings.Click the Environment Variables button.Under System Variables, click
New.In the Variable Name field, enter:
JAVA_HOME - C:\Program Files\Java\jdk1.8.0_221
JRE_HOME - C:\Program Files\Java\jdk1.8.0_221\jre
Also update the path variable set with path : path_to_JAVA_HOME/bin.
You can Read more about java specfic environment variables.
To install EBS SSO Connector:
To start the miniOrange EBS SSO Connector, go to the bin/ directory of the EBS SSO Connector distribution (i.e. folder with
name similar to mo-ebs-sso-connector-kit (version may vary)). Execute the startup file based on your
environment.
> ...\bin\startup.bat
This short tutorial walks you through starting up the sso connector in standalone mode, setting up the initial
admin account, and logging into the miniOrange admin dashboard.
Pre-Requisites:
Java 8 (JDK 1.8): When you install JAVA 8, only JRE 1.8 would be present.
Note: Tomcat is already included in this distribution (zip file), you don’t have to install it
separately.
You can download OpenJDK8 package using
apt install openjdk-8-jdk for Debian, Ubuntu, etc. OR
yum install java-1.8.0-openjdk for Fedora, Oracle Linux, Red Hat Enterprise Linux, etc.
Linux users can use below commands to set JAVA_HOME and JRE_HOME variables
using below commands -
export JAVA_HOME=/path/to/jdk
export JRE_HOME=/path/to/jre
You can verify whether above environment variables are set correctly. Execute below commands to
verify environment variables -
echo $JAVA_HOME
echo $JRE_HOME
To install EBS SSO Connector:
To start the miniOrange EBS SSO Connector, go to the bin/ directory of the EBS SSO Connector distribution (i.e. folder with
name similar to mo-ebs-sso-connector-kit (version may vary)). Execute the startup file based on your
environment.
Linux/Unix – Execute chmod +x startup.sh to give executable permission to this file. Set relevant
permission of mo-ebs-sso-connector folder to allow the creation of new folder like temp or logs folder – chmod
755. $ .../bin/startup.sh
1.1. Setup Database
After tomcat startup, open http://localhost:8080 in browser. You will see a page to choose a database
configuration for the EBS SSO Connector. You can choose where you would like to store its data.
Oracle EBS SSO Connector gives you the flexibility to choose your database type. We
support Embedded H2 Database which is a light weight database good for testing purposes. Later you can
migrate to your production database type that is supported in the external database section. In External
Database section, we support Postgresql (ideally 9.6), MySql and Oracle Databases.
Note : Before you proceed with Embedded H2 database, make sure your system has given write
permission to the EBS SSO Connector folder i.e. mo-ebs-sso-connector-kit folder. If not then first assign the write
permission to the EBS SSO Connector folder to avoid getting stuck in permission issues. Write permission is required
because Embedded H2 database is created in EBS SSO Connector folder with the folder named data.
Select embedded Database and click on proceed.
Set up miniOrange with the embedded H2 database to get you started. You’ll need to migrate to a
supported external database before using miniOrange as a production system. This option is recommended
if you’re just using miniOrange for a test trial. The database folder is created inside the
mo-ebs-sso-connector folder named data.
Note: In case if you are stuck in permission issues, you can run commands specific to your OS to
perceed or you can follow the instructions given on pop-up.
Set up miniOrange with the external database supported in the list below. This is recommended for
production systems. miniOrange supports a number of databases and if you don’t have an established
database of choice within your organization and do not have a strong preference for any of our supported
databases, we recommend the PostgreSQL, which is free and thoroughly tested against.
You can refer to the below document to see supported versions of MySQL, MS SQL and PostgreSQL – click here.Note: If you already have a database setup which is not in the
list below. You can contact us to add support for that database.
Create an empty database in your database server – PostgreSQL/MySQL/MS SQL. Once done, start filling the form
shown below –
Enter Database Host – localhost or IP address.
Enter Database Port : PostGres – 5432 MySQL – 3306
Enter the Database Name created in your database server.
Enter username and password of your database server for the connection.
Once database is created successfully, you will be redirected to the admin set up page where you will
configure admin account for Identity Provider.
1.2. Setup Admin Account
Setup your Admin Account. Enter a Username and Password for your admin account.
Once your admin account is created, you will be auto logged in to the dashboard screen.
2. Configure Oracle EBS with miniOrange SSO Connector
Set aside a sub-domain for the miniOrange Oracle EBS SSO connector on the same domain as the EBS installation. For example, if the EBS installation has the URL apps.example.com:, the miniOrange Oracle EBS Single Sign-On connector could be installed on the sub-domain ebsauth.example.com.
Go to Admin -> Product Settings.
Set Auth Server Base URL as ebs subdomain.
Click on Save.
In your Oracle E-Business Suite installation, login as SYSADMIN and do the following:
Create a new user, and assign them the role with code: UMX|APPS_SCHEMA_CONNECT. Make a note of the credentials for this user.
Navigate to Functional Administrator → Core Services → Profiles, and make the following changes:
Search for the Profile with code APPS_SSO; change its site value from SSWA to SSWA w/SSO.
Search for the Profile with the code APPS_AUTH_AGENT; change its site value to the full URL (FQDN) of the miniOrange Oracle EBS SSO connector (e.g. http://ebsauth.example.com/ebsauth).
Search for the Profile with the name Oracle Applications Session Cookie Domain; change its value from Host to Domain.
Bounce the Application Tier of the Oracle E-Business Suite to reflect the changes.
Generate a DBC file with the miniOrange Oracle EBS SSO connector domain (e.g. ebsauth.example.com) using the AdminDesktop utility in EBS; make a note of the APPL_SERVER_ID value present in this newly generated file.
Add an OpenID application in your miniOrange Oracle EBS SSO connector installation; the redirect URI should be as follows: http(s)://./ebsauth/redirect. For example, http://ebsauth.example.com/ebsauth/redirect.
Make a note of the authorize endpoint (for external broker), token endpoint, and user info endpoint URLs.
Deploy the miniOrange Oracle EBS SSO connector on your Tomcat server.
Update the EBS connector.properties file in your miniOrange Oracle EBS Single Sign-On connector to reflect the credentials for the user created after login as SYSADMIN in the Oracle EBS installation, the path of the generated DBC file & the APPL_SERVER_ID that is present in the DBC file.
3. Test SSO Configuration
Test SSO login to your Oracle E-Business account with miniOrange IdP:
Using SP Initiated Login
Go to your Oracle E-Business URL, here you will be either asked to enter the username or click on the SSO link which will redirect you to miniOrange IdP Sign On Page.
Enter your miniOrange login credential and click on Login. You will be automatically logged in to your Oracle E-Business account.
miniOrange provides user authentication from various external sources, which can be Directories (like ADFS, Microsoft Active Directory, Azure AD, OpenLDAP, Google, AWS Cognito etc), Identity Providers (like Okta, Shibboleth, Ping, OneLogin, KeyCloak), Databases (like MySQL, Maria DB, PostgreSQL) and many more. You can configure your existing directory/user store or add users in miniOrange.
Here, fill the user details without the password and then click on the Create User button.
After successful user creation a notification message "An end user is added successfully" will be displayed at the top of the dashboard.
Click on On Boarding Status tab. Check the email, with the registered e-mail id and select action Send Activation Mail with Password Reset Link from Select Action dropdown list and then click on Apply button.
Now, Open your email id. Open the mail you get from miniOrange and then click on the link to set your account password.
On the next screen, enter the password and confirm password and then click on the Single Sign-On (SSO) reset password button.
Now, you can log in into miniOrange account by entering your credentials.
2. Bulk Upload Users in miniOrange via Uploading CSV File.
Navigate to Users >> User List. Click on Add User button.
In Bulk User Registration Download sample csv format from our console and edit this csv file according to the instructions.
To bulk upload users, choose the file make sure it is in comma separated .csv file format then click on Upload.
After uploading the csv file successfully, you will see a success message with a link.
Click on that link you will see list of users to send activation mail. Select users to send activation mail and click on Send Activation Mail. An activation mail will be sent to the selected users.
Click on User Stores >> Add User Store in the left menu of the dashboard.
Select User Store type as AD/LDAP.
STORE LDAP CONFIGURATION IN MINIORANGE: Choose this option if you want to keep your configuration in miniOrange. If active directory is behind a firewall, you will need to open the firewall to allow incoming requests to your AD.
STORE LDAP CONFIGURATION ON PREMISE: Choose this option if you want to keep your configuration in your premise and only allow access to AD inside premises. You will have to download and install miniOrange gateway in your premise.
Enter LDAP Display Name and LDAP Identifier name.
Select Directory Type as Active Directory.
Enter the LDAP Server URL or IP Address against LDAP Server URL field.
Click on Test Connection button to verify if you have made a successful connection with your LDAP server.
In Active Directory, go to the properties of user containers/OU's and search for Distinguished Name attribute.
Enter the valid Bind account Password.
Click on Test Bind Account Credentials button to verify your LDAP Bind credentials for LDAP connection.
Search Base is the location in the directory where the search for a user begins. You will get this from the same place you got your Distinguished name.
Select a suitable Search filter from the drop down menu. To use custom Search Filter select "Custom Search Filter" option and customize it accordingly.
You can also configure following options while setting up AD. Enable Activate LDAP in order to authenticate users from AD/LDAP. Click on the Save button to add user store.
Here's the list of the attributes and what it does when we enable it. You can enable/disable accordingly.
Attribute
Description
Activate LDAP
All user authentications will be done with LDAP credentials if you Activate it
Sync users in miniOrange
Users will be created in miniOrange after authentication with LDAP
Backup Authentication
If LDAP credentials fail then user will be authenticated through miniOrange
Allow users to change password
This allows your users to change their password. It updates the new credentials in your LDAP server
Enable administrator login
On enabling this, your miniOrange Administrator login authenticates using your LDAP server
Show IdP to users
If you enable this option, this IdP will be visible to users
Send Configured Attributes
If you enable this option, then only the attributes configured below will be sent in attributes at the time of login
Click on Save. After this, it will show you the list of User stores. Click on Test Configuration to check whether you have enter valid details. For that, it will ask for username and password.
On Successful connection with LDAP Server, a success message is shown.
Click on Test Attribute Mapping.
Enter a valid Username. Then, click on Test. Mapped Attributes corresponding to the user are fetched.
After successful Attribute Mapping Configuration, go back to the ldap configuration and enable Activate LDAP in order to authenticate users from AD/LDAP.
Enable the "Enable User Auto Registration" option and click Save.
(Optional) To send a welcome email to all the end users that will be imported, enable the "Enable sending Welcome Emails after user registration" option and click Save.
From the Left-Side menu of the dashboard select Provisioning.
In Setup Provisioning tab select Active Directory in the Select Application Drop Down.
Toggle the Import Users tab, click on Save button.
On the same section, switch to Import Users section.
Select Active Directory from the dropdown and click on the Import Users tab, to import all the users from Active Directory to miniOrange.
You can view all the Users you have imports by selecting Users >> User List from Left Panel.
All the imported users will be auto registered.
These groups will be helpful in adding multiple 2FA policies on the applications.
miniOrange integrates with various external user sources such as directories, identity providers, and etc.
Scenario 1: User has not logged in, no session exists
If any SAML IDP like Okta, ADFS, Ping is configured, user is directly redirected to IDP login page. If no IDP and customer only has Active Directory then he will be redirected to miniOrange login page.
Here, the user will have to enter their Active Directory credentials - userPrincipalName and password.
The miniOrange server will then authenticate the user against the Active Directory (AD), and perform authorization for accessing the user’s username and email address.
This username and email address will then be matched against the table of users in the Oracle E-Business Suite database (FND_USER), and the user will be logged in.
Scenario 2: User has logged in, session is active
When a user session already exists, the user can directly navigate to any of their bookmarked Oracle E-Business Suite URLs.
No authentication is required in this case; the user’s session information is retrieved from the ICX session cookie that’s present in the browser.
6. Run EBS SSO Connector over SSL(optional)
Before moving forward, you need to make two changes related to samesite cookie. Starting with version 80,
Google Chrome will change the default value for the SameSite cookie parameter to Lax.
Therefore, changes are required and SameSite parameter has to be set to NONE.
To do changes, follow the path: mo-ebs-sso-connector >> moas >> WEB-INF >> classes. In this folder search for the
file spring-context-onpemise and open it in editor. Search for bean id="customCookie". you
will see a bean with name,samesite and secure properties. Update value of samesite from LAX to
NONE and of secure to true.
This document provides the steps to setup EBS SSO Connector over SSL . It contains 2 sections A and B.
Section A: This section provides the steps to setup EBS SSO Connector over self signed SSL certificate.
6.1. Generate a Keystore
Open a command prompt or terminal. And go to <Path to JAVA_HOME/bin> path and enter the
command given below. keytool -genkey -alias ebssoconnector -keyalg RSA -keystore ebssoconnector.jks
If you get a permission error (mostly on a windows machine) in this step.Then change the location
in command prompt or terminal to Desktop or any other location of your choice. See image in Step 2.
Enter your convenient password and remember it.(If the password you entered didn’t work then keep
the password as “changeit” ).
6.2. Generate SSL Certificate
After Pressing the Return key it will prompt for a password for . Hit Return to
continue. (Note: firstname and lastname needs to be the server DNS name/hostname of the
server)
SSL self-signed certificate is generated at the given location.
6.3. Configure Tomcat with above-generated Keystore
Section A: This section provides the steps to setup EBS SSO Connector over self signed SSL certificate.
