Openscript – OFT – Oracle Functional Test

Oracle functional testing (a.k.a OFT) is a part of Oracle Application Testing suite, it supports functional automation testing of the following applications.

  • ORACLE EBS OAF Applications
  • ORACLE EBS Forms Applications
  • ORACLE ADF Applications
  • ORACLE Seibel Applications
  • ORACLE JD Edwards Enterprise one applications
  • PeopleSoft applications
  • ORACLE Fusion applications
  • Custom Web Applications
  • Cloud Applications
  • Adobe Flex applications

OFT of Oracle Application Testing Suite uses openscript IDE to create functional test automation scripts, OpenScript can also be used to create Oracle Load Testing Scripts.

Openscript was earlier known to be emprix, later to oracle’s acquisition its named after Openscript. Openscript is currently catching up the market stand with huge number of enhancements and bug fixes in the past 3 to 4 years, here at testingtools.co you can learn OFT by following the below topics and sub topics:

Learn OpenScript / Oracle Functional Test / OFT / Oracle Application Testing Suite with Tutorial Index

Basics of OpenScript in Oracle Functional Test of Oracle Application Testing Suite

In this section you will get Introduced to OpenScript, how it has come in to existence and what are its capabilities in the areas of Functional automation testing.

Topic Sub Topic
Introduction to OATS
What is all about OpenScript?
OATS Compatibility matrix for Operating System, JRE & Browsers
Types of functional testing supported by OATS
Evolution of OATS across releases
Advantages of OpenScript
Installation of OATS
Oracle Application Testing Suite Download Links
Steps to Install OATS – Oracle Application Testing Suite
Steps to validate successful installation of OATS
Clean uninstall steps of Oracle Application Testing Suite – OATS
Introduction to OpenScript UI
Menus in OpenScript IDE
Tree View and Code View in OpenScript
Perspectives in OpenScript
Brief about “OpenScript Preferences”
Script Properties
Brief about Script Assets
Other views in OpenScript

Script development and Stabilisation in Oracle Functional Test of Oracle Application Testing Suite

In this section you can get started with creating functional automated scripts and get to know about various UI objects that you can automate in different applications under test. You will also get to know about various activities involved as part of script development like Object XPath, working with Object Libraries, test data parametrization to execute scripts for multiple sets of test data, adding verification points to validate tests and script stabilization concepts.

Topic Sub Topic
Basics
Record and Playback of OpenScript Functional scripts
Understanding XPath in OpenScript of Oracle Application Testing Suite
Steps to spy UI objects in OpenScript?
Managing scripts in OpenScript
Export and Import of Scripts
Object Library
What is Object Library?
Steps to create Object Library in OATS
Working with Object Library in a test script.
Working with multiple Object Libraries in OATS
Steps to merge Multiple Object Libraries in OATS
UI Objects List supported by OATS
List of Web Application’s Objects OATS can automate.
List of Oracle EBS Application’s Objects OATS can automate.
List of PeopleSoft Application’s Objects OATS can automate.
List of Oracle JD Edwards Enterprise One Application’s Objects OATS can automate.
List of Oracle ADF or Fusion Application’s Objects OATS can automate.
List of Oracle Siebel Application’s Objects OATS can automate.
List of Adobe Flex Objects OATS can automate.
Test Data Parametrization
How to add Databanks in OATS?
Parametrization in Tree View of OATS
Parametrize scripts with scripting in OATS
Verification Points
Add Verification points using OpenScript tool.
Add Verification points programatically in OATS.
Script Stabilisation
Adding synchronisation steps
Replace with stable code where ever direct recorded code may not be useful.
Re-Usability of code
Steps to create Function Library in OATS
Steps to create Java classes in OpenScript scripts
Working with Jars in OATS
Exception Handling
UI based exception handling
Working with Excel
Parametrize scripts programmatically in OATS with Excel as test data.

Advanced topics in Oracle Functional Test of Oracle Application Testing Suite

In this section you will learn some advanced concepts of debugging scripts, how to work with inbuilt OpenScript APIs, utilities and exception handling. These are needed especially when you want to work with complex business logic or to address any custom requirements in the project like connecting to database for getting test data, verifying if a specific XML output is having the right data, etc

Topic Sub Topic
Script Debugging
All about Debug View in OpenScript IDE and its importance
How to debug scripts line by line in OATS?
How to playback scripts from middle of scripts?
OpenScript utilities
Working with Files
Working with CSV Files
Working with Database
Working with XML Files
Exception Handling
Dynamically handle exception handling in OATS
DOM Concept
All about DOM
How to use Javascript in OATS?
Command Line Utilities in OATS
Steps to execute OATS Scripts from command Line
Steps to set preferences when executing OATS Scripts from command Line
Watch video of your script playback ( New in OATS 12.5 )
Script Maintenance
Migration of scripts from Older version to Newer version of OATS
Best Practices for OATS

Troubleshooting in Oracle Functional Test of Oracle Application Testing Suite

In this section you will get to know various common issues you might face when using OpenScript and resolutions for the same, this can save a lot of time rather analyzing them scratch. You can rather spend more time for any new issues which can be specific only to your requirement.

Topic Sub Topic
Troubleshooting for OATS Installation
WebDOM Browser Helper Installation Failed
Troubleshooting for Recording scripts
Internet Explorer Crashing when Recording with Openscript
Troubleshooting for Playback of scripts
Cannot get a connection from the browser helper after 30 seconds

