Oracle E-Business Suite Single Sign-On (Oracle EBS 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 - such as Oracle EBS SSO - fulfill the highest competencies set by Oracle for their trusted advisors like miniOrange.
"miniOrange 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."
Oracle 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 - and Oracle EBS SSO successfully executes.
8. User is redirected to Oracle EBS as a logged-in user.
Integrate Oracle EBS SSO with any IDP
Get Free Installation Help - Book a Slot
You can request a trial version of Oracle EBS SSO and miniOrange offers 1 hour free help through a consultation call with our System Engineers to Install or Setup Oracle E-Business Suite 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.
Prerequisites
- Download the miniOrange SSO Connector [Contact Us to request for the archive].
- Setup the connector by following the steps in this document. The connector should be hosted on the same domain as your Oracle EBS Apps Tier; for example, if your Oracle EBS Web Entry FQDN is apps.example.com, the connector can be hosted on ebsauth.example.com.
- Once the connector is set up, modify the file context.xml present under /conf & add the following line under the element:
<CookieProcessor className="org.apache.tomcat.util.http.LegacyCookieProcessor" />
- Your context.xml file should look like this:

- Restart the Apache Tomcat server for this change to take effect.
Follow the Step-by-Step Guide given below for Oracle E-Business Suite Single Sign-On (SSO)
1. Create Oracle EBS User & Generate DBC File
- Login to Oracle EBS as SYSADMIN (or a user with the User Management & Functional Administrator responsibilities).
- Under the User Management responsibility, add a User Account. These user credentials will be configured in the miniOrange SSO Connector for connecting to the Oracle EBS database.

- Assign the role ‘Apps Schema Connect’ to this user.

- On the Oracle EBS Linux Environment, generate a new DBC file for use by the miniOrange SSO Connector. You will need the apps user credentials, and the default DBC file (under $FND_SECURE) used by the Apps Tier.
The AdminDesktop utility can be used to generate the new DBC file. You’ll have to specify the name of a new Desktop Node for this DBC file:
java oracle.apps.fnd.security.AdminDesktop <apps-username>/<apps-password>
CREATE NODE_NAME=<miniorange-sso-connector-fqdn> DBC=<path-to-existing-dbc-file>
- This will generate a file called <$TWO_TASK>_<miniorange-sso-connector-fqdn>.dbc in the same location as where your ran the previous command.
- Copy over this DBC file to the miniOrange SSO Connector server.
2. Configure an Oracle EBS application in the miniOrange SSO Connector
- Login to the miniOrange SSO Connector as the Admin user (created during the setup).
- Go to Applications >> JWT >> Oracle EBS
- Enter the details according to the table below:
Instance Name |
An identifier for your Oracle EBS Instance e.g. Production, Pre-Production, Test |
FND Username |
The username of the user created in Step 1 |
FND User Password |
The password of the user created in Step 1 |
DBC File Path |
The absolute path (on the miniOrange SSO Connector Server) to the DBC file created in Step 1 |
APPL Server ID |
The APPL_SERVER_ID of the Desktop Node created in Step 1. This value will be present in the DBC file created in Step 1 |
Default Homepage URL |
The URL of the Homepage for your Oracle EBS instance, e.g. https://apps.example.com:4443/OA_HTML/OA.jsp?OAFunc=OAHomepage |
Post Logout Redirect URL |
The URL of the website/page that you’d like to redirect your users to after logging out from Oracle EBS
e.g. https://apps.example.com:4443 (This will redirect your logged-out users back to the Identity Source for authentication) |
- Click on save once all values are entered.
- In the Apps section, and click on Select >> Edit in the Action dropdown for your newly-added Oracle EBS instance. Make a note of the greyed-out APPS_AUTH_AGENT Profile Value URL.
3. Configure Your User Directory (Optional)
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.
- 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.
Refer our guide to setup LDAPS on windows server.
User Import and Provisioning from AD
- Go to Settings in the Customer Admin Account.

- 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.
4. Test IdP-initiated Single Sign-On into Oracle EBS
- Open up a new browser or an incognito window, and paste the APPS_AUTH_AGENT Profile Value URL from Step 2, with ‘/ssologin’ appended to it, in the address bar.
For example, if your APPS_AUTH_AGENT Profile Value URL is ‘https://ebsauth.example.com/osso/broker/1/app-uuid-value’, enter the following URL in the address bar:
https://ebsauth.example.com/osso/broker/1/app-uuid-value/ssologin
- You should be redirected to the Identity Source against which you’d like to authenticate.

- After a successful authentication from the Identity Source, you should be logged into Oracle EBS.

5. Configure Redirection to Single Sign-On from Oracle EBS
- Login to Oracle EBS as SYSADMIN (or a user with the Functional Administrator responsibility).
- 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 APPS_AUTH_AGENT Profile Value from Oracle EBS configuration (e.g. https://ebsauth.example.com/oracle/sso/<customerId>/<appUuid>).
- 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.
6. Test SP-initiated Single Sign-On from Oracle EBS
- Open up a new browser or an incognito window, and enter your Oracle EBS instance’s base URL in the address bar (e.g. https://apps.example.com:4443/), and press enter.
- You should be redirected to the Identity Source configured for authentication.

- After a successful authentication from the Identity Source, you should be logged into Oracle EBS.

- You have now successfully configured the miniOrange SSO Connector for Single Sign-On into Oracle EBS.
External References
Note: Oracle and Java are registered trademarks of Oracle and/or its affiliates. miniOrange is a separate entity.