An Introduction to JDE Script Builder

JDE Script Builder makes automated software testing a breeze with its simple interface and database of JDE functions. In this blog post, I explain how to build your own test script with this convenient tool.

Automated software testing is a process in which software tools execute scripted tests on a software application. The objective of automated testing is to simplify as much of the testing process as possible with a minimum set of scripts. Initially, automated test tools were designed to record and playback; now, they’re able to support data driven and framework-based test automation tools.  One of the lastest innovations in Oracle JD Edwards (JDE) automated testing is JDE Script Builder – a new tool to help generate test scripts for Oracle Application Testing Suite.

Since 2013, the OATS (Oracle Application Testing Suite) for JDE module has been a popular tool in the market for creating JDE test scripts. However, test scripts can be complex and require some development and programming knowledge. Recently, the Oracle JD Edwards Quality Assurance team had been using JDE Script Builder internally to create script-less testing for OATS, and they have now released it in controlled availability for select partners to try the tool in actual JDE testing scenarios, such as major upgrade and implementations.

What is JDE Script Builder?

JDE Script Builder is an automation framework that simplifies the creation of automation test scripts for JD Edwards on the Oracle Application Testing Suite platform. Its interactive interface grants users the ability to drag and drop in available JDE functions. Users and business analysts can create most of the automated test scripts needed to test JD Edwards EnterpriseOne (E1) functionality and business processes without needing to code any scripts.

How to work with JDE Script Builder to create an OATS test script

The high-level steps listed here create a test script to submit and execute a Universal Batch Engine (UBE) version with data selection in OATS OpenScript (version 12.5.) Make sure that JDE Script Builder and Open Script Builder are installed and configured properly before developing a script.

How to create a test script in JDE Script Builder:

Introduction to JDE Script Builder
  1. Register a script builder to create new user
  2. Login to JDE Script Builder
  3. Select the product details (Product Selection, Release, Script Builder)
  4. Provide the name for the Script Builder
  5. Click on ScriptBuilder
Introduction to JDE Script Builder
  1. Expand Batch/Reports under Functions
  2. Select the Submit UBE function and provide the report name along with the version name. The Submit UBE function will run the provided version of the UBE with default data selection.
Introduction to JDE Script Builder
  1. Save the changes by selecting the Save button.
  2. Execute the script from OATS OpenScript. Users need basic knowledge on OpenScript to execute the script.

My thoughts on JDE Script Builder

I strongly believe that it is a convenient tool for functional users, business analysts and super users. The JDE Script Builder significantly reduces the time needed to create test scripts due to its many pre-built JDE functions. Script Builder also generates test cases documents for the scripts it creates. You can easily design your XML test to validate UBE report output. If you plan to automate your testing in JD Edwards, this is a must have tool.

Key Requirements for using JDE Script Builder

JDE Script Builder runs on Google Chrome and Internet Explorer browsers with these required components:

Operating SystemWindows Server 2012, Windows 7
Application ServerOracle WebLogic Server 10.3.6 for Windows x86
Database SoftwareOracle Database Express Edition 11g Release 2 for Windows x64
Testing Automation Tool SuiteOracle Application Testing Suite for Microsoft Windows
BrowsersInternet Explorer 11, Chrome 47
JD Edwards EnterpriseOne Release – Apps9.0 Update 2
9.1 Update 2
JD Edwards EnterpriseOne Release – ToolsTools 9.1.5.x
Tools 9.2.0.x
Additional ComponentsMicrosoft Office 2007 or above

Advantages of JDE Script Builder

  • create and maintain scripts easily

  • resuse the scripts across multiple Enterprise release and clients

  • scripts are not sensitive to minor changes in the software

  • build robust test scripts with minimum programming skills

Disadvantages of JDE Script Builder

  • It’s dependent on OATS. This may not be an issue if OATS is already in-place, but if not, you’ll need to purchase a software license and install it.

  • Not all JDE business scenarios or functions can be created with Script Builder. Some advanced OATS scripting may be required for more complex scenarios.

Are you interested in  JDE Script Builder to create your scripts or have any questions about how to start? Leave us a comment!

There’s more to explore at!

Sign up to be notified when we publish articles, news, videos and more!