Code snippets in Oracle Functional Test of Oracle Application Testing Suite

In this section you will get to know various code snippets which can be re used in sevearl of your projects, helps saving time and get started faster with test automation and executions.

S.No Code Snippets Description
1 Get all links in a web page The cases when there are links in a web page, which have same attributes and values to identify the object, and you do not want to rely on index attribute, you should be able to get the list of all links in a web page and click on desired link.

Please do let us know your queries or topics to write as suggestions in the comments and we shall do our best to address the same.

Comments (80)

  • We are facing object identification issue with Oracle Forms 11G version. None of the Forms objects are identified while recording or with object Spy.
    Question :1
    From Open script Help(as show below): We understood that Open scripts supports Oracle E-Business Suite Release 12 (Forms 10g) running on Sun JRE​. If that is the case, will open script supports Oracle forms 11G

    Oracle Fusion/ADF Functional Test Module ( From OATS Help Doc)

    The Oracle Fusion/ADF Functional Test Script Module. The New Project wizard (Select New from the File menu) includes an “Oracle Fusion/ADF” option in the Functional Test Group to use when creating Oracle Fusion/ADF functional testing projects in OpenScript. The Oracle Fusion/ADF Functional Test Script Module records functional scripts against ADF Faces applications (Oracle Application Development Framework 11g Release 1 (11.1.1)).

    Pls find the below details of our application where Open script 12.2.X to 12.4.X unable to identify any of the objects in the form.

    Forms version : 11.1.2.2.0
    Data base version : Oracle Database 11g Enterprise edition release 11.2.0.3.0

    Question :2

    IF ADF module supporting Oracle Application Development Framework 11g Release 1 (11.1.1)), Why not EBS module does not supports the same ?

    From Open script Help:

    Oracle Fusion/ADF Functional Test Module

    The Oracle Fusion/ADF Functional Test Script Module. The New Project wizard (Select New from the File menu) includes an “Oracle Fusion/ADF” option in the Functional Test Group to use when creating Oracle Fusion/ADF functional testing projects in OpenScript. The Oracle Fusion/ADF Functional Test Script Module records functional scripts against ADF Faces applications (Oracle Application Development Framework 11g Release 1 (11.1.1)).

    Reply
    • Hi murali,

      Thank you so much for posting your query.

      For your question 1: As the release note says it currently supports oracle forms 10g, it means open script product QA team have evaluated the testing of oracle forms 10g. It doesn’t mean that it does not support 11g forms.

      Could you please confirm if it is the normal oracle EBS form or is it a custom developed oracle form? Or is it an applet inside an oracle forms? And what is the ure version on which this application is getting launched.

      Regarding your question 2:

      The ADF pages loading is not dependent on the JRE version on the machine where automation testing is performed and basically oracle form 11g and ADF 11 are 2 different technologies so there need not be any dependency stating the automation tool need to support different technologies at similar version numbers.

      Will be waiting for your response.

      Reply
  • Hi,
    Is Open Script will support version comparability like
    1. Scripts developed in Lower version will work in Higher version of OATS ?
    2. Can we use same Library file for both OATS 12.3 and OATS 12.4 in parallel ?
    3. Can we use the same Object Library file for both OATS 12.3 and OATS 12.4 at the same time ?
    4. Scripts developed in OATS 12.4 will work/execute in OATS 12.3 or lower version of OATS ?

    Reply
    • Please find below my responses,

      Firstly, sorry for the delay:

      Answer for query 1:
      Yes, it can be used for execution purpose subjective to the cases, if there is any api which has been removed in higher version, other wise it can very well be used for executions. In case you want to edit the script developed in lower version of OATS in higher Version of OATS, we need to first migrate or upgrade the script to higher version of OATS and then continue with editing / customization / stabilization of the script.

      Answer for query 2:
      Yes, as long as the library is working fine in lower version it can be used in higher version and also lower version library and higher version library can be attached to a higher version script and can be used simultaneously.

      Answer for query 3:
      Yes, it is possible.

      Answer for query 4:
      I don’t think this is doable or accepted by OATS.

      Hope I had clarified your queries, please do revert to me in case you have any more queries or clarifications.

      Reply
  • HI Team,

    Im new to OATS. Im a QTP resource. i used framework to develop and execute the test cases and we have customized results , and data sheet for provide test data an
    and we have exeution sheet from where we can test in batch for regression testing. can we develop similar kind of framwerk for the OATS also ? can we pass data from excel data sheets ?? DO you have any framework we can use for testing ?

    Reply
    • Hi Arjun,

      thank you so much for approaching us, I am happy to see that you have started to learn OATS, one of the emerging and good test automation tool which has a vast future. And to your queries, yes it is very possible to pass data from excel sheets, there is something called datatables concept and if that not work out for you. It is always possible to take help of POI libraries and come up with our own libraries and use them based on need.

      Regarding any framework, I would like to discuss more as one cannot decide as which is the best framework to be used for any kind of a project, there would be several factors to be considered before finalizing on which framework to be used. you can send us an email @ testingtools.co@gmail.com for further discussions on framework.

      And regarding any other queries, you can always continue to ask in the comments, I would love to help you on the same.

      Reply
  • I want to get a date 120 days after today’s date in open script. How can I do it. Can I use @today function. If you can please give a work around for the same it will be appreciable.

    Reply
    • Below are the basic formats to get current date, you must be knowing though.

      info(eval(“{{@today(MM/dd/yyyy)}}”));

      We can re order the format if you want to like

      info(eval(“{{@today(dd/MM/yyyy)}}”));

      If you want an alternative:

      please use below function

      public String getDate(int days)
      {
      //Date date = new Date();
      Calendar cal = Calendar.getInstance();
      cal.add(Calendar.DATE, days);
      Date date = cal.getTime();

      String pattern = “dd/MM/yyyy”;
      SimpleDateFormat format = new SimpleDateFormat(pattern);

      return format.format(date);

      }

      I hope you must be aware how to include the required import statements in openScript IDE? if not you can press short cut keys as Ctrl+Shift+O

      Usage of function :

      info(getDate(120));

      //or

      String days120 = getDate(120);

      do let me know in case of any queries.

      Reply
  • Hi,

    I am trying to install OATS ( 12.3 / 12.4 / 12.5 ). I tried many versions to install, but the problem is that I am not able to find a single java version suitable for my EBS and OATS.

    My EBS is 12.1.3, my laptop has windows 10 OS and has all basic requirements.
    My EBS works with Java 6 update 7, 6 update 45.

    Pls guide me to make one java version work for both software.

    Thanks
    Ron

    Reply
    • Hi Ron,
      Thanks for reaching me out, there is no such combination which actually oracle supports as of now with respect to windows 10 OS you can refer to the same @ OATS Functional Testing Compatibility with browsers, OS, JAVA .
      But if I have to try, I might try following things:

      • Do a clean un-install of whichever OATS is available, please refer to installation guide.
      • Remove all JREs installed so far.
      • Launch Oracle EBS forms and let the 6 update 45 be installed when trying to launch Oracle EBS Forms.
      • Install OATS (12.4 or 12.5)
      • Make sure the IE browser XSS settings are disabled for all security areas ( go to Internet Explorer, Tools & Options, Security tab )
      • Add your ebs URL as trusted site in the IE settings. ( un check the check box if your ORACLE EBS url is not enabled with ssl )
      • Right Click on OATS short cut and then “Run as Administrator”
      • Once OATS is launched create project for support of Oracle EBS Forms
      • Click on record button and continue recording Oracle EBS Forms.

      Please do revert to me in case of any issues, we can go on a screen share, I would be more than happy to help.
      Thanks
      Srinivas P.

      Reply
  • Hi Srinivas,

    Thanks for the suggestion. Now I am able to open forms in EBS but unable to record them in OATS.
    Other web record/playback are working fine in OATS.

    Now I have below configs:

    OATS – Version: 12.3.0.1 Build 376
    Windows – 10
    Java 6 update 45 for the sake of EBS 12.

    Oracle Applications : 12.1.1
    Oracle Forms Version : 10.1.2.3.0

    I am ready to share screen. Pls email me the time.

    Thanks,
    Ron.

    Reply
  • Thanks a lot for taking your time to solve the issue. Now I can access forms as well.
    I really appreciate your eagerness to solve the issues and your knowledge on the subject.

    Reply
    • It was pleasure meeting you Ron and I am glad that I could be of help to you and was able to solve your issue.
      Kindly spread the word about http://testingtools.co among your friends, I would be more than happy to help more people.
      Also, keep following this blog, as I am going to add more content and draft troubleshooting using these tools for enterprise applications like Oracle EBS Applications, Salesforce, Cloud Applications, Custom Web Applications, ADF Applications etc.

      Reply
  • Hi Ron D and Srivivas P,

    Please help me with the issue i am facing.

    I am able to work on EBS forms manually but when i am trying to record or identify any element on the Forms i am not able too.

    Issue is similar to want was faced by Ron D. My configuration is same as what Ron D had.

    OATS – Version: 12.3.0.1 Build 376
    Windows – 10
    Java 6 update 45 for the sake of EBS 12.

    Oracle Applications : 12.1.1
    Oracle Forms Version : 10.1.2.3.0

    Please help me its urgent.

    Reply
    • Hi Jijo,

      Have you tried the steps mentioned in the previous comments? Even if you are still unable to kindly check your email, have dropped an email we can take it further.
      Don’t worry it will be solved.

      thanks
      Srinivas P

      Reply
  • Hi Srinivas,
    I went through your blog and I facing the same issue wat Ron D faced.
    Kindly help me out too.

    I am able to open forms in EBS but unable to record them in OATS.

    Other web record/playback are working fine in OATS.

    I have below configs:

    OATS – Version: 12.3.0.1 Build 376
    Windows – 7
    Java 6 update 45 for the sake of EBS 12.

    Oracle Applications : 12.1.1
    Oracle Forms Version : 10.1.2.3.0

    Please help me in resolving the issue. It’s urgent .
    Thanks,
    Jijo

    Reply
    • Hi Jijo,

      With 12.3 you may not be able to solve the issue, did you give a try using OATS 12.5 , check out the OATS Compatibility with JRE and other factors.

      thanks
      Srinivas P

      Reply
    • Great meeting you Jijo, Happy to see that your issue is resolved now.

      So it worked with OATS 12.3, JRE 6 update 7 version , IE 11, some of the precautions are
      1. Have only 1 JRE if that is enough.
      2. Go to Oracle EBS Forms Object Identification and click on Apply to generate the required dependencies.
      3. Also, in IE 11, go to manage addons and then enable the OATS related plugin to work properly, otherwise the recorders will not start.

      Please feel free to post any issues through comments and I would be more than happy to help out 🙂 have a good day

      Reply
  • Same here Srinivas !!! Thanks for the help ! Really appreciate you taking time and looking into my issue… Thanks alot !

    Reply
  • Thanks a lot for all the info provided on OATS.
    I have a great enthusiasm learning OATS. and i found this only tutorial great for the same. However i didn’t find the full tutorial.
    It will be great if i could have learned the rest of the concepts as well. Please provide me with any other or new material which could help me.

    Thanks a lot in advance.

    Reply
    • HI Sahil,

      This is great to know and I am glad that you liked the articles about OATS (ORACLE Application Testing Suite) I am trying my best to add more articles at the pace I can, I would request you to follow this space regularly and you would be able to learn :).

      But in case you are looking to learn before the articles are actually done, you might have to drop a note or request for OATS Online Training

      In case you are practising and having issues, you can very well ask your queries in form of comments and I would try my best to give you resolutions.
      Keep watching for more articles and tutorials on OATS.

      Reply
  • Thanks Srinivas for the reponse. I will surely follow this tutorial 🙂
    Could you please tell me if there is any inbuilt method or functionality available in OATS to handle Dynamic Objects (like if on any web page,sometime a popup appear and sometime not and if it appears , we cant proceed further without handling it). how we can handle it?

    Best Regards

    Reply
  • Hi Srinivas,

    1. I am using Openscript for my project (Oracle Forms application) and i am getting error while login application (Failed to connect to the Oracle Forms applet after 30 seconds. Verify that the applet launching page opens, and that the Forms Startup Timeout setting is high enough for this site.”)

    2. How to set build path for openscript

    Could you please provide me suggestion / advice, it would be more helpful to me to proceed further.

    Thanks
    M. Phanikumar

    Reply
    • HI Phani,

      Thanks for reaching out to me , we can get on a screen share and see how we can solve this issue.

      Reply
  • Hi Srinivas,

    I am testing E-BS with OATS. I am able to record all the web objects but OpenScript is unable to identify Applet and any Oracle Forms object. Also, i have noticed while recording my Config Recorder show Applet Recorder status as ‘Starting’ and it never changes to ‘Running’.
    Could you please help resolve the issue.

    Much Thanks
    Bushra

    Reply
  • Hi Srinivas,
    Currently, I am evaluating the OATS tool for one of the application’s performance testing. The application using the following technologies

    Oracle forms version:12.x Database:12c JDK & JRE 1.8 with WebLogic server.

    Is the latest OATS version 12.5.0.3 Build 1012 supports the above application.

    Currently, I am using the trial version of OATS version 12.5.0.3 Build 1012.

    I am able to record the flow but while replaying it is giving the below error

    Dec 16, 2016 8:42:24 PM oracle.oats.scripting.modules.formsLT.shared.AbstractEngine getFormsVersion
    WARNING: AbstractEngine.getFormsVersion() is called before initializing formsVersion first!
    20:42:24,159 ERROR [1] Error in section Unspecified at line unknown. ScriptException occured. An unexpected exception occurred in the script. Script section: Unspecified.
    java.lang.AssertionError: Invalid Terminal Message Code: [1] (6i: 3>=code>=0, 10g: 3>=code>=-1, 11g: 3>=code>=-1)
    at oracle.oats.scripting.modules.formsLT.api.tclasses.TFormsLTObjectDelegateB.getTerminalMessagesAsArray(TFormsLTObjectDelegateB.java:221)
    at oracle.oats.scripting.modules.formsLT.api.tclasses.TFormsLTObjectDelegateB.sendRawMessageImpl(TFormsLTObjectDelegateB.java:174)
    at oracle.oats.scripting.modules.formsLT.api.tclasses.TFormsLTObject.sendMessage(TFormsLTObject.java:1134)
    at script.run(script.java:147)
    at oracle.oats.scripting.modules.basic.api.IteratingVUser.run(IteratingVUser.java:353)
    at oracle.oats.scripting.modules.basic.api.internal.IteratingAgent.run(IteratingAgent.java:801)
    at java.lang.Thread.run(Thread.java:745)
    20:42:24,231 INFO [1] Finished VU 1 for script SAT

    Please suggest whether it supports or not. If supports what is the solution to fix it.

    Thanks a lot ,Bikram

    Reply
    • Hi Bikram,

      Thank you so much for reaching out to us @ http://testingtools.co , we are glad that you could find us. Ideally OATS supports load testing for the technologies you specified. Let me know if it would be possible for you to come over a screen share ? so that we can work towards solving it?

      Reply
  • Hi Srinivas,

    I am able to record Oracle forms application it includes applets but when playback it is not recognizing the applet code and it terminate the execution – result showing as Failed.

    Can you please provide the solution how to recognize if it is an applet inside an oracle forms?

    JRE installed in my system 1.6.0_20, 1.6.0_35, 1.7.0_25, 1.7.0_45, 1.7.0_51, 1.7.0_55, 1.7.0_67, 1.7.0_80 and 1.8.0_92 versions

    Thanks in advance !!!

    Regards,
    M. Phanikumar

    Reply
    • Hi Phani,

      Thank you so much for reaching out to me for an issue regarding recognition of Oracle Forms with Oracle Application Testing Suite, before I give any response, may I confirm from you that, when you are recording Oracle EBS Forms you are getting script code as applet and not forms? or are you saying that some parts in Oracle Forms are having applets and those are not supported?

      Kindly let me know more details, apart from this, if it is possible I would suggest you to remove all the JRE versions and keep only the one which is required for the Oracle Forms to launch, also make sure the appropriate OATS version is installed. You can refer to OATS Compatibility with JRE, Operating System & Browser versions.

      Please do revert to me in case of any queries.

      Thanks,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I have tried with one JRE version by disable rest of all JRE versions and still not able to recognize applets with in Oracle Forms application.

    YES. some parts in Oracle Forms are having applets and those are not supported.

    Can you please provide solution for this issue.

    Thanks & Regards,
    M. Phanikumar

    Reply
  • Hi Srinivas,

    Can OATS be used to build scripts into CI servers like Jenkins and run om maven builds?
    Is it only for web application based scripts or form based scripts or forms as well?

    Regards,
    Amrita

    Reply
    • Hi Amrita,

      Thank you so much for posting this query, Using Oracle Application Testing Suite ( a.k.a OATS ) you can automate any web based application, Oracle Applications like ( Oracle EBS Application – Forms, OAF, Telnet etc… Oracle JDE, Oracle Siebel etc.. ) for more details you could go through Test Automation Capabilities of OATS which covers what are the different types of testing OATS can support along with Types of applications and list of applications it can test automate.

      And regarding can it be integrated with build tools and CI tools, I have responded about this in your other comment, hope that should give you some info and please feel free to ask for any more queries in form of comments.

      Thanks
      Srinivas P.

      Reply
  • Hi Srinivas,

    Can you please provide some information on Oracle Flow Builder, is it works / install in Windows environment?

    if it works, can you please provide download version details.

    Thanks & Regards,
    M. Phanikumar

    Reply
    • Hi Phanikumar,

      While oracle flow builder has a lot of advantage with in built component based framework and huge list of pre-built components for functional modules in Oracle EBS Applications across different product families, it cannot be installed on a windows environment. You need to have a Linux Box with specific OS version which is compatible to install.

      Thanks,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I am working OFT data Parametrization, can you please provide how to retrieve data from data base table and print in DATA TABLE sheet in OFT.

    Regards,
    M. Phanikumar

    Reply
  • Hi Srinivas,
    We observed Open script is executing the script very slow occasionally. means it is taking long wait time between action to action. Some times its executing jst normally.

    Did you also see any thing similar to this related to the script execution and any possible solution for this ?

    Reply
    • Hi Murali,

      Thank you so much for reaching out to us, sorry for the delay in response, I have also encountered this kind of degradation in performance when scripts are run for long time, this was more prominent in earlier versions of OATS, it has improved in latest versions. But even for this kind of situations I would recommend you to go through 2 ways to maintain stable performance of OpenScript.

      Hope this would provide you some help, kindly let us know in case any of these things does not work for you. We can debug and understand.

      Reply
  • Thank you very much Srinivas. This looks like i see some improvement in the execution. Is there any option like to clear the Open script cache or refresh kind of thing ?

    Reply
    • It’s great to know that it did help improve maintaining the performance of OATS , may I know what do you mean by Open Script cache? Is there any specific reason for this??

      Reply
  • Hello Srinivas,

    I have 2 questions:
    1. Can OATS be used for API testing or it only supports UI testing? Is it extensible to test APIs?
    2. How can we identify and test windows based pop-ups in OATS e.g. file upload?

    Regards,
    Amrita

    Reply
    • Hi Amrita,

      Thank you for reaching out to us, please find below my responses for your queries.
      1. Can OATS be used for API Testing – > Yes, OATS does support non UI functional testing for the following areas.

      a. PL / SQL API calls -> you will have to write some java code and build libraries to work with calling PL / SQL Api calls.

      b. SOA Web Services -> OATS comes with “Web Service” based projects, using which you can get the list of functions for a WSDL file and view payloads, created requests from OATS UI and invoke them whenever required. You can refer to these videos which I have created, will be quite useful
      How to create Web Services Testing Script using OATS and How to add Verification Points to Web Services automation

      c. RESTFUL Services -> you will have to write some java code and build libraries to work with calling RESTFUL services as well.

      2. How can we identify and test windows based pop-ups in OATS -> the best way is to record the steps once and you will have to manipulate the code a little bit to make it more generic.

      Hope my responses are useful, please do let me know in case you need more clarifications.

      Thanks
      Srinivas P.

      Reply
  • Hi Srinivas,

    I have tried with one JRE version by disable rest of all JRE versions and still not able to recognize applets with in Oracle Forms application.

    Some parts in Oracle Forms are having applets and those are not supported.

    Can you please provide or suggest on this this issue.

    Thanks & Regards,
    M. Phanikumar

    Reply
  • Hi,

    I want to customise the default results report generated by OpenScript. Ho can I do that?

    For Ex:

    At the Initialize Section:
    I want to add Manual Steps involved in that particular script.

    Step1: Login as Buyer
    Step2: Launch Purchase Order Form
    Step3: Enter Supplier Name
    Step4: Enter Item, Qty, Need By Date
    Step5: Click Save.
    Step6: Approve Purchase Order.

    Can you pls explain me?

    Reply
    • Hi Ram,

      Unfortunately there is no direct way of modifying the result file generated by OATS, but you may have to generate your own Result file either scanning the Result file XML generated by OATS and then display only the things which you want to get displayed in a separate file, as where you want to show the customized result file.

      You may have to print some additional steps with some specific notations, so that when you parse the OATS generated result file, you can pick only those which are with special notation and then generate a new result file for these specific notations, this how we have created a customized result file in one of the projects i worked on.

      Hope this gives some initial inputs or steps as how to proceed further, please do revert to us in case of any further queries, we would be more than happy to help.

      Thanks,
      Srinivas P.

      Reply
  • Hi Srinivas,

    We have QTP Scripts for all of our tests on Oracle EBusiness Suite. Now we want to use Oracle OpenScript.
    Is there a possibility to convert all of our scripts from QTP to OpenScript ?
    Will Oracle Flow Builder help to reduce effort put on migration?

    Reply
    • Hi Ram,

      Thank you so much for reaching out to us about an option to convert existing QTP scripts to OATS scripts.

      For anything we could write solution 🙂 but we need to see how much effort and valuable is it. There might be cases where the conversion can be easy based on the kind of framework used for developing the QTP scripts.
      If you can share some details, we can discuss about the possibility to write a conversion tool for the same.

      Regarding Oracle Flow Builder tool, well it definitely reduces the amount of time to develop automation scripts by using pre-built components, component sets and flows.
      If your Oracle EBS application does not have much of customization it should be very quick than traditional development time. But if it has considerable amount of customization in Oracle EBS Application, you need to first identify the components to be built which will suite to your application’s business functionalities.

      Once these components are ready, you should be able to quickly stitch the flows( i.e. the test automation scenarios ) . But for you to know how to create new components or customize existing components to suite to your needs, you should have fair amount of knowledge on the in-built framework of oracle flow builder and also the constructs it provides.

      Either of these cases discussed above, I can help you out, do let me know if you would be interested to get on to a discussion, you can reach out to me at testingtools.co@gmail.com

      Hope these details has given some insightful details, in case of any further details please feel free to share them in form of comments, we would be more than happy to help you out.

      Reply
  • Hi Srinivas,
    while playback I am getting error message “Failed to connect to the Oracle Forms applet after 120 seconds. Verify that the applet launching page opens, and that the Forms Startup Timeout setting is high enough for this site.”.
    Can you please help me.
    When I try to open forms manually it is working fine. The problem is only when I run the script in OATS and try to open the forms.

    Reply
    • Hi Chandrasekhar,

      Yes these issues might come in to picture when working with Oracle Application Testing Suite, you should be well aware of it, there might be n number of reasons for this, may be if you can come over a screen share, I can help you out. You can reach out to me at testingtools.co@gmail.com for further communication.

      Thanks,
      Srinivas P.

      Reply
      • Hi Srinivas,
        Thanks for quick revert. I can’t share the screen due to company policies…Is it possible to guide to solve this, with out screen share.

        Reply
        • OK, lets give a try, but I am expecting you to be active on giving responses, so that we can try to resolve over these comments.

          First thing:
          When you play back the script, are the Oracle EBS Forms launching or not?

          Reply
  • Srinivas, we can try this tomorrow…As I left my laptop in office….Will you be active every day this time…Or tomorrow India morning fine?

    Reply
    • That depends Chandrasekhar, you could even email me at testingtools.co@gmail.com in case i could not respond to you, and i can come online or you can message me over twitter @testingtoolsco this would be the best way.. 🙂

      Reply
      • Hi Srinivas,
        please let me know, when you are available, we can work to solve the issue.

        Reply
        • Hi Chandrasekhar,

          There is an unplanned travel, I might have to start any time, until then shall try, please start responding to the earlier query which i had asked for.

          Thanks,
          Srinivas P.

          Reply
          • sorry for delay response. Coming to your question, when I playback forms are not opening.

          • This might be because of couple of reasons. Before i go ahead , did you make sure you are uaing the right OATS version?

            You can search in google with “OATS comptibility version” in the reaults go to testingtools.co related article you would get to know the list of jre versions, browsers, operating systems and OATS versions. If not, pls uninstall the OATS you have and install the right one, you can refer to clean uninstall of OATs in testingtools.co you would get the details.

            Later, make sure you have only one jre version which ia required for your ebs forms to launch and then uninstall all other jres from your machine.

            Next go to windows+run in that pla give %appdata% and then press enter button.

            Next go one folder level up in the newly opened folder view, now change directory to LocalLow > Sun > Java > and then delete all folders under this folder.

            Next launch the oracle ebs forms manually , pls make sure that openscript IDE is not open, and once the forms are launched. Now you can try with recording using OpenScript IDE for OATS, i think this time you should be successful.

            In case you are still unable to proceed pls do reply me back over comments.

            Thanks,
            Srinivas P

  • Hi Srinivas,

    Thanks for your response:)

    I have below versions of JAVA, OATS and Browser:
    Java : 1.8 (Update 45)
    OATS : 12.5.0.2 Build 537
    Browser : Internet Explorer 11
    Operating System : Windows7

    I think there is no problem with these versions.

    And I navigated LocalLow > Sun > Java and deleted folders there.

    I am able to launch forms manually. I recorded using OATS as well, which ids fine.
    Sorry to inform you, but when I playback forms are not opening.

    Can you please guide me.

    Regards,
    Chandrasekhar S

    Reply
    • Thanks for sharing the info and configurations, so are you saying that now you are able to record oracle EBS forms with OATs but unable to launch forms when playback of the script?

      Reply
  • yes…Earlier also I am able to record, the problem is while playback.

    Reply
    • I have never seen or experienced issue of this kind till now, where one can record the ebs forms but unable to play back.

      Are you recording and playing back on the same EBS instance / url or is it different? also did you check if JRE version is enabled for EBS Forms Automation in OpenScript IDE ? this is ideally present in Tools Menu

      Reply
  • Yes Srinivas. I am enabled Java version as well and trying to access same instance.

    If you see the comments in this page, even Phanikumar faced same issue:

    FYI, question from Phani:
    Phanikumar
    June 23, 2016 at 8:53 am

    Hi Srinivas,

    1. I am using Openscript for my project (Oracle Forms application) and i am getting error while login application (Failed to connect to the Oracle Forms applet after 30 seconds. Verify that the applet launching page opens, and that the Forms Startup Timeout setting is high enough for this site.”)

    2. How to set build path for openscript

    Could you please provide me suggestion / advice, it would be more helpful to me to proceed further.

    Thanks
    M. Phanikumar

    Reply
    • hi Chandrasekhar,

      The issue which phani was for applet objects and not for Oracle EBS forms, I am really sorry that I could not be of help, there is something missing in the process or may be some data is missing for me to interpret.

      I would be more than happy to help over a screen share, it may not work this way by just sharing details over comments when it comes to critical issues, I remember you mentioning over an email that your manager would come back. Try to get an approval for screen share may be i can be of help.

      I have helped all the people who have come over screen share especially for these kind of issues and they were able to proceed happily.

      Thanks,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I am currently working on OTM, i want to Run tests by launching Open Script for debugging purpose.

    Currently, the test status is displaying as passed by running background, but i want to check the script execution visible (launch openscript script to execute from OTM).

    Can you please provide suggestion on this.

    Regards,
    Kumar

    Reply
  • Hi Srinivas, Hope you are doing great. I have a different scenario. As part of org updates, all our laptops are upgraded to Windows 10 and we are using windows7 earlier with OATS 12.5.3.
    Now we installed OATS in windows 10 and facing recorders issue and java issue.
    Recorders issues: IE11 is having the Openscript and BHO addin and enabled , but if we click on record in open script, IE is opening but getting ” Failed to load recorders” error.

    Java issue: OATS java installed in C:\program files 86\JAVA\jre6 and Open script>Tools>Manage EBS forms automation> Java is disabled and its not enabling even after select and click on Enable.

    I have installed JRE7U67 in program files 86, but OATS didn’t identify the JAVA and not showing the jre7 in Open script>Tools>Manage EBS forms automation.

    Please assist me here.

    Reply
  • An update to my above comment:
    Some how after uninstall/installing of java versions, Open script>Tools>Manage EBS forms automation> Java is enabled and still getting the “Can’t get a connection from the browser after waiting for 15 seconds” error.

    IE: 11, OATS 12.5.3, Windows 10-64 Bit, Java -JRE1.7.0_71 and enabled at user level and system level.

    I see services available are Oracle ATS Agent and ATS Helper only. Is there any other services required that i missed while installation ? I did complete installation and ignored the XE database configuration.

    Reply
    • Hi Murali,

      Can you do the following and let me know the observations?

      1. Help > Run Diagnosis Tool and see if everything is fine or share with me what ever is not success.

      2. When you click on record, I hope IE browser is launching even if connection is not established, pls do not stop anything just go to IE > Tools > Manage Addons Nd see if its enabled in this browser,not the one that you launch manually.

      3. If you have a compatible FireFox browser installed can you check if you are able to record?

      4. When you said the laptop is upgraded to Windows 10 Version, the issues which you have shared now is experienced in all laptops or is it that you are first checking before repeating it in other machines?

      Reply
  • Hi Srinivas, Thank you for your inputs. Diagnosis looks fine and the problem is with Admin. If we run with Admin, every thing working fine and if we don’t run as admin, getting Recorders error. Is there any way to resolve the recorder error with out running as Admin ?

    Reply
    • No, it is mandatory when working with OATS you need to start OATS with “Run As Administrator” option, but you can make the application always start with “Administrator” option.

      Follow the below steps and you should be good, otherwise every time you have to right click and select “Run As Administrator” and also need to click Yes on the popup that you get.

      This post Internet Explorer crashing has the clear steps for making the OpenScript tool run as administrator always and also to suppress the popup window and need not to click on “Yes” button every time you run as administrator.

      Reply
  • Hi Srini,

    Your post on query replies are awesome and very much appreciated.

    I have the following queries on OATS related to 12.5.0.3 version

    1) In OFT Can we add objects of entire screen(EBS Forms) in ObjectLibrary without recording?

    2) In OFT Add to watch option will not be visible everytime, what is the cause ?

    3) How to execute through OTM using command line?

    4) In OFT/OTM
    Is Parallel execution of different scripts in two different instances of same browsers in same workstation Command Line Interface or OTM possible ?

    5) In OTM what is the File type supported for 3rd Party Test in OTM and where can it be used in real time.

    6) In OFT How to add our own user defined functions and make it available at global level ?

    7) In OFT how Think time modification is done – apart from setting in OpenScript preferences.

    8) In OFT Adding tests is only for Web functional or for EBS Forms also.

    9) In OFT Need Customization of recorded script with control statements
    examples.

    10) How to populate comment and attachments column in test steps in OTM ?

    11) In OTM Link section while creating testplan,test set (how linking the SVN path to this section is done, any examples).

    12) In OTM Command line run settings field in Test creation as examples.

    13) In OTM Adding the data at backend is not getting reflected in the GUI of OTM.

    14) In OFT What is the purpose of Block scenario and is unavailable to add the complete block ?

    15) In OFT Java Exception breakpoint unable to generate exception at that breakpoint during playback.

    16) In OFT Utilities Module- Working with xml -Unable to execute the loadxml(url) method as it is throwing exception.

    17) In OFT Working with XPath generator setting – Unable to generate the xpath for the entire xml file content.

    18) In OFT Unable to execute complete script through command line for shared data module in OFT. It is stopping execution where we are enabling Shared data service.

    19) How to debug a script in OFT (Child script)?

    20) DataTable concept in openscript. How to access parent dataTable in child scripts ?

    21) Can we record one scenario using multiple technology-forms,ADF,BIP,
    Web Services ?

    22) OFT and application is not visible while executing the script through OTM

    23) Data parameterization in OTM ?

    24) Get list of all available APIs for OpenScript and OTM.

    25) How to migrate vbScript file to java file?

    26) File type supported for 3rd Party Test in OTM other than Manual Test
    and Open Script Test. Examples if any ?

    27) How we can invoke the test cases execution with Jenkins?

    28) RecordedFormsNodeActionElement cannot be cast to oracle.oats.scripting.modules.

    Thanks

    Ajaz Ahmed

    Reply
    • Hi Ajaz,

      These are huge list of queries, I maintain this blog to help my readers and enthusiasts and learners, but it will be in the pace of my leisure time, you can expect answers to them one after other.

      And I appreciate that you had lot of questions and glad that you reached out to me for help.

      Thanks,
      Srinivas P.

      Reply
  • Hi Srini,

    Any clue on my posted list of queries, I expect 5 solutions for each time

    Thanks

    Ajaz

    Reply
    • I understand that you are in need of early answers, I will try my best Ajaz.

      Please find below my responses for first 5 queries:

      1) In OFT Can we add objects of entire screen(EBS Forms) in ObjectLibrary without recording?
      Our response: No such feature provided by OFT unfortunately 🙁

      2) In OFT Add to watch option will not be visible everytime, what is the cause ?
      Our response: Yes it does happen if some ground rules are not followed, in order to have consistent behavior of this, make sure that your Debug pane is active in the Eclipse IDE and select IteratingAgent1 node in the tree present in debug pane, then you would not have this inconsistent behavior. Hope it helps.

      3) How to execute through OTM using command line?
      Our response: There is no such way available till date.

      4) In OFT/OTM Is Parallel execution of different scripts in two different instances of same browsers in same workstation Command Line Interface or OTM possible ?
      Our response: From OTM it is not possible but with OFT using command line executions you could acheive this.

      5) In OTM what is the File type supported for 3rd Party Test in OTM and where can it be used in real time.
      Our response: We have no idea about this Ajaz, in case you have done any exploring on this, please do share the details with us over here, it would be helpful for others too.

      Reply
    • Please find below our responses for next 5 questions:

      6) In OFT How to add our own user defined functions and make it available at global level ?
      Our response: please follow this article: How to create function library in OATS / OFT

      7) In OFT how Think time modification is done – apart from setting in OpenScript preferences.
      Our response:Could you please elaborate your question, sorry I could not understand

      8) In OFT Adding tests is only for Web functional or for EBS Forms also.
      Our response: It is available for all test projects be it be Web / Oracle EBS forms script provided in OFT.

      9) In OFT Need Customization of recorded script with control statements examples.
      Our response: Could you please elaborate your question?

      10) How to populate comment and attachments column in test steps in OTM ?
      Our response: There are no APIs provided by OTM to do this, but if you are ready to explore, try checking out the Db schema of OTM and then get details of right tables and populate them using java coding connecting to database.

      Reply
  • Hi Srinivas,
    At present we are using Oracle EBS R12 with database oracle 10g located in one of our data centers.

    We have a plan to upgrade to cloud from data center. Will OATS Open script works on the ERP forms which are hosted in cloud ? Both functional automation and performance automation ?

    Please suggest.

    Reply
    • Hi Murali,

      This is nice to know, that you / your org has a plan to move the data center over cloud. Nice initiative, I wish you and your org gets better results out of it.

      Well coming to your query, irrespective of where oracle ebs application is hosted, as long as OATS is installed on a machine / laptop where you can access the Oracle EBS Application, OATS can automate it, be it be functional automation or performance automation. And you must also be aware that your user should have admin privileges.

      In case you have any issues doing so, please feel free to reach out to me 🙂 I can try to help you.

      Reply
  • Hi Srinivas,

    I facing an issue in OATS. While trying to record a script for an Oracle EBS Forms type project , I am getting an error stating FormsFTRecorder has encountered a problem. InstallFormsFT Helper Failure: Cause: Picked up JAVA_TOOL_OPTIONS:-agentlib:jvmhook Picket up _JAVA_OPTIONS: -Xrunjvmhook -Xbootclasspath/a:”C:\Program Files(x86)\HP\UFT\bin\java_shared\classes\jasmine.jar”

    Reply
    • It is expected to face this issue, which is because you are trying to have both UFT and OATS in single machine.
      OATS also uses the JAVA_TOOL_OPTIONS or _JAVA_OPTIONS for recognizing objects, for now what you can try is save this environment variable in some location and delete it from current Environment variables, I do not guarantee that it will work. There may be more Registry Entries and also JRE deployment folders to be cleared etc… anyways give a try and see if you can get a break through.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *