Oracle E-Business Suite (EBS) is one of the primary applications useMango™ targets for testing and it does it well, provided the forms actually open. When developing useMango™ we have found that one of the major pains of getting tests to run reliably lies withing configuring the desktop environment rather than actually building the test.

One such issue stems from having an older version of Oracle EBS together with more modern versions of Internet Explorer, Java and even Windows. Today I will cover how to enable testing Oracle EBS with the configuration I am currently using, most of which should be applicable to similar setups:

  • Windows 10 (Professional)
  • Internet Explorer 11
  • Oracle EBS 12.2.2

Trusted sites

First up we need to ensure that the Oracle site is added to the trusted sites. This unlocks several security blocks in place in Internet Explorer that may interfere with running tests on the web page.

  1. Open Internet Explorer
  2. Navigate to your Oracle web URL
  3. Open the Internet Options
  4. Security tab
  5. Select Trusted sites
  6. Uncheck Require server verification if your URL doesn’t start with https://
  7. Click Add
  8. Click close
  9. Click Apply

Compatibility mode

Older versions of Oracle EBS ships with a hard coded version comparison for downloading the correct Java libraries when starting the Oracle EBS forms. Unfortunately this is closely tied to the Internet Explorer version which means that without running Internet Explorer in compatibility mode, Oracle with simply not allow Java to run. If we configure Internet Explorer to run in compatibility mode however, Oracle will interpret it as an older version of Internet Explorer and the Java applet will run just fine.

  1. Open Internet Explorer and navigate to your Oracle URL
  2. In the Tools menu, click Compatibility View settings
  3. Click Add
  4. Click Close

The page should now reload and may look slightly different since it is being rendered using legacy rules.

Launching Java

Before running any tests we need to ensure the correct version of Java is installed and that the applet can run properly. We do this simply by logging in to the application and opening a forms page. This should prompt us with a prompt to install Java (1.6.0_27). This is where things become complicated though. Even though we manage to install the correct version of Java, sometimes the applet simply won’t start. The issue may have to do with compatibility between your windows environment and this old version of Java. To verify this is the issue:

  1. You have tried launching the form, a time glass or similar mouse cursor may have been displayed but nothing happens
  2. Examine the task bar tray, find the Java icon
  3. Right click
  4. Select Open Control Panel
  5. Nothing happens..

If the above is true, you are likely suffering from the compatibility issues.

oracle-issues-opening

To fix this:

  1. Open task manager (start menu and search for task manager)
  2. Find any java processes and kill them (you may have to select More details to list all processes)
  3. Find the Java installation directory bin folder (usually found at C:\Program Files (x86)\Java\jre6\bin)
  4. Right click jp2launcher.exe
  5. Click Properties
  6. Select Compatibility tab
  7. Press Change settings for all users
  8. Check Run this program in compatibility mode for:
  9. Select Windows 98 / Windows ME
  10. Click OK
  11. Click OK
  12. Go back to the Oracle web page and open the form again

The Oracle applet should now launch.

In many environments some of these settings may be blocked for normal users in which cases you may have to consult your system administrator in order to change them.

Hope it helps!

To learn more about how useMango helps automate testing of Oracle EBS, visit: http://infuse.it/products/usemango-test-automation/