Oracle EBS

Pre-requisite

Steps to Install and Setup Oracle E-Business

• Log in to the OCI Service Console.
• Select Menu >> Marketplace which is on the left-hand panel under the heading SOLUTIONS, PLATFORM AND EDGE.
• Click on Oracle E-Business Suite 12.2.8 Demo Install Image.
• Click on Launch Instance.
• If you found multiple packages then select the latest package version from the dropdown list.
• Select the compartment where you want to install Oracle E-Business Suite.
• Review and accept the Terms of use and click on Launch Instance again.
• In the Create Compute Instance dialog box, specify the following details:
• Enter Name your instance, enter name as per your requirement.
• In Select an availability domain for your instance, make a suitable selection from the displayed options.
• Under Choose an operating system or image source, you will able to see the name of the OCI Console Marketplace image: Oracle E-Business Suite 12.2.8 Demo Install Image.
• In Choose instance type, select option Virtual Machine.
• In Choose instance shape, you will find a default shape. In case, if you want to specify another shape then click on Change Shape.
• In Configure Boot Volume accept the default volume size.
• In Add SSH Key, add file which containing your previously generated SSH public key.
• In Configure Networking, select your Virtual cloud network compartment, Virtual cloud network, Subnet compartment, Subnet.
  Note: If the VM is associated with a public subnet and you want to assign a public IP address then click on the Show Advanced Options link and choose the Networking tab, and then click on Assign public IP address box.
• Click on Create .
• Now, Establish SSH Connection.
• Review the security lists associated with the subnet to ensure that an ingress rule exists with the following attributes:
  Select SOURCE TYPE as CIDR .
• Select SOURCE CIDR as per your requirement.
  Note that 0.0.0.0/0 corresponds to the public internet. We recommend restricting this to the CIDR block that corresponds to the IP range you want to give access to.
• Enter IP PROTOCOL as SSH (TCP/22) .
• Enter DESTINATION PORT as 22 .
• When the instance is fully provisioned and running, connect to it using SSH as described in Connecting to an Instance.
• After the instance has been created (provisioned), it will appear in the instance list. To view full details about it, including IP addresses, click the instance name in the list.

Step 1: Configure Oracle EBS in miniOrange

• Log in as a customer from the Admin Console.
• Go to Apps >> Manage Apps. Click on Configure Apps button.
• Click on Browser Add on / Form Post tab .




• Select Oracle EBS app.
• Select Group name as default.
• Here you can see the following two options
• INDIVIDUAL LOGIN ACCOUNT : If each user has a different username and password for the app, admin should choose an individual login account option, so that users can save their username and password from the user portal themselves.
• SHARED LOGIN ACCOUNT :If multiple users are allowed to access the app via same credentials assigned by admin, admin should choose share Login Account option.





• Go to miniOrange dashboard and select User Dashboard from right side menu.




• Scroll down on the same page under the section of configure your cloud apps section and search for Oracle EBS app, on the app icon you will find setting option. Click on it and select Configure. (If you are unable to find app in this list then please contact us.)



• Once you done with configuration, scroll up on same page, under the SIGN-IN TO YOUR FAVOURITE CLOUD APPS section search for Oracle EBS app. On Oracle EBS app icon, click on the download symbol.
• It will redirect you to add extension page. Now, click on the Add to Chrome.




• Click on Add extension.




• Now, miniOrange extension is added in your extension
• Click on the app icon from miniOrange user portal, you will be redirected to Oracle EBS login page.



• Now browser extension will fill the username and password credentials automatically. Once enabled, end users can see an icon on their browser which auto-fills username and password on the application login page and submit the page automatically to let user access the app.
• Now, you can see the homepage of the app.

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.

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 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: Steps to embed Oracle EBS application link in your own website/user portal

• Go to admin dashboard -> Apps -> search for Oracle EBS app -> Click on Link in Action menu against Oracle EBS app.




• Copy the app link and paste it anywhere on your own website - User portal/ Apps Dashboard /Menu, etc.

Step 4: Adaptive Authentication with Oracle EBS

4.1: Restricting access to Oracle EBS with IP Blocking

You can use adaptive authentication with Oracle EBS Single Sign On (sso) to improve the security and functionality of Single sign-on. You can allow a IP Address in certain range for SSO or you can deny it based your requirements and you can also challenge the user to verify his authenticity. Adaptive authentication manages the user authentication bases on different factors such as Device ID, Location, Time of Access, IP Address and many more.

