Oracle Utilities Testing Accelerator

Oracle Utilities Testing AcceleratorUser’s Guide for CloudRelease 20AF29959-01March 2020(Updated June 2020)

Oracle Utilities Testing Accelerator User’s Guide for Cloud, Release 20AF29959-01Copyright 2019, 2020 Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agencyspecific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of theprograms, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. Noother rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this softwareor hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.

ContentsPreface. i-iAudience . i-iiPrerequisite Knowledge. i-iiAbbreviations . i-iiRelated Documents . i-iiConventions. i-iiChapter 1Overview . 1-1Introduction. 1-2Terminology . 1-2Application Architecture . 1-3Application Features . 1-3Supported Oracle Utilities Applications. 1-4Chapter 2Oracle Utilities Testing Accelerator Features . 2-1Administration . 2-2Components . 2-2Dashboard . 2-2Notifications. 2-2Flows. 2-3Flow Sets. 2-3Tools . 2-3Chapter 3Developing Metadata Driven Web Service Based Test Automation . 3-1Metadata Driven Automation Development Methodology. 3-2Planning . 3-3Design and Development . 3-3Test Execution. 3-3Setting Up Automation Development Environment . 3-3Setting Up the Oracle Utilities Testing Accelerator Client Runtime. 3-4Setting Up Workstations for Development/ Testing. 3-4Setting Up Application under Test. 3-7Chapter 4Oracle Utilities Testing Accelerator Administration. 4-1Overview . 4-2Administration Tab . 4-2Managing Releases . 4-2Managing Portfolios. 4-3Managing Products . 4-4Contents - iOracle Utilities Testing Accelerator User’s Guide for Cloud

Managing Modules . 4-4Purging Flow Execution Data. 4-5Chapter 5Creating Components . 5-1Component Structure. 5-2Component Lifecycle . 5-2Locking/Unlocking Components. 5-3Component Types . 5-4Web Service Based Components. 5-4GUI Based Components. 5-4REST Web Service Components. 5-4Creating Web Service Based Components . 5-4Creating a Component . 5-5Creating a Component Definition. 5-6Defining Default Data at Component Level . 5-7Setting Up Operation Name for a Web Service. 5-8Using Runtime Variables in Components . 5-8file: prefix - csv file. 5-8Using Function Libraries. 5-8Resolving the Repeating Elements in Response XML. 5-8Adding Validations. 5-9Logging and Reporting. 5-10Handling the List Elements . 5-10Creating GUI Based Components. 5-14Creating a Component Definition for GUI Components. 5-14Creating REST Web Service Components . 5-16Creating a REST Service Component Definition . 5-16Entering Test Data for a REST Component. 5-17Copying Components . 5-19Chapter 6Creating Test Flows. 6-1Creating Flows . 6-2Creating Flows By Dragging-and-Dropping Components. 6-2Creating Scenarios . 6-2Creating Flow Modules. 6-3Using Global Variables. 6-3Flow Lifecycle. 6-3Locking/Unlocking Flows. 6-4Copying Flows . 6-5Reordering Components in a Flow . 6-5Copying Test Data from One Component to Another in a Flow . 6-5Fetching Component Test Data from an Utilities Application . 6-6Flow Subroutines . 6-7Component Test Data Sets. 6-8Creating Reference Test Data for a Component . 6-8Loading Test Data from a Component Test Data Set . 6-8Loading Test Data from a .csv File . 6-9Test Data Management . 6-9Flow Test Data Sets. 6-11Adding the Email Capabilities to Flows. 6-12Support for Integration Flows. 6-12Executing Test Flows. 6-14Executing Test Flows Using a Browser. 6-14Iterative Flow Execution. 6-14Viewing Flow Execution Details . 6-15Viewing Flow Execution Summary Report . 6-15Contents - iiOracle Utilities Testing Accelerator User’s Guide for Cloud

Generating Oracle Utilities Testing Accelerator Scripts . 6-15Importing the Generated Oracle Utilities Testing Accelerator Script into Eclipse IDE. 6-16Executing Flows from Command Line. 6-17Encrypting Passwords. 6-17Generating Keystore for Encryption from Windows Explorer . 6-18Generating Keystore for Encryption from Command Prompt. 6-18Using Password Encryptor Tool From Windows Explorer. 6-18Using PasswordEncryptor Tool From Console/Command Line. 6-19Configuring the Runtime Properties (For Execution Using Eclipse) . 6-19Runtime Configuration for Flow Execution (For Execution Using Browser). 6-20Chapter 7Creating Test Flow Sets . 7-1Creating Flow Sets. 7-2Adding Flows to a Flow Set. 7-2Deleting Flows from a Flow Set. 7-2Executing Flow Sets. 7-2Aborting Flow Set Execution . 7-3Exporting Flow Sets. 7-3Viewing Flow Set Execution History . 7-3Viewing Flow Set Execution Summary Report . 7-3Chapter 8Development Accelerator Tools . 8-1Component Export Tool . 8-2Flow Export Tool. 8-2Component/ Flow Import Tool . 8-2Component Generation Tool . 8-3Chapter 9Function Library Reference. 9-1CLOUDLIB . 9-2OUTSPCORELIB . 9-2WSCOMMONLIB. 9-7WSVALIDATELIB . 9-7Chapter 10Custom Libraries . 10-1Creating/Updating Custom Libraries. 10-2Using Custom Library Functions. 10-3Appendix AWeb Service Component Keywords. A-1WS-SETWEBSERVICENAME. A-2WS-SETXMLELEMENT . A-2WS-SETXMLLISTELEMENT. A-2WS-SETVARIABLE . A-3WS-SETVARIABLEFROMRESPONSE. A-3WS-SETTRANSACTIONTYPE . A-3WS-LOGMESSAGE . A-3WS-CREATEWSREQUEST . A-4WS-PROCESSWSREQUEST . A-4WS-STARTPOLLWS . A-4WS-STOPPOLLWSIF. A-5Appendix BGUI Component Keywords . B-1APPROVE . B-2CANCEL . B-2Contents - iiiOracle Utilities Testing Accelerator User’s Guide for Cloud

CHECK.CLICK.CLOSE.GET ATTRIBUTE VALUE .GET ATTRIBUTE ID .LAUNCH .MAXIMIZE .MINIMIZE .POPUP.PRESSTABKEY .SELECT.SETTEXT .

Oracle Utilities Testing Accelerator comprises test automation accelerators for the automated testing of Oracle Utilities applications. It is a framework based on Java and Selenium for creating the web services and user interface automation scripts. Oracle Utilities Testing Accelerator enables you to create the automation scripts using keywords or