X

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

Evolutionary Steps for Automated Testing for E-Business Suite

Steven Chan
Senior Director

My, how time flies.  It's been over two years since I last covered automated regression testing for the E-Business Suite. Our strategy for this area continues to evolve, so it's high time for an update.

The E-Business Suite Test Starter Kits consist of sample test scripts from our own E-Business Suite QA group, along with a Starter Guide, Best Practices Guide, and Installation instructions.  The test scripts were created against an EBS Vision Demo database displaying American English.  You can use these kits as a model for building out your own automated regression tests for your Apps environment.

 

screenshot_patch8408886.png
Back in 2006, you could download our Quality Assurance teams' automated WinRunner QA scripts for Oracle E-Business Suite Release 11i via a Test Starter Kit.  A few things have changed since then:

 

Test Starter Kits for WinRunner are Still Available

If you're still using WinRunner, you'll be pleased to learn that you can still download:

  • WinRunner Test Starter Kit for Release 12.0.4 - Patch 6799654
  • WinRunner Test Starter Kit for Release 12.0 - Patch 5845794
  • WinRunner Test Starter Kit for Release 11.5.10.2 - Patch 4520701
  • WinRunner Test Starter Kit for Release 11.5.10 - Patch 4064542
  • WinRunner Test Starter Kit for Release 11.5.9 - Patch 2983563
  • WinRunner Test Starter Kit for Release 11.5.8 - Patch 2739616
  • WinRunner Test Starter Kit for Release 11.5.7 - Patch 2471695

New Test Starter Kits for QTP are Available

If you've switched over to HP's QuickTest Professional (QTP) testing set of tools, you can now download the following new Test Starter Kits:

  • QTP Test Starter Kit for Release 12.1.1 - Patch 8408886
  • QTP Test Starter Kit for Release 12.0.4 - Patch 6845309
  • QTP Test Starter Kit for Release 12.0 - Patch 5845799
  • QTP Test Starter Kit for Release 11.5.10.2 - Patch 4611398
  • QTP Test Starter Kit for Release 11.5.10 - Patch 4355248
  • QTP Test Starter Kit for Release 11.5.9 - Patch 3313315

Only a subset of the E-Business Suite products with automated WinRunner scripts have QTP equivalents; the READMEs for the respective kits have more details about their contents.

The master list of Test Starter Kits available for Apps is published in:

Related Articles

Join the discussion

