The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

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

Guest Author
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. 

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


Related Articles


Join the discussion

Comments ( 28 )
  • Jim Monday, December 16, 2013


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


  • guest Tuesday, December 17, 2013

    Hi, Jim,

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



  • guest Tuesday, December 24, 2013


    Is this separately licensed?


  • Mazen Wednesday, December 25, 2013


    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.


  • Anne Carlson Wednesday, December 25, 2013

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

  • Guest Wednesday, March 19, 2014

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

  • Steven Chan Wednesday, March 19, 2014

    Hello, Guest,

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



  • guest Friday, April 11, 2014

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

  • Steven Chan Wednesday, April 16, 2014

    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.



  • guest Monday, May 12, 2014


    1.can we able to connect to EBS database using oracle flow builder

    2.can we able to generate capture screenshot code using OFB


  • Mazen Arar Tuesday, May 13, 2014

    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.



  • guest Saturday, June 7, 2014

    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...


    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)

  • Steven Chan Saturday, June 7, 2014

    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.



  • Svetoslav Friday, June 20, 2014


    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!

  • guest Tuesday, June 24, 2014

    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.

  • guest Wednesday, June 25, 2014

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


  • guest Saturday, August 2, 2014

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


  • guest Wednesday, August 20, 2014


    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?

  • Mazen Arar Wednesday, August 20, 2014


    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.

  • guest Tuesday, March 31, 2015

    Hello, OATS Flowbuilder can run on the OL6.x?

    I've seen a comment on August 01, 2014 stating that is wasn't tested against RHEL6.x. It is still the case now?

  • Mazen Arar Sunday, April 5, 2015

    Hello, yes this is still the case as of today. Thanks

  • guest Thursday, March 24, 2016


    Do we have the feature of sending emails with attachment of result file(HTML) through OATS after the ran of test case?

    Thanks in advance

  • Mazen Arar Tuesday, April 5, 2016


    The Oracle Test Management tool (OTM) can be setup to send the result report via e-mail after test execution.

  • Mark Frederickson Monday, February 13, 2017

    Are there licensing costs associated with OATS if you are using the tool to test EBS or other Oracle applications ????

  • Mazen Arar Sunday, February 19, 2017

    Hi, yes, a license is required for the OATS products regardless what application you are testing. Thanks

  • Apurba Saturday, August 17, 2019
    Is the FLow builder server can be installed in RHEL 7.5?
  • Gopal Monday, August 19, 2019
    OFB can be installed on 64 bit Oracle Linux 5, 6, 7. Refer - https://www.oracle.com/enterprise-manager/downloads/oats-downloads.html

    OFB is not certified with RHEL. We have not tried it out.
  • Apurba Tuesday, February 4, 2020
    What is the roadmap for OATS tool, is this going to be decommissioned ? if so what tool oracle is using for their regression for EBS , since my understanding till today - R12.2.9 Oracle is using OTAS tool for regression test.
    is OATS tool will continue to be enhanced for further ebs application versions s well?
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.