Automated Regression Testing Accelerates Quarterly Releases

The Client

Federal Agency

This Oracle Federal Financials implementation replaces and modernizes various accounting systems with a single, standardized system. The internal system will be upgraded to Oracle Financials 11i, eliminating redundant accounting systems. This project will allow the client to meet government financial regulations including the Joint Financial Management Improvement Program (JFMIP) and the Federal Financial Management Improvement Act of 1996 (FFMIA).

The Technology

Oracle Financials Version: 11i

  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Benefits

The Challenge

Frequent feature upgrades and releases necessitated many cycles of regression testing. To speed up the regression testing phase and increase testing productivity, the client required to automate the regression testing process completely. The main challenge was to evolve a robust test strategy/approach that would maximize the benefit from automation. In addition, the team needed to create maintainable scripts taking into account the interrelated functionality and the fact that the application was stable and data intensive.

The Solution

The test team used Test Automation Framework developed by the Squires professionals. The methodology adopted for generating WinRunner scripts was functional decomposition in combination with data driven approach (where test data is stored in a separate data pool and is not embedded in the test scripts). This script development methodology involved identification of repeated actions and functions and creation of user-defined Function Script libraries, Business Function Script libraries, which in-turn could be used by multiple scripts to simulate different test scenarios. The test data was maintained in separate data files and could be changed for each test run as applicable. Test execution was managed and controlled with Test Director.

The Success

The benefits of this automation included rapid development of test scripts, high maintainability, and the ability to accommodate frequent changes in the application without changing the framework code. This enabled the customer to reduce regression test cycle effort while achieving better test coverage.


Download this case study


Leave a Reply

Your email address will not be published.