Hello there!

Need Help? We are right here!

support
miniOrange Email Support
success

Thanks for your inquiry.

If you dont hear from us within 24 hours, please feel free to send a follow up email to info@xecurify.com

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.

"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:


Oracle EBS (E-Business Suite) SSO Authentication flow

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.



Oracle EBS Single Sign-On (SSO) Authentication demo


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.



Video Setup Guide


Follow the Step-by-Step Guide given below for Oracle E-Business Single Sign-On (SSO) Integration

1. 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.
  • 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 your external data source (e.g. Active Directory) in the User Store section in your miniOrange Cloud/On-Premise installation; set this user store as the default user store (Prefer Step 2).
  • Add an OpenID application in your miniOrange Cloud/On-Premise 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 in step 2, the path of the DBC file & the APPL_SERVER_ID from step 3, and the endpoint URLs from step 5.

2. 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.



  • To add your users in miniOrange there are 2 ways:
  • 1. Create User in miniOrange

    • Click on Users >> Add User.
    • Oracle E-Business  VPN 2FA : Add user in miniOrange

    • Here, fill the user details without the password and then click on the Create User button.
    • Oracle E-Business  MFA: Add user details

    • After successful user creation a notification message "An end user is added successfully" will be displayed at the top of the dashboard.
    • Oracle E-Business  Two-Factor Authentication: Add user details

    • 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.
    • Oracle E-Business  2FA: Select email action

    • 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.
    • Oracle E-Business  Multi-Factor Authentication: Reset user password
    • 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.
    • Oracle E-Business  2FA: Add users via bulk upload

    • In Bulk User Registration Download sample csv format from our console and edit this csv file according to the instructions.
    • Oracle E-Business  Two-Factor authentication: Download sample csv file

    • To bulk upload users, choose the file make sure it is in comma separated .csv file format then click on Upload.
    • Oracle E-Business  2FA : Bulk upload user

    • 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.
  • On miniOrange dashboard left side menu, click on User Stores >> Add User Store.
  • Oracle E-Business  2FA: Configure User Store

  • Select User Store type as AD/LDAP.
  • Oracle E-Business  2FA: Select AD/LDAP as user store

    1. 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.
    2. 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.
    3. Oracle E-Business  Two-Factor Authentication : Select ad/ldap user store type

  • 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.
  • Oracle E-Business  MFA/2FA: Configure LDAP server URL Connection

  • In Active Directory, go to the properties of user containers/OU's and search for Distinguished Name attribute.
  • Oracle E-Business  MFA: Configure user bind account domain name

  • Enter the valid Bind account Password.
  • Click on Test Bind Account Credentials button to verify your LDAP Bind credentials for LDAP connection.
  • Oracle E-Business  MFA: Check bind account credentials

  • 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.
  • Oracle E-Business  2FA : Configure user search base

  • Select a suitable Search filter from the drop down menu. To use custom Search Filter select "Custom Search Filter" option and customize it accordingly.
  • Oracle E-Business  MFA/2FA : Select user search filter

  • 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.
  • Oracle E-Business  MFA : Activate LDAP options

    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.
  • Oracle E-Business  2FA: Test AD/Ldap connection

  • On Successful connection with LDAP Server, a success message is shown.
  • Click on Test Attribute Mapping.
  • Oracle E-Business  LDAP successful connection

  • Enter a valid Username. Then, click on Test. Mapped Attributes corresponding to the user are fetched.
  • Oracle E-Business  MFA: Fetch mapped attributes for user

  • 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.
  • MFA/Two-Factor Authentication(2FA) for   miniOrange dashboard

  • Enable the "Enable User Auto Registration" option and click Save.
  • MFA/Two-Factor Authentication(2FA) for   Enable User Auto Registration

  • (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.
  • MFA/Two-Factor Authentication(2FA) for   Enable sending Welcome Emails after user registration

  • From the Left-Side menu of the dashboard select Provisioning.
  • MFA/Two-Factor Authentication(2FA) for   User Sync/Provisioning

  • In Setup Provisioning tab select Active Directory in the Select Application Drop Down.
  • Toggle the Import Users tab, click on Save button.
  • MFA/Two-Factor Authentication(2FA) for   User Sync Active Directory Configuration

  • 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.
  • MFA/Two-Factor Authentication(2FA) for   User Sync Import Operation

  • You can view all the Users you have imports by selecting Users >> User List from Left Panel.
  • MFA/Two-Factor Authentication(2FA) for   User List

  • 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.

Not able to find your IdP or Need help setting it up?


Contact us or email us at idpsupport@xecurify.com and we'll help you setting it up in no time.



3. Oracle EBS Suite Login Flow

Scenario 1: User has not logged in, no session exists

  • When a user accesses any of their bookmarked Oracle E-Business Suite URLs without previously having logged in, a user from the original login (Oracle EBS login page) page will be redirected to the miniOrange login page.
  • Oracle E-Business  Single Sign-On (sso) home Login page

    Oracle E-Business  SSO (Single Sign-on) submit miniorange user credentials

  • 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.
  • Oracle E-Business  SSO login successful


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.

4. Oracle EBS (E-Business Suite) Provisioning with Active Directory

  • Auto-Create user at the time of login authentication.
  • Import Users from Active Directory and Sync them in Oracle EBS from miniOrange admin portal.
  • Setup a scheduled sync to create/update/deactivate AD users in Oracle EBS on a daily basis.

External References

Our Other Identity & Access Management Products