Comments ( 31 )
  • Kai Monday, August 17, 2009

    hi Steven,

    is it a free software or need license for testing?

    Best regards,

    Kai


  • Steven Chan Tuesday, August 18, 2009

    Hi, Kai,

    The EBS Test Starter Kits are free to all registered Metalink users. The QTP and WinRunner products must be licenced from Hewlett-Packard.

    Regards,

    Steven


  • Sean Friday, October 2, 2009

    Any chance of a starter kit for selenium?


  • Steven Chan Friday, October 2, 2009

    Hi, Sean,

    I don't think there are any plans for Selenium within the E-Business Suite division right now. Our next major effort will be focussed on upgrading our existing testscripts for the Oracle Applications Testing Suite (OATS). See:

    Using the Oracle Applications Testing Suite with EBS: Interim Update #1

    http://blogs.oracle.com/stevenChan/2009/08/oats_ebs_interim_update1.html

    Regards,

    Steven


  • Andre Mendes Thursday, October 22, 2009

    Hello there, Steven.

    My company started automating test cases a few months ago, but seeing that Oracle EBS Suite QA Team already has automated scripts, currently available on the same tool we use here (QTP), I was wondering if there was some kind of partnership that could be arrange in order for us start using YOUR automated scripts for the CORE functionalities. Then, we would be able to focus the regression validations on our Customizations only.

    Would such partnership, or service contract or something like that be possible?

    Thanks in advance.


  • Steven Chan Thursday, October 22, 2009

    Hello, Andres,

    I can't comment on parnership arrangements or contractual arrangements, I'm afraid. I'm in E-Business Suite Development and have no visibility into partner-related activities.

    If you'd like to pursue that, your best bet would be to follow up with someone in the Oracle PartnerNetwork organization. Their website is here:

    http://www.oracle.com/partners/index.html

    As for the use of our automated test scripts: if your customers have current Support licences for the E-Business Suite, they can download the E-Business Suite Test Starter Kits for their own use from Metalink at no additional charge.

    Regards,

    Steven


  • Maija Monday, February 8, 2010

    Hi Steven,

    Is it planned to provide Test Starter Kit for Quality Center version 10.0?

    Regards,

    Maija


  • Steven Chan Monday, February 8, 2010

    Hi, Maija,

    I believe that our teams' efforts may be now focussed on Oracle Application Testing Suite; see:

    Oracle Application Testing Suite 9.0 Supported with Oracle E-Business Suite

    http://blogs.oracle.com/stevenChan/2009/10/oats_ebs_certified.html

    I'm not aware of any additional plans to update existing test scripts for new versions of Quality Center.

    Regards,

    Steven


  • Maija Monday, February 8, 2010

    Thanks, Steven.

    Is there any expected delivery date for the 1st version of Test Starter Kit for Oracle Application Testing Suite?

    Regards,

    Maija


  • Steven Chan Monday, February 8, 2010

    Hi, Maija,

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.

    Regards,

    Steven


  • Sujay Tuesday, August 3, 2010

    Hi Steven,

    I have a question. Can i use QTP ( Quick Test Professional) Automated Testing tool to test eBS R12 Test scripts. I would be using automated Test scripts executing the same in QTP testing tool.

    Would appreciate a quick response.

    Thanks

    Sujay


  • Steven Chan Tuesday, August 3, 2010

    Hi, Sujay,

    Did you see the QTP section in the article above?

    Regards,

    Steven


  • gaurav Thursday, November 4, 2010

    Guys,

    Does anyone know what is the "oracle_qtp_lib.lib" file for under folder "qtp_init_scripts".

    Thank You!


  • rebecca Thursday, June 2, 2011
    (no comment just want to subscribe)
  • Rashmi Monday, November 14, 2011

    Hi,

    Can anyone let me know if the standard start up kits have any coverage on Oracle Configurator Developer cases?

    Thanks!

    Rashmi


  • Steven Chan Monday, November 14, 2011

    Hi, Rashmi,

    I don't think any of our bloggers know much about the contents of the latest Test Starter Kits. That includes me.

    I suspect not, but you can download the Test Starter Kit to check that firsthand.

    Regards,

    Steven


  • guest Friday, December 30, 2011

    Hi Steven,

    Thanks for the great info.

    I am trying to access the Test Starter Kit Information Center (Note 239746.1) and came to the My Oracle Support page. Just wondering, is CSI a (must) required info to access this information? Is there any other method that I can access this info?

    Regards,

    Jimmy


  • Steven Chan Friday, December 30, 2011

    Hi, Jimmy,

    Everything on My Oracle Support is available only to customers with a valid CSI (meaning, you have a support contract). I'm afraid that there are no other ways of accessing the Test Starter Kit.

    Regards,

    Steven


  • Jimmy Sunday, January 1, 2012

    Hi Steven,

    Noted. Thanks for the prompt response.

    Regards,

    Jimmy


  • Vijay Saturday, February 25, 2012

    Hi - Current we are planning to automate customized functionalities in Finance, CRM & OLM modules of Oracle EBS application using Quick Test Professional 10.0.

    We are keen to know whether E-Business Suite Test Starter Kits covers all the standard functionalities & pre build automated test scripts are available for performing an instance automation testing for non-custom [out of the box] functionalities. If so, please list out the standard functional area for Finance, CRM & OLM modules which is currently automated test scripts are available.

    Thanks for your support !


  • Steven Chan Monday, February 27, 2012

    Hi, Vijay,

    Our ongoing investments will be in expanding our automated tests for Oracle Application Testing Suite.

    Only a small subset of EBS functionality is covered by our QTP-based Test Starter Kits. I'd recommend that you download that Kit to see which ones will suit your testing requirements.

    Best of luck with your automation efforts.

    Regards,

    Steven


  • Jimmy Monday, March 26, 2012

    Hi Steven,

    We have a bunch of QTP scripts built for R11i, currently we are analysing the impact to migrate these scripts to R12. I understand that R11i is on Oracle form based UI and R12 will have more web-based UI. Since QTP is scripted using different protocol, we are afraid that we may need to rescript the whole thing.

    I can see that you guys have implemented QTP Starter Kit for R11 and R12, when you guys implemented these, is this a total rework or there is a different approach.

    Do appreciate if you can share some experience on this. Thanks a lot.

    Regards,

    Jimmy


  • Steven Chan Tuesday, March 27, 2012

    Hi, Jimmy,

    You're right: depending upon which E-Business Suite product's you've scripted in 11i, the amount of work required to redo those scripts for R12 in QTP may be substantial.

    This was part of our reasoning for switching to Oracle Application Testing Suite from QTP. We began this work for QTP and released what we had in that Test Starter Kit. But the remaining work was subsequently invested in Oracle Application Testing Suite, since we don't have the capacity to maintain two parallel sets of scripts for two different automated testing tools.

    Regards,

    Steven


  • Sathish Sunday, January 20, 2013

    Dear Steven

    1) One of our Customer is looking at using any Open Source tools for Automation Testing. We tried with Selenium but it is not supporting Forms. Do you have any guidance on any open Source tool that will support EBS Automation testing ?

    2) How can I convince the customer on cost advantage of using OATS


  • Steven Chan Tuesday, January 22, 2013

    Hello, Satish,

    I'm afraid that I don't have much visibility into open source testing tools.

    I'd recommend contacting your Oracle account manager. He or she would be happy to help build a business case for using OATS in your customer's environment.

    Regards,

    Steven


  • Walter McAdams Wednesday, February 27, 2013

    Steven, a client of ours is asking about the release of additional; templates/accelerators for Oracle Application Testing Suite/OpenScript - in particular support for the recently purchased Argus family of applications. Does such a release schedule exist?


  • Steven Chan Wednesday, February 27, 2013

    Walter,

    I'm part of the E-Business Suite division. I'm not familiar with the OATS plans for supporting Argus. You might wish to contact your Oracle account manager to get some help with this one.

    Regards,

    Steven


  • guest Saturday, March 16, 2013

    Hi Steven,

    I am not sure if there is a QTP starter kit for R12.1.3 or the patch/kit for R12.1.1 will be applicable? At what oracle ebiz release that oracle stop developing QTP test starter kit?

    I would like get your advise and oracle experience in test data preparation, as this is teething exercise for us with many data that can only be used once. Does Oracle has any scripts or tool that queries data from the DB.

    Thanks Steven for your kind advice.

    Alic


  • Steven Chan Monday, March 18, 2013

    Hi, Alic,

    I don't monitor that area very closely, but my impression is that the last Test Starter Kit released for QTP was for EBS 12.1.1. After that point, Oracle's strategic direction shifted to focus on the Oracle Application Testing Suite tool.

    The Oracle Application Testing Suite tool has a SQL Performance Analyzer and Database Replay tool can be used to test database-specific transactions. That tool offers some interesting capabilities and testing options; I'd recommend checking it out.

    Regards,

    Steven


  • Jolly Friday, November 7, 2014

    Can Selenium be used for doing performance testing of Oracle eBS?


  • Steven Chan Monday, November 10, 2014

    Hello, Jolly,

    Possibly, but we only provide EBS Test Starter Kits for OATS for our latest EBS releases.

    If you wanted to use Selenium, you'd need to build your own test scripts.

    Regards,

    Steven


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.