Oracle EBS (E-Business Suite)

Step 1: Configure Oracle EBS with miniOrange SSO Connector

• Set aside a sub-domain for the miniOrange 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 EBS SSO connector could be installed on the sub-domain ebsauth.example.com.
• In your 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 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 E-Business Suite to reflect the changes.
• Generate a DBC file with the miniOrange 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 EBS SSO connector on your Tomcat server.
• Update the connector.properties file in your miniOrange EBS SSO 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.

Step 2: Choose Your User Directory

2.1: Setup AD as User Directory

1. Log in to miniOrange dashboard from the Admin Console.
2. From the Side Menu, Click on User Stores >> Add User Store
   
   

   
   
   

3. Select User Store type as AD/LDAP.





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.
   
   



4. Enter LDAP Display Name and LDAP Identifier of your choice. Select Directory Type as Active Directory.
5. Enter the LDAP Server URL or IP Address against LDAP Server URL field.
6. Go to AD FS-> Domain-> respective Users -> Properties-> Attribute Editor. Now copy the value of distinguishedName and paste it against Bind Account DN.



7. Enter the valid password for the user from above step.
8. Search Base is the location in the directory where the search for a user begins.



9. If you want to add extra conditions on user search you can add it in Search Filter. Select a suitable Search Filter from the Drop-Down. To use custom Search Filter select "Custom Search Filter" option and provide the search filter in the input field that shows up.



10. You can also configure following options while setting up AD.




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



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



12. On Successful connection with LDAP Server, a success message is shown.



13. Click on Test Attribute Mapping.



14. Enter a valid Username. Then, click on Test. Mapped Attributes corresponding to the user are fetched.



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

2.2: Setup miniOrange as a User Store

1. Log in to miniOrange dashboard from the Admin Console.
2. There are 3 ways to setup miniOrange as an Identity Source

2.2.1 Create User in miniOrange

2.2.2 Bulk Upload Users

2.2.3 Self User Registration




2.2.1 Create User in miniOrange

• Click on Users >> Add User.



• Here, fill the user details without the password and then click on the Create User button.



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



2.2.3 Self User Registration

• miniOrange self user registration allows end users to register themselves using customized registration form. miniOrange admin users can customize the registration form by adding more custom fields accodring to their choice. Learn More

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





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

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

For further details refer :
https://www.miniorange.com/oracle-single-sign-on-(sso)
https://www.oracle.com/in/applications/ebusiness/
https://docs.oracle.com/cd/V77972_02/current/acrobat/122ebssu.pdf
https://www.oracle.com/us/products/consulting/expert-services/e-business-single-sign-on-070175.pdf
https://blogs.oracle.com/cloudsecurity/how-to-simplify-sso-to-oracle-ebusiness-suite-in-just-3-steps