You can configure Adaptive Authentication with IP Blocking in following way


• Login to Self Service Console >> Adaptive Authentication.
• Add a Policy Name for your Adaptive Authentication Policy.



• Select your Action for Behavior Change and Challenge Type for user.





Action for Behavior Change Options :




Attribute	Description
Allow	Allow user to authenticate and use services if Adaptive authentication condition is true.
Challenge	Challenege users with one of the three methods mentioned below for verifying user authenticity.
Deny	Deny user authentications and access to services if Adaptive authentication condition is true.




Challenge Type Options :




Attribute	Description
User second Factor	The User needs to authenticate using the second factor he has opted or assigned for such as OTP over SMS PUSH Notofication OTP over Email And 12 more methods.
KBA (Knowledge-based authentication)	The System will ask user for 2 of 3 questions he has configured in his Self Service Console. Only after right answer to both questions user is allowed to proceed further.
OTP over Alternate Email	User will recieve a OTP on the alternate email he has configured threw Self Service Conolse. Once user provides the correct OTP he is allowed to proceed further.



• Now Disbale Allow all IP'S option from the IP Blocking Configuration section to configure custom IP range.



• Select the Action you want to perform if the IP address is out of the range. i.e Allow, Challenge & Deny.
• Specify the IP Address range for which you want above setting to reflect. You can add more than one IP Address ranges by clicking on following button +.
• Scroll to the end and click on save.



Add Adaptive Authentication policy to Oracle EBS

• Login to Self Service Console >> Policies.
• Click on Edit option for predefined SAML app policy.



• Enable Enable Adaptive Authentication option on Policy page and select Device-Id as the Method.
• From the Select Login Policy dropdown select the policy we created in last step and click on save.



• In above mentioned way you can set Adaptive Authentication for Oracle EBS

4.2: Adaptive Authentication with Limiting number of devices.

Using Adaptive Authentication you can also restrict the number of devices the end user can access the Services on. You can allow end users to access services on a fixed no. of devices. The end users wii be able to access services provided by us on this fixed no. of devices.

You can cofigure Adaptive Authentication with Device Restriction in follwing way


• Login to Self Service Console >> Adaptive Authentication.
• Add a Policy Name for your Adaptive Authentication Policy.
• Select your Action for Behavior Change and Challenge Type for user.





• Scroll down to Device Configuration section and enable Allow User to Register Device option to allow users to register their devices.
• Enter the Number of Devices which are allowed to register in field next to Number of Device Registrations Allowed



• Choose Action if number of devices exceeded (This will override your setting for Action for Behaviour Change.)
1. Challenge: The user needs to verify himself using any of the three methods mentioned in table in step 4.1
2. Deny : Deny users access to the system
• Enable option Send email alerts to Users if number of Device registrations exceeded allowed count if you want to alert the user about no of devices exceeding the limit. Save the configuration.





Add Adaptive Authentication policy to Oracle EBS

• Login to Self Service Console >> Policies.
• Click on Edit option for predefined SAML app policy.



• Enable Adaptive Authentication on Policy page and select Device-Id as the Method.
• From Select Login Policy dropdown select the policy we created in last step and click on save.




How to add a trusted Device

1. When End-user log in to the self service console after the policy for device restriction is on, he is provided the option to add the current device as a trusted device.

Step 5. Sync Password Feature

It's a hassle to configure Username and Password for each user. For an easy and seamless experience, miniOrange provides a password sync feature. This feature is useful for both new users and existing users of Oracle EBS.

1. From a new users perspective:

For regular password managers, a new user has to manually save his Oracle EBS credentials so that the password manager is able to pick up the credentials and autofill credentials on the login form. It's a hassle for the user. This is where the sync password feature comes into the picture. miniOrange Password sync feature makes this seamless. Users creating their accounts with miniOrange would have their credentials synced to the Oracle EBS application database. miniOrange syncs the password of new users automatically to Oracle EBS application database so that new user does not have to worry about their respective usernames and password.

2. From Existing Users perspective:

This particular use-case is useful in case when customer admin already has few users and wants to integrate miniOrange for SSO. In this case, customer admin will import all the existing users from the user store into miniOrange. As users are imported miniOrange would generate new passwords for Oracle EBS application. These credentials will then get automatically synced to the Oracle EBS application database.

For further details refer :
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