An Introduction to JDE Script Builder

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:

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

6. Expand Batch/Reports under Functions
7. 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.

8. Save the changes by selecting the Save button.
9. 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:

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!