Automate Testing Using Oracle Application Testing Suite with Flow Builder for E-Business Suite

Previous articles have discussed the benefits of automated testing with the Oracle Application Testing Suite, a.k.a, "OATS". As a reminder, OATS includes the following components:
  • Oracle Functional Testing Suite for Oracle Applications – for functional and regression testing
  • Oracle Load Testing Suite for Oracle Applications – for load and performance testing
  • Oracle Test Manager – for test process management, test execution and defect tracking

The latest release of Oracle Application Testing Suite, referred to as 12.3, includes a new "Flow Builder" capability designed to reduce the effort and expertise needed to create and maintain automated test scripts for EBS 12.1.3 and 12.2. This should be welcome news for EBS customers looking to streamline their upgrade projects.

What is Flow Builder?
Flow Builder is an automated test generation framework delivered as part of the Oracle Functional Testing Suite for Oracle Applications. It provides an alternative to the traditional "record/playback" method for creating test scripts, which is time-consuming and produces scripts that are difficult to maintain.

Using Flow Builder, even non-technical testers can generate working test scripts from pre-built components. Each component represents an atomic test operation such as “create an invoice batch” or “apply an invoice hold.” Testers can assemble the pre-built components into test flows, and combine test flows with spreadsheet data to drive the testing of multiple data conditions. To maintain Flow Builder-generated scripts, testers need only know the names of common application functions instead of a complex scripting language.

Screenshot of Oracle Flow Builder extension for Oracle Application Testing Suite

Includes a Starter Kit
The EBS QA team uses the Flow Builder feature to do EBS testing, and provides pre-built test content that customers can use to jump start their own testing projects. Flow Builder includes an EBS starter kit with over 2000 pre-built components and 200 pre-built flows. The Flow Builder framework allows customers to add, modify and extend the pre-built components and flows to address new functionality and customizations to EBS.

Improves Productivity
The EBS QA team has improved their productivity by 60% using Flow Builder’s component-based test generation framework instead of a traditional record/playback approach. With Flow Builder, EBS customers can significantly improve their productivity and test coverage while saving on testing expense. Flow Builder content updates will be available for each new EBS major release, allowing customers to reduce maintenance overhead for test scripts. 

Downloads
You can download the Oracle Application Testing Suite from the Oracle Software Delivery Cloud or the Oracle Technology Network.

References

Related Articles


Comments:

Hi,

Which product pach should I select on edelivery if I want to download the OATS?

Thanks,

Posted by Jim on December 16, 2013 at 12:11 AM PST #

Hi, Jim,

The Oracle Technology Network link in the article above has direct links to the OATS downloads.

Regards,
Steven

Posted by guest on December 17, 2013 at 08:53 AM PST #

Steven,

Is this separately licensed?

Thanks.

Posted by guest on December 24, 2013 at 09:56 AM PST #

Hi,

A license is required for the OATS products. However, Oracle Flow Builder is licensed as a part of Oracle Functional Testing Suite for Oracle Applications.

-Mazen

Posted by Mazen on December 25, 2013 at 06:37 AM PST #

Flow Builder is delivered as part of Oracle Functional Testing Suite for Oracle Applications, which is a separately-licensed product.

Posted by Anne Carlson on December 25, 2013 at 08:22 AM PST #

Can flow builder be used to automate tests for EBS release 11i?

Posted by Guest on March 18, 2014 at 08:33 PM PDT #

Hello, Guest,

As noted in the article above, Flowbuilder is designed for EBS 12.1 and 12.2.

Regards,
Steven

Posted by Steven Chan on March 19, 2014 at 07:46 AM PDT #

How can I concatenate variable with '%' sign in Flowbuilder, kindly replay asap.

Posted by guest on April 11, 2014 at 07:45 AM PDT #

Hi, Guest,

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on April 16, 2014 at 10:45 AM PDT #

Hi,

1.can we able to connect to EBS database using oracle flow builder
2.can we able to generate capture screenshot code using OFB

Thanks

Posted by guest on May 12, 2014 at 04:56 AM PDT #

Hello Guest,

For your first question, We cannot connect to EBS database using Oracle Flow Builder but OpenScript provides an option to connect to database by attaching an asset to the script.

For your second question, Screenshots cannot be captured while generating the scripts using OFB but can be captured while executing the scripts.

