TrustRadius: an HG Insights company

Oracle Application Testing Suite (legacy)

Score8 out of 10

174 Reviews and Ratings

What is Oracle Application Testing Suite (legacy)?

The Oracle Application Testing Suite is a legacy suite of tools. Oracle Application Testing Suite 13.1.0.1 shipped in 2017 was the last major release. Since then, two minor releases 13.2.0.1 and 13.3.0.1 were released with only smaller sets of new features.

It is a very useful software to improve the test results.

Pros

  • In the test suite, I loved creating a ServerStats monitor.
  • It allows to use the available metrics and the generic metrics, and the load test can be run without problems and compare my absolute values.
  • It has the ability to clone measurement profiles this feature saves a lot of time and money in the test environment. I used it for my Oracle and SQL databases, web servers and APIs.

Cons

  • Its interface is not as easy to use as it could be.
  • The price is a little high, it is made for large companies.
  • It requires a lot of knowledge and training to be able to use it well. This makes the learning curve very large.

Return on Investment

  • It had a positive impact, reduced work times and allowed much more precise tests.
  • It has allowed more extensive tests with performance-based tests, in addition to regression tests and periodic tests with each software version.
  • Automate test cases even before the implementation of an application. This can be done by scanning objects from UI models and screenshots.

Alternatives Considered

ZAPTEST

Other Software Used

MongoDB, dbForge Data Generator for MySQL, Azure SQL Database

Oracle Testing Suite - How sweet it is!

Pros

  • Load testing. We are able to simulate the load that production environments have within the testing environment. Without this capability, we would not be able to predict how the software will behave in production as we can never have sufficient users to test in this manner.
  • Functional and Regression testing is made much easier also. OAT has the ability to automate the key strokes of users so that we can perform more in-depth testing which we would never have the time or money to perform.
  • We are able to obtain testing scripts via this tool that we can review and enhance future deployments.

Cons

  • It takes a great deal of time to capture the data that we require for the tool to work. We do this via OEM.
  • The product requires patching like any other piece of Oracle software and so we have some maintenance overhead.

Return on Investment

  • ROI is positive in that we save hours of time measured in contractor time and functional user time to test.
  • We can obtain scripts that automate very complex business transactions that we can review and edits. This is invaluable as we have a great deal of turnover and require a quick means of obtaining a baseline.
  • Reduction on of manual testing. Because of the automated features, we do not have to test for months prior to deployment. Easily has cut our testing time in half.

Other Software Used

Oracle GoldenGate

Recommended tool for Oracle Upgrades and Performance Monitoring

Pros

  • Load testing with useful graphical interface tools to watch real time performance
  • Flexible configuration for monitoring utilities
  • Historical tracking for baseline performance before and after upgrades

Cons

  • Security rights can be complicated if multiple types of users are required at enterprise level
  • Depending on the size and upgrade requirements, additional custom scripting may be needed
  • For daily monitoring a custom database may need to be built for reporting needs

Return on Investment

  • Reduced testing time needed to validate Oracle upgrades
  • Provided easily accessible web portal tools for database monitoring
  • Allowed DBA's to continue monitoring performance needs on a daily basis

Other Software Used

Oracle Database Exadata Cloud Service, Oracle Analytics Cloud, Acoustic Analytics (formerly IBM Watson Customer Experience Analytics)

Complete package for testing web applications

Pros

  • Testing as a service, load testing, and Oracle apps testing
  • Test process management, including test requirements management, test management, test execution and defect tracking.

Cons

  • Cost of the tool is higher than some others on the market
  • Better out of the box options for parallel regression testing sets
  • Tooling and lack of integrated suite to have everything in one place.

Return on Investment

  • Not a good option whenever it comes to parallel regression testing.
  • Suitable for database upgrade testing as well as major upgrades of the E-business suite applications.
  • Selenium Forums do not provide many solutions for the issues.
  • Sometimes Maven throws issues where there is no compilation error though pom.xml throws some error.

Other Software Used

Microsoft Visual Studio Team System, JIRA Software, Microsoft SQL Server

Oracle Application Testing Suites has had a positive impact on our Delivery cycle

Pros

  • Provides out of the box testing flows for E-Business Suite.
  • Allows our non-technical QA team member to build tests.
  • Performs automated regression testing of critical functionalities within the application.
  • Can accommodate customizations or extensions by altering the base flows.

Cons

  • Cost of tool is higher than some others on the market.
  • Better out of the box options for parallel regression testing sets.

Return on Investment

  • Reduced development time and cost
  • Reduced defects and time spent to correct
  • Reduced cost of user group UAT

Other Software Used

Oracle E-Business Suite Procurement Contracts, Oracle Enterprise Manager Cloud Control, Oracle Database 12c