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:
- Register a script builder to create new user
- Login to JDE Script Builder
- Select the product details (Product Selection, Release, Script Builder)
- Provide the name for the Script Builder
- Click on ScriptBuilder
- Expand Batch/Reports under Functions
- 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.
- Save the changes by selecting the Save button.
- 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 System||Windows Server 2012, Windows 7|
|Application Server||Oracle WebLogic Server 10.3.6 for Windows x86|
|Database Software||Oracle Database Express Edition 11g Release 2 for Windows x64|
|Testing Automation Tool Suite||Oracle Application Testing Suite 220.127.116.11 for Microsoft Windows|
|Browsers||Internet Explorer 11, Chrome 47|
|JD Edwards EnterpriseOne Release – Apps||9.0 Update 2|
9.1 Update 2
|JD Edwards EnterpriseOne Release – Tools||Tools 9.1.5.x|
|Additional Components||Microsoft 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!