Thanks,
-Mazen

Posted by Mazen Arar on May 13, 2014 at 07:41 AM PDT #

When trying to install Oracle Flow Builder as instructed in Installation Guide I got the following error:

"find: warning: the predicate -ipath is deprecated; please use -iwholename instead"

Any ideas to solve this issue.

I executed the following command:

/tmp/OFB_MAIN/setup.sh install

<part of the log file>

..
Verifying data......
Copying Files...
-----------20%----------40%----------60%----------80%--------100%

The installation of Oracle Application Developer 11g completed successfully.
Configuring WLS Paths
find: warning: the predicate -ipath is deprecated; please use -iwholename instead.
MW Home: /scratch/oracle/oracle/OracleOFB/wls
WLS Native Libraries:

Begin populating databases
/scratch/oracle/oracle/OracleOFB/lib /tmp (this is the last line)

Posted by guest on June 07, 2014 at 08:04 AM PDT #

Hello, Guest,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on June 07, 2014 at 11:53 AM PDT #

Hello,

I would like to know the following few things:

1. Knowing that Flow Builder supports over 2000 pre-built components and 200 pre-built flows for EBS 12%, I would like to know which EBS modules exactly are supported by the pre-built flows (those are aimed towards certain modules, as seen by the training videos as well).

2. As a person can create custom flows in the Flow Builder, can those new flows be prepared/executed over modules, which are not yet supported in the pre-built flow set?

3. From the link here (http://www.oracle.com/technetwork/oem/downloads/index-084446.html) it doesn't get quite clear which product is licensed separately and what other products their packages are including. Please clarify.

4. In the Oracle Flow Builder Prerequisites, you mention "Oracle Linux 5 (64 bit)". I just want to confirm with you that Red Hat 5 will also do and this installation does not explicitly require the Oracle build.

5. How can the Oracle Flow Builder or Oracle Testing Suite be used, in order to test new patches (about EBS), coming from Oracle Support? Are test scripts provided in advance and how come a person can estimate the whole impact that those patches could have, in order to prepare some test scenarios for those installations?

Thank you very much!

Posted by Svetoslav on June 20, 2014 at 12:25 AM PDT #

Hello Svetoslav,

1 - If the flows should be listed in the "Oracle Flow Builder Starter Pack Reference Guide for E-Business Suite Release 12.2" under this link: (http://www.oracle.com/technetwork/oem/downloads/index-084446.html)

2 - Yes, you can create as many new / custom flows across EBS modules.

3 - "Oracle Functional Testing Suite for Oracle Applications" includes both Oracle Flow Builder & Open Script, you just need to license OFT.

4 - That is correct

5 - Oracle Flow Builder or Oracle Functional Testing Suite is ideal for regression testing. Customers should look at the functional impact assessment document for this and identify the sanity/certification flows for their implementation. Execute these flows and check if they are working fine after applying the new patches. One-off patches may not ideally need changes to the components, but while uptaking the RUPs they should check if any components should be modified before executing the flows.

Posted by guest on June 24, 2014 at 10:02 AM PDT #

Hello, would also the OATS Flowbuilder run on the RHEL6.x?
thanks

Posted by guest on June 25, 2014 at 04:22 AM PDT #

Flow Builder has only been tested on Oracle Linux 5 (64 bit), no tests have been done on RHEL6.x yet.

Thanks

Posted by guest on August 01, 2014 at 06:33 PM PDT #

Hi,
1) Pls. confirm if Oracle Flow Builder / Open Script is tightly integrated with Oracle Test Manager or there are separate steps to integrate both applications.
2) Can the test runs dones in Open Script be recorded and reported from Test Manager?

Posted by guest on August 20, 2014 at 08:48 AM PDT #

Hello,
1) Yes, the Automated scripts can be created in Flow Builder, taken exported into Open Script for execution and for sure run and scheduled through Test Manager just like any other Open Script created script.
2) You can record scripts in Open Script and run / execute / schedule though Test Manager too.
Please let me know if you need more clarification.

Posted by Mazen Arar on August 20, 2014 at 09:34 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« February 2015
SunMonTueWedThuFriSat
1
2
3
4
7
8
9
11
14
15
17
18
19
21
22
23
25
26
27
28
       
       
Today