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.

Introduction to OATS
OATS installation
Introduction to Openscript UI
  • 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 Stabilization 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.

Basics of OATS
Working with Object Library
Test Data Parameterization
Working with Scripts
Verification Points:

  • Add Verification points using OpenScript tool.
  • Add Verification points programatically in OATS.

Script Stabilization:

  • Adding synchronization steps
  • Replace with stable code where ever direct recorded code may not be useful.

Re-Usability of code:

Exception Handling:

  • UI based exception handling

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
12 Most important command line options for OATS
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 (219)

  • 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 https://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 @ https://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
  • Hi All,

    I have just started learning OATS recently.

    Can Someone assist me, up to what level I need Java Knowledge ?

    What is the dependency on Java Knowledge in “OpenScript” ? In which area of Java I need to be strong ?

    Please guide me.

    Reply
    • Hi Pranaya,

      Thank you for reaching out to us, you may not need high level of knowledge as a beginner, but if you are looking to start writing frameworks you might need more advanced java knowledge, until then you can refer to the list of things to be learnt at the following link @ Learn Java for Test Automation

      Reply
  • Hi Srinivas,

    The inspect Path in Openscript will launch new browser instead of considering the browser which is already opened by Openscript during playback. Is it designed the same way?

    Reply
    • Did you try selecting the browser which comes in the list box which has globe as image before clicking on inspect element icon.

      And, sometimes even when we select the right browser and then click, OATS will still launch a new browser, not sure when it happens exactly. few of my observations is when there was abrupt stop in execution / when you navigate to different script and then try to click on inspect.

      Reply
  • Hi Srinivas,

    Do you have idea as to where the recording logs are getting stored in Openscript?

    Reply
  • Hi Srinivas,

    Is there any way to capture the tooltip in Openscript?

    Reply
  • Hi Srinivas,

    Is there a way to Validate the Report generated in html format in Openscript? Any libraries available for that?

    Reply
    • HI Kavitha,

      There are no direct libraries available, but for sure you can write a java program to scan and do the desired activities.

      Reply
  • hi All,

    Need your help,

    initially we were using Oracle EBS 10 g Applet based form, we have created script for that it was working fine. But currently our organisation changed Application from Oracle EBS 10g forms to Oracle Fusion Middleware 11g Applet based forms. i want to use existing script bit it is not working. event i tried to record new Fusion Middleware form script but only web navigation is getting recorded other applet navigation is not getting recorded.

    Kindly help me to resolve this issue!
    Thanks in advance…

    Reply
    • Sorry for the delay in response, I hope your issue is resolved.
      I am just trying to give a response, so that it might be useful for others. You may have to clear java cache, also remove the java deployment folder in %APPDATA% roaming folders and then try to launch forms again without opening OATS tool.
      Also, make sure the OATS version is compatible to the latest forms java version

      Reply
  • Hi,

    I recorded Oracle forms testing in the OATS application.

    When i replay the form takes time to complete the request which is submitted by user.

    how to make the replay session to wait till the form column changes to completed.

    Can you please tell me how to save a webpage using Java code in the openscript?

    Reply
    • Hi Kumar,

      Thank you so much for reaching out to us on this regarding testing the Oracle EBS application using Oracle OATS, especially when submitting the Concurrent request, which has two columns i.e Phase / Status.
      It is a general need that as part of automation, we need to make the script wait till the Status changes to “Completed”, what we generally do is write a common function something like “waitForRequestCompletion” in which there will be a for loop, and the loop has the following steps.
      1. Click on Refresh Request Data button
      2. Get value from the status field
      3. Check if the value of this field is “Completed” and break the loop, else continue with the for loop.

      This is an algorithm which you can build as code snippet and go ahead using it.

      For saving a web page, you may have to record those steps and it will be little difficult to come up with a stable code for this action, you may have to end up in writing a code with Robot Class of Java. please give a try and let us know.
      You can even share your code here for doing this activity, I can see if any more things can be changed.

      Thank you once again in reaching out to us, keep reading and posting your queries in form of comments, we will try our best to solve the same.

      thank you,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I have been working with OpenScript and OTM from quite a few days and even got multiple queries clarified from your blog. Thank you very much fro your valuable response for the queries.

    Currently I am facing an issue in executing the OFT script in OTM. We have a Agent Machine where we access the OTM server through firefox browser. The script which has been designed works perfectly fine when we execute it in OFT installed in Agent Machine. But when we try executing the same script in OTM the script is getting failed with this error : 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.

    We have re-configured all the agent settings in this machine but the issue still exists.
    Could you please provide a resolution for this issue?

    Thanks,
    Aisha

    Reply
    • HI Aisha,

      I am glad that you were able to proceed and make progress on using OFT(Openscript) and OTM(Oracle Test Manager).

      The reason could be that some times, when we launch Forms from an external tool, forms may not launch properly.

      For this can you please check doing any of these will help.

      1. Set the browser to be run as administrator always
      2. Set Openscript Tool to be run as administrator always
      3. When you run script from OTM, you can also give parameters, where you can set the forms initial launch time to be 300 or more.. so that enough time is given. i.e. “-formsft.startup_timeout 300” without double quotes.
      You may have to ask your IT team to do this, in case you do not have the required privileges.

      Also, can you let me know if you are able to see the execution when triggered from OTM.

      Reply
  • Hi Srinivas,

    I have tried giving the command -formsft.startup_timeout 300 in command line run settings but still there is no difference.
    And also i observed that while OTM is executing the script and in task manager if iexplore task has started then if we manually launch the application, OTM continues the execution without any interruption and we can see the execution along with application being visible.

    Where are we supposed to set browser and open script to be Run as Administrator?

    Thanks,
    Aisha

    Reply
    • Hi Aisha,

      Checkout – Steps to set OATS Run As Administrator always, you can follow similar steps to make Internet Explorer run as administrator always.

      Note: In the process of this, Windows prompts for Privileges, try by giving your credentials and if it does not work, you should contact your IT team for the same.

      Please do let me know in case you have any issues.

      Thank You,
      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    Thanks for your reply. We are trying to fix the issue from our end by re-installing OFT.

    I have one more weird issue encountered in OpenScript. I have a form for which i have written a line of code to click on a particular button which will take me to a different form. The second form is opened while the script is still executing the line of code written for the button click. And it is observed that OpenScript tries to click on the same button(which is in first form) again which leads to greyed out screen in the application.

    Have you encountered any such issue? and it would be of great help if you could provide a solution for it.

    Thanks,
    Aisha

    Reply
    • Hi Aisha,
      I dont think you need to re-install OATS, anyways up to you guys. Please keep us posted if you could finally solve it.

      Regarding the second issue, can you share the sample code for those 2 actions? so that I can see if there is anything happening

      Reply
  • Hi Srinivas,

    Below mentioned is the block of code which is making the entire screen greyed out by performing the click operation twice.
    if(!forms.textField(“//forms:textField[(@name=’T_TA_ORDRE_DEAL_REF_0′)]”).getText()).equals(“”))
    { if(forms.checkBox(“//forms:checkBox[(@name=’T_TA_ORDRE_CHECK_0′)]”).exists()) { forms.checkBox(“//forms:checkBox[(@name=’T_TA_ORDRE_CHECK_0′)]”).check(true);
    think(2);
    }
    //Active confirmation forms.button(“//forms:button[(@name=’BUTTONS_RETURN_0′)]”).click();
    think(2);
    }

    The line of code after the comment ‘//Active confirmation’ is triggering the click operation twice even though we have written the code for single click.

    Thanks,
    Aisha

    Reply
    • Hi Aisha,

      Sorry for the delay in response. Please find below my response.

      First thing, I see that there is one small issue in the code in the first line
      if(!forms.textField(“//forms:textField[(@name=’T_TA_ORDRE_DEAL_REF_0′)]”).getText()).equals(“”)) it has an additional closing bracket, could you please remove it and keep as below, it might work

      After removing additional closing round bracket.
      if(!forms.textField(“//forms:textField[(@name=’T_TA_ORDRE_DEAL_REF_0′)]”).getText().equals(“”))

      Please do let me know if it works.

      Thank You,
      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    Thanks for the reply. I shall try it and keep you updated on the same.
    I have encountered with another issue while executing script in OFT. We have used a functional library to store all the generic functions used in the project and it has been added in Assets tab.
    Now when we are executing the scripts, it is throwing ‘Failed to create script service’ for the function library which we have used.
    Can you please let me know how to resolve this issue as we are not able to find the root cause for this?

    Thanks,
    Aisha

    Reply
    • this might come when you use old versions of OATS , I recommend you to switch to latest one as long as it is fine, which other wise, there is one work around, change your IDE perspective to Developer View, on the top menu you need to go to some option like project clean and then you need to select your project and finish the task, from next time it might work.

      Reply
  • Hi Srinivas P,

    I am new to OpenScript tool i was exploring to this tool and installed in my personal system and got some issues on recording got resolved now.

    Before going to use OpenScript tool in office i want to get clarity on Licencing part for OpenScript only (Not for entire soot), since it’s not asked licence in my personal computer should we use in corporate company also for free or not?.

    If not any idea for licence cost on this.

    Looking foreword for your replay.

    Thanks,
    Srinivasulu Reddy M
    smukkidi@gmail.com

    Reply
    • HI Srinivasulu,

      If you are using your developed scripts for learning purpose you dont need to buy OATS license, but you are using it for actual executions and certifying your products, then you need to purchase a license irrespective of whether you are using in your personal or office laptop.

      OATS license can be 12000 USD but generally negotiable, I am not sure if prices are changed now. But I would say, you should reach out to sales department of OATS @ oracle to get the correct information, Information I shared may not be correct.

      Thank You,
      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    OATS Version: 12.5.0.3
    Oracle EBS Version: 12.2.6
    JRE : Java8, update 141
    IE : IE11

    Question:
    When i run the ‘Openscript Diagnosis Tool’, the results shows up an Error for the category ‘Oracle EBS/Forms Load Testing’ and for Name as ‘IE8 XSS Security Settings’.

    I did disable this XSS Setting for my IE11, for all 4 Zones and also tried adding EBS URL to the trusted sites.
    But, this Error doesn’t disappear.

    Currently, recording works fine for Web Applications only. and Not for EBS Forms.

    Request your help in resolving this error.

    Thank you

    Reply
    • Sorry for the delay in response, one of the things which you can try is run Openscript with Run As Administrator option, else we can go on a screen share to check in more detail.

      In case your issue is resolved, please do share the resolution steps over here, it would be helpful for other people who might end up in similar issue.

      Reply
  • Hi Srinivas,

    I have faced the same problem as the one reported by Bushra:

    “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’.”

    Forms started via browser leaves the browser window empty and opens its own window. However, I am not able to record any object from this window, only web objects are recorded.

    Do you have any suggestions for this situation?

    I have:
    Java : 1.8 (Update 144)
    OATS : 13.1.0.1
    Browser : Internet Explorer 11

    Thanks
    Maynard

    Reply
  • HI Srinivas,

    I am trying to test oracle 11g application through openscript Fusion module but it does not record the forms actions.

    Application uses fusion midleware and opens as applet.

    Please could you help me sort out the issue.

    I have done all the configuration as suggested in oracle website.

    Reply
    • Hi Kuldeeep,

      I am assuming, you create an openscript script which is for ADF application(to support fusion testing) automation and then trying to record Oracle EBS forms? please do let me know if my assumption is correct or wrong?

      In case you want to automate Oracle EBS forms, you are supposed to have Oracle EBS Forms based project when creating the script and not Fusion. Which otherwise, you can even try enabling modules for a script and it might start working.

      Reply
      • Hi Srinivas,

        Yes your assumption is correct. I tried both the way but it is not working.
        I created Fusion project and added EBS module and also I created EBS project and added Fusion module. it is not working in both ways. One thing I noticed was When I start recording script, under Config recorder I can see my Applet Recorder status is shown as Starting.

        Our old application was 10g EBS forms but recently our application was upgraded to 11g Fusion middle ware forms but it opens same as applet.

        Please let me know if you require any additional information from my side.

        Regards,
        Kuldeep Patil

        Reply
        • Hi Kuldeep,

          I am not sure, if you are still facing the issue, in case you want my help on this, please do drop an email at testingtools.co@gmail.com , I may have to view or access your laptop to solve the issue, it would be very difficult to solve these kind of things over a comments.

          Thank You,
          Regards,
          Srinivas P.

          Reply
  • Is there a way we can run openscript outside of OTM? is there a way i can run these oats open scripts programatically using java?

    Reply
    • Yes Triveni,

      It is quite possible, have your script invocation code in a bat file, and later you can use java to invoke the bat file. Back in the days when worked at ORACLE, one of my colleague had actually built a tool using this approach to plan execution of multiple scripts one after the other.

      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I am not able to do a PATCH operation successfully through openScript. I am using openScript for functional testing of REST APIs.

    I tried out http.post method with X-HTTP-Method-Override=PATCH header and Content-Type=multipart/form-data header as below and that did not work –
    Code –
    http.post(12, “{{db.CRUX_Config.Hostname}}/crux_api/v1/preference/”+ id, null,
    http.postdata(http.param(“languageCode”, “en_US”)),
    http.headers(http.header(“X-HTTP-Method-Override”, “PATCH”, Header.HeaderAction.Add),
    http.header(“Content-Type”, “multipart/form-data”, Header.HeaderAction.Add)),
    true, “ASCII”, “ASCII”);

    I also tried http.multipartPost method with a boundary value i got while manually doing PATCH operation through POSTMAN(from the code snippet in POSTMAN)
    Code –
    http.multipartPost(15, “{{db.CRUX_Config.Hostname}}/crux_api/v1/preference/”+ id, null,
    http.postdata(http.param(“languageCode”, “en_US”)),
    http.headers(http.header(“X-HTTP-Method-Override”, “PATCH”, Header.HeaderAction.GlobalAdd)), “—-WebKitFormBoundary7MA4YWxkTrZu0gW”);

    This also did not work for me. Do you know how to do this?

    Thanks,
    Vinitha

    Reply
    • Hi Vinitha,

      Firstly, thank you for reaching out to testingtools.co

      Could you please let me know, as which version of OATS is being used for this?
      Were you able to successfully execute a get or post call of REST APIs? if so could you please share the code once?
      When you ran the PATCH request, did you get any error in console? if so could you please share it here? it can help to diagnose ..

      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    The issue reported by me – “executing the scripts, it is throwing ‘Failed to create script service’ for the function library which we have used” got resolved by renaming the existing workspace created by OFT by closing all the open scripts in OFT. And when you launch OFT again the workspace gets created automatically. Hope the above workaround helps someone facing the same issue.

    Also, Srinivas i would like to know if there is any feature available in OFT to validate the report layout – for example if a specific value is displayed in the report at one specific location. It can be any report – PDF, XML.

    Thanks in advance.

    Regards,
    Aisha

    Reply
    • This is great, thank you for sharing the details which helped you to work.

      Second, there are some libraries available to work with reading the content of PDF..

      Reply
  • Hi Srinivas,

    Thanks for the reply.

    I am using OATS version – 12.5.0.3 Build 1012
    I could successfully execute a get and post(normal json data) via OATS with the following code –
    http.get(2, “{{db.mapi_config.vhostname}}/services/rest/connect/v1.3/contacts/{{id,2}}”, null, null, false, “ASCII”, “ASCII”);

    http.post(4, “{{db.mapi_config.vhostname}}/services/rest/connect/v1.3/contacts”, null, http.postdata(http.param(“{\r\n\”login\”:\”testloginContact\”\r\n}”)), http.headers(http.header(“Content-Type”,”application/json”, Header.HeaderAction.Modify)), false, “ASCII”, “ASCII”);

    For using these methods I am creating the script as Web/HTTP under Load Testing even though my purpose is functional testing

    PATCH code neither throw any error nor update the data. But the API is under development and the error cases are not defined yet. This is the same behavior when I run the PATCH call from POSTMAN with wrong data.

    Unlike using JSON data in body, we are sending data as form-data(key value pairs) and this is where all the trouble is I believe.

    Reply
    • So if its having the same problem when running from POSTMAN too, then the problem is that the API development code, needs to be fixed and need wait until that is taken care by developers.

      Reply
  • Hi Srinivas,

    Thank you for the reply.

    I am using OATS – Version: 12.5.0.3 Build 1012. I am creating the REST project by selecting the scripts as type Web/HTTP under Load Testing even though my purpose is to do functional testing. I believe this is the only way we have right now.

    I successfully executed a get and post call using the below code –

    http.get(2, “{{db.config.vhostname}}/services/rest/connect/v1.3/contract/{{id,2}}”, null, null, false, “ASCII”, “ASCII”);

    http.post(8,”{{db.config.vhostname}}/services/rest/connect/v1.3/contract/{{id,2}}”, null, http.postdata(http.param(“{\r\n\”login\”:\”TestLoginUpdated\”\r\n}”)),
    http.headers(http.header(“X-HTTP-Method-Override”,”PATCH”, Header.HeaderAction.Modify)), false, “ASCII”, “ASCII”);

    This patch works since the api receives data as simple json in the body. But what I require for my current project is that I have to send data as form-data(key value pairs).

    Thanks,
    Vinitha V Nair

    Reply
    • Even in the code which you shared, you are using http.param which is a key value pair, could you please elaborate on your query?

      Reply
  • Sorry for too many replies I couldn’t find them after posting.

    Reply
  • Hi Srinivas,

    We are getting Debug Source Lookup error when executing one particular childscript in OFT. Also it is observed while debugging that this error is encountered at Switch statement in the code.

    Do you have any idea on resolving this issue?

    Thanks,
    Aisha

    Reply
    • Hi Aisha,

      Not sure about this, but if you can share the code or go on a screen share, I can try my best to solve this, also please drop an email at testingtools.co@gmail.com for screen sharing or contacting on this issue or any other issue.

      thank you,
      srinivas P.

      Reply
      • Hi Srinivas,

        Thanks for your reply. However we didnot face that issue again so we can keep it aside for now.

        I am facing an issue in OTM while trying to add the scripts in Tests tab of OTM. When i click on find button in test creation window to associate the OpenScript file, OTM goes blank for certain duration and then displays ‘Unknown Exception Error’.

        Can you please help me on this??

        Thanks in advance.

        Reply
        • Ideally there should be some association between OTM and OATS repository where scripts are available, if that is not configured properly, this situation might come. May be if you can share your screen and come online, we can look in to it. Feel free to drop an email to testingtools.co@gmail.com

          Reply
  • Somebody please explain how to use calling Function Library in openScript?

    Reply
  • How to point the databank file from cli, i am using cli for triggering .jwg files.

    e.g. runscript -jwg

    Above command is working fine for me in all fresh scripts, but for old script they are not working. I have deleted the old .index & .sync file from databank and tried them with the script but somehow they still have reference to some old values/parameters etc.

    please let me know how do i pass the databank file along with the script from cli together. I am not able to find out that from the OATS CLI reference guide.

    Reply
    • e.g. runscript -jwg location_of_the_script/script.jwg . – typo corrected here

      Reply
      • Also, i am trying to configure oats scripts from Jenkins, so i am trying to find the proper cli commands. Let me know if any other way available to integrate with Jenkins. Thanks in advance!

        Reply
        • HI Rajib,

          See if this link can be helpful for you to call OATS scripts using command line. To my knowledge jenkins can call the commands.

          Please do let me know in case of any queries.

          Thank You,
          Regards,
          Srinivas P.

          Reply
    • Hi Rajib,

      One of the best ways that trigger in my mind for these kind of situations is, have a settings file or a file where all references are stored for executing scripts, so instead passing it as a parameter from command line, you need to give path in that file.

      Along with this, in your openscript’s script, you need to get the path by reading this file and use it for further script execution.

      Hope this helps.

      thank you,
      regards,
      srinivas P.

      Reply
  • Hi Vinitha/Srinivas ,

    Can you please help me in providing steps of using OATS to automate the REST API’s using POSTMAN tool and the validations of results please?

    Thanks,
    Gomzy.

    Reply
    • Hi Gomzy,

      Thank you for reaching out to us. Well in order to do that you need to do the following things.

      • Create a collection in postman
      • Share it as a file like a json.
      • Then you need to have newman installed ( for this you need node.js and npm install already, newman is a npm package )
      • You can call the shared postman collection file with newman command.
      • newman generates reports as well, so you can refer to those for the results.

      This command can be put in a bat file or you can write java code to call a command in a command line, there are several options for this. And as java can be used in OATS, you can create a library in OATS which does the calling of the command and you should be able to proceed with it.

      Please do revert to us in case of any queries.

      Thank You,
      Regards,
      Srinivas P.

      Reply
  • Hi Srinivas,

    I am using openscript for the EM pages automation for Oracle Forms. The recording goes fine , facing using with the playback. While playback , the script is not consistent, it is not picking the right navaigation target ex: forms1. what to do and is any other way for record the EM pages using openscript.

    Reply
  • Hi Shrini,

    I am facing issue in OATS while trying to work with IE11.

    Issue is in IE add On it shows Incompatible For:
    Open Script BHO and
    Oracle .OATS.OpenScript.IEToolBar.OpenScriptToolbar

    Still I tried launching browser . Browser launch is working but later it is giving error for browser.

    OpenScript

    Version: 13.2.0.1 Build 173

    Thanks
    Shraddha

    Reply
  • Hi Srinivas,

    Is there any way to get the Response Time when a query is send to the server in REST?

    Thanks
    Renjith

    Reply
    • Hi Renjith,

      There are multiple ways to get it, but it all depends on what would you do by getting that information. If it is just about knowing the information sake, there 2 ways which come on top of my mind.

      1. After the script execution, you can check the result file, which displays the amount of time spent on each instruction.
      2. You can maintain two variables, start_time & end_time and assign the current time value to these two variable, one goes before the actual API call in the script and second goes after the API call statement. difference of these two variables shall give you the amount of time went in to execution of the API call.

      Hope this helps or gives you a direction as what can be done in this regard, please do let us know if your requirement is something else, we can discuss further on that.

      Thank You,
      Regards,
      Srinivas P

      Reply
  • Hi Srini,

    I am working on P2P end to end flow. I am getting the issue when I am running the script from OTM.
    Report not generated even if the script is executed properly from start to end. Sometimes if the script is failed between the flow still report not generated.

    I am like to know what will be the reason behind that HTML report not showing.

    I have checked the otm folder and there also no file found.

    Thanks in advance 🙂

    Reply
    • It becomes little clueless sometimes as why somethings doesn’t work with OTM, there are cases where we don’t know how some things doesn’t work.

      Reply
      • Yeah, I tried with higher OATS version still the same issue. Actually, BA team is executing the script and if they can’t see anything on OTM then they are escalating this that script is not working.

        I ran the same script in Openscript then the script is running end to end with the report in viewable in Session folder.

        Can you suggest something so I can handle it in another way. I am thinking to create the HTML report by code but then OTM is useless in this scenarios.

        This is very painful issue for me and my work 🙁

        Reply
        • Yeah you could generate a HTML file while the script gets executed step by step. Only thing is you need to know where it gets saved? or send an email at the end of the script.
          There is an alternative as well, if it is viable for you to implement, try to create a small database with scripts, script steps, script runs kind of tables, as and when a step is executed you could insert success or failure to the respective tables mentioned above, so any time you want to see the status you can login to some application, which is built over these tables. you need to just go to the respective test run and you should be able to see the status. You can make many views in this as well. up to your creativity.

          Reply
  • Hi,

    I am working on one lengthy flow so the script is failing multiple time.

    How should I start script execution form failed point onwards and save time to execute from the beginning.

    Thanks
    Vivek S.

    Reply
  • Hi,

    I am working on one lengthy flow so the script is failing multiple time.

    How should I start script execution form failed point to onward and save time to execute same script from the beginning.

    Thanks
    Vivek S.

    Reply
    • That is possible only if you had stored all your important data(i.e. the data that might have got generated during the script execution and you need those values generated in the further script execution) in a persistent location where you can refer to retrieve value from there.

      So when you start the script execution in between , make sure the variables are loaded with appropriate data referring to those persistent locations. And you can either comment the unwanted script and execute it or open debug pane and select a specific line and right click to select “Run from here”

      Please do revert to me in case of any queries.

      Thank You,
      Regards,
      Srinivas P.

      Reply
  • Hi,
    OATS playback executes each line in the script one by one and we can see yellow highlighter while playing each line.

    I am working on lengthy script, if there are try catch statements in the script, while OATS playback the yellow highlighter stops at try statement and shows Running instead of executing every line in the script which is the default playback option.

    Is there any reason why the playback is not happening every line if we use loops like try catch or if statements

    Reply
  • OATS OpenScript version (Openscript v13.2.0.1 build 173) default playback executes each line in the script one by one and we can see yellow highlighter while playing each line.

    I am working on lengthy script, if there are if statments, try catch statements in the script, while OATS playback the yellow highlighter stops at if or try statement and shows Running instead of executing every line in the if or try statement script.

    Is there any reason why the playback is not happening every line if we use try catch or if statements. Screenshot attached.

    Playback stops at first statement if or try loop and says Running as shown in the screenshot.

    Reply
    • Hi Jayanth,

      Thank you for reaching out to us on this, it is a quite a good question, which many OATS users face.

      There are OATS api related statements and simple java statements that we use in OATS scripts, if the statements are direct API of OATS in that case you can see the yellow line as it is recognized by the tool, but if you want similar kind of appearance for non OATS api, it may not be possible.

      But, what you could do is, keep an info statement just before the try catch or a switch or a for loop or whatever, keep a break point on this info statement, the script pauses during the execution. Now you can bring the debug pane up and move to code view and not tree view of Open script. Select the appropriate line in Debug pane and then use the icons like step into, step out etc.. present on debug pane. You will be able to execute statements one by one.

      Hope this helps, please feel free to reach out to me in case of any other queries as well.

      Thank you,
      Regards,
      Srinivas P.

      Reply
  • Hi Srini,

    Thanks for the help, I did same means save data into excel file and the saved data in another script and it is workable for my issue.

    Thanks
    Vivek S.

    Reply
  • 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
    getting this error message when Replaying the Openscript. Change the Preferences to 300 sec. what else i am missing?

    Reply
    • Hi Amber, There are several possibilities for this issue.
      1. Incompatible OATS and Oracle EBS Forms ( JRE )
      2. Browser has not got the plugin enabled
      3. In OATS may be the correct JRE version is not selected.

      this will need some troubleshooting, ideally on a screen share would help. Please do let me know if that is possible for you

      Reply
  • Hi Srinivas,

    Can Oracle webADI (Macro) be automated using Openscript?

    If so pleaselet me know what are the JAR files that need to be added to automate them.
    Oracle WebADI: it is a macro from where another browser will be opened from excel(macro). So i’m not able to recognise this browser. I even tried adding openxml4j jarto the script.

    Kindly please help me solve this issue.

    Thanks

    Reply
  • Hi Srinivas,

    Hope you are doing well.

    My Query was I need to check the values present in EBS forms. While recording I clicked on the first row and successfully compared with CSV file. But now I need to repeat the same operation till the last row and values should be compared with CSV file.

    Thanks in advance,
    Naveen

    Reply
  • HI Team,

    I’m new to OATS. I’m a Selenium resource. I have recorded the script with record and playback. I want to run the recorded script 24hours continuously on Virtual Machine so I created the batch file and scheduled it in Windows scheduler on VM. The problem I’m facing is when i lock the windows screen the batch file stops working ? can anyone suggest me any solution for it.

    Another issue I’m facing is when i try to run the script for 5 iterations then the script runs only for first iterations and then it gets failed for rest iterations?

    I am using Windows 10 Virtual Machine with open script 13.3 version.

    Reply
    • Are you using Iterate run or Simple run to execute the scripts? if you use only simple run the script runs for only one iteration, it is expected only.

      Reply
  • HI Team,

    Im new to OATS. Im a Selenium resource. I recorded the script in openscript and created the batch file of it to run the script directly.
    I want to run this batch for 24 hrs continously so i tried it with windows scheduler but when the system is locked the script doesn’t work. is there any workaround for it?

    Reply
    • Yeah some of the APIs may not work when machine is locked, so it may not be possible for script to run properly. One of the work around would be to not lock the machine where scripts are running. Also you cannot capture images when machine is locked.

      Reply
  • Hi Sriniwas,

    I am running scripts in my remote desktop connection for client, but whenever i am locking my system for nightly batch run in open script, scripts are passing but screenshots are coming as black, and no details are visible.

    Could you please help with the issue.

    Server: Windows Server 2012 R2 Standard
    64 bit
    Open script version: Version 12.5.0.3 Build 2012

    Reply
    • Hi Rishabh,
      Firstly, thank you for reaching out to us, but as discussed with you over whatsapp, it may not be possible to take a screen shot if the remote desktop is locked.

      Reply
  • how can i print personalized message when script execution failed?

    Reply
    • Option 1:
      Whenever script fails, it would first go to the finish() method, there you can print what ever custom message you want to print.
      Option 2:
      You can keep your error-prone code with try catch block and when it comes to catch block, you can print desired custom message

      Hope this is helpful

      Reply
  • Hi Srinivas,

    I am very new to OATS tool and we are going to use this for an Oracle upgrade project.To get ready for testing,I installed OATS oats-win64-full-13.3.0.1.262 and tried to record an oracle form with a simple transaction.Though I could see that opening form and performing a transactions are recorded,but when I playback it does not capture and it just stops till prior to launching the form.

    Launched the application in FF and performed a transaction in system but could not play the same in OAT
    Win 10 an Java 8 are installed.
    please help

    Reply
    • Hi Smruthi,

      Thank you for reaching out to us, I have a few clarifications, did you record the script in FireFox only? if so which firefox version was used?
      Or if you have recorded using another browser and now trying to execute in firefox, I would recommend you to check the following and let me know your observations.
      1. Check if you are using compatible FireFox version? – You can refer to OATS Compatibility Matrix page for more details.
      2. Also please check the steps for firefox if the extension is enabled in firefox browser or not.

      Once i receive these details, I can give any further directions.

      Reply
  • Hi Srinivas,

    Thank you for your immediate reply.I have initially uninstalled the existing version ie 46 and installed lower version as with the new version i.e 46,i get a message ‘OpenScript WebDom could not be verified for use in FF and has been disabled.

    But as the lower version ie.36 is not compatible,I just installed version 46 but could not add the Addons.Please help

    Reply
    • Hi Smruthi,

      Could you please confirm the following?

      1. On which browser did you perform the script recording? along with the browser version.
      2. For firefox are you using ESR version or not? if not please refer to this location and download the required ESR version of Firefox.

      Reply
  • Hi Srinivas,

    I was initially under the Lower version i,e 36 where all the Addon related to Openscript were enabled.But as you suggested,I have now uninstalled the existing version and installed 45.0.2 version but the it says openscript WebDom could not be verified.However ,I still tried to run Diagnostic script which failed only for IE but nothing for FF and i could still able to record all including the transactions but when we play back,it just stops in opening the form and hence does not show any transactions done/recorded.

    I found that during recording,when the java applet opens up it throws the below error
    Exception in thread “Thread-2” java.awt.AWTError: Assistive Technology not found: “oracle.oats.scripting.modules.formsApplet.helper.observer.FormsInitiator”
    at java.awt.Toolkit.loadAssistiveTechnologies(Unknown Source)
    at java.awt.Toolkit.getDefaultToolkit(Unknown Source)
    at com.sun.deploy.uitoolkit.impl.awt.UIToolkitImpl.warmup(Unknown Source)
    at com.sun.deploy.uitoolkit.DelegatingPluginUIToolkit.warmup(Unknown Source)
    at sun.plugin2.main.client.PluginMain$1.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

    I guess,we need to get that Addon enabled but not sure how to enable it as I dont see any option with version 46

    Reply
    • If you are running on firefox, is it ESR version?

      Can you share some screenshot of firefix addon through whatsapp 9885809854

      Reply
  • I have done that Srinivas.Kindly have a check and let me know if you need anything else

    Reply
  • Hi Srinivas
    When I am executing my scripts and in between if the machine is locked my scripts are failing. Can you please suggest a workaround for this issue

    Reply
    • Hi Kumar,

      Thank you for reaching out to us. Yes you might see this issue and unfortunately may not be possible to solve. Especially in the cases when there are keyboard shortcuts or mouse movement interactions kind of actions are performed.
      But if you are using OATS for testing of Oracle EBS application I do not see at what situation this might occur.

      I would like you to do the following, you should do some analysis, try to execute same script which is failing when screen gets locked. Run it multiple times with screen locked and observe if its failing at the same place or is it random? to my knowledge it should be consistent. If it is consistent do let us know where exactly its failing and then we can further debug and take it forward.

      Even if its random, let us know in which situations its failing, so that we can take it forward to further analysis

      Reply
  • Thanks for your reply Srinivas!!

    I am using openscript for Oracle EBS.
    EBS forms are working fine when screen is locked, but UI related are failing (i.e) logging into EBS and navigation through responsibilities

    Reply
    • I am not sure about this might need more details, there were cases where it does not take screenshots when screens are locked but not failing the scripts.

      Reply
  • Hi Srinivas,
    I am trying connect to OTM by configuring first OATS Database configuration window.
    Any article on how can we up OTM, will be of great help.
    Thanks

    Reply
  • Hi Srinivas,

    Hope you are doing well.

    I am new to open script . I am trying to record a Oracle form but I am having issue .
    Till the web part it is recording fine after opening the Oracle form openscript is not recording the forms .

    I am using below configuration.
    OATS -13.3.0.1 , JRE -1.8.0_201, WIndows 10-64 bit.

    Thanks in advance.

    Reply
  • I have one more query , currently I am not running as an admin, shall I run as an admin everytime ?
    Thanks

    Reply
  • Hi Srinivas,
    Weare looking to integrate OATS with Jenkins. Can you please share some reference links for the same.

    Reply
    • I don’t think there is a direct way to acheive this. It involves some additional research especially as how to trigger bat file on remote windows machine in the Jenkins job. Once you acheive this, you can use OATS related command line utility to execute the scripts.
      I hope this gives you some direction as how to proceed.

      Reply
  • Hi Srinivas ,

    I want to know about reporting system for open script functional Testing. Can we use 3d party tools like Extent report instead of default reporting features. Could you please tell me how to use .

    Reply
    • I think it should be possible to add 3rd party jars like extent report and generate the reports. You need to add the extent report related jars to “Assets” tab and then you can use appropriate methods for generating the extent reports.

      Reply
  • Hi,

    What version of OATS should I install for EBS 12.1.3?

    Thanks,
    Andreea

    Reply
  • Hi Srinivas,

    I am recording script for Oracle forms using OpenScript.But unable to record the web page for the same script.

    Scenario is :

    We have Oracle forms application in which on click of some button , a new web page browser opens up and on performing some operation on that page , the details will get reflected on the Oracle forms.

    Problem is :

    Recording is perfect for oracle forms but as soon as the browser open , OpenScript is unable to record the browser operations.

    We have created a script of EBS/Forms type in OpenScript.

    Is there any setting/configuration required to work with forms and web browsers in single script?

    Please guide and help.

    Thanks,
    Prashant

    Reply
    • Ideally it should work, just see if you can launch the OATS tool with Run As Administrator option and try to record, also may I know in which version of OATS are you getting this difficulty?

      Reply
  • Hi,

    I am trying to run OATS script from Jenkins.
    The script is running successfully but the runScript.bat file is returning a non-zero return code due to which the Jenkins job is failing.
    Any idea why the batch file is returning a non-zero return code(in my case its 1) even when the script is successfully executed?

    Reply
  • Hi,

    Can we do load test for oracle 12.2.1.3 version forms using openscript(13.1.0.1).

    On playback getting 500 server error as shown below,

    http://host:port/forms/lservlet/sessionperf;jsessionid=123?ifcmd=regFile=default.dat Failed Invalid HTTP response code: 500 Internal Server Error ,

    Reply
    • I am not an expert in oracle load testing, but if it says its compatible in the user guide then it should be supporting for sure.

      Reply
  • Hi Srinivas,

    We are able to record the oracle form actions in Openscript and respective java code also generated .But while playback oracle forms are not opening .Could you please help us to resolve this issue.

    Ebs 12.1.3
    Openscript 13.3.0.1
    Java 1.8

    Reply
    • There can be multiple reasons for this to happen.
      a) First we need to understand if the recorded code is actually correct code.
      if you are getting forms. kind of API, then it recorded properly and if it recorded in this fashion ideally it should not cause issue during play back.
      b) Second thing there might be JRE clashes between the Oracle EBS supported and what is OATS supporting. If we are using a different Java version for OATs and that is not the actual one in Oracle EBS, it can cause this issue, so you need to work with your Oracle EBS team and make sure the JRE version is same as what is used for OATS as well.

      These are the things which come on top of my mind for the issue that you are facing.

      Reply
  • Hi Srinivas,

    Advance Thanks !!

    Scenario :
    1) I check in OATS code in GIT HUB repo.
    2) I want to clone above code and run same from Jenkins , it is possible ?
    Please help me how to achieve it . Thanks in advance !!

    One more last question . Like Selenium Gird ,In OATS have any feature like that??

    Reply
    • Well it can be achieved but not a simple way to do it.

      a) sometimes the Jenkins and OATS should be installed in same place if you want to trigger from Jenkins
      b) Or you need to write a web service which can call OATS code in another machine , which will be further called in jenkins
      We implemented in one of the company where I was product manager.

      c) There is no direct grid possibility but there is something called Oracle Test Manager, where we can add Nodes with OATS installed and then we can trigger from OTM ( Oracle Test Manager ) and those will be executed in those nodes in parallel. But it can be complex to associate nodes to OTM and get everything working as expected

      Reply
  • Hi Srinivas,

    Thank you so much for all your efforts you put in this blog.

    I started learning OATS but have some queries.
    How to run multiple test cases in a sequential way? Lets say i have 100 scripts. Is there a way to click run and test execution goes one by one without manual intervention. How to achieve this?

    Reply
  • Hi Srinivas,

    I am facing below 2 issues while using openscript for automation of oracle afd applications.

    1. for 1 function library every time we get MANIFEST.MF error. we tried creating new lib with some different name but it worked only once and because of this issue automation gets stops in-between abruptly.

    2. we have 2 iteration to run our automation in 1st iteration what all scripts are failed will be picked up in 2nd iteration, while going in the 2nd iteration it gives ‘script servive exception’

    Can you please help me to resolve this issue, I am literally stuck wit this.

    Thanks in advance!

    Reply
    • I may be able to provide any help over a screen share. As this is not a generally occurred issue. Do let me know if you are ok to do a screen share. and i can try my best

      Reply
  • Hi Srinivas,

    I am using Openscript trial version for demonstrating poc.
    currently I am using openscript – 13.3.0.1.242

    My application specifications:
    oracle EBS/Forms
    java 1.8 32 bits
    works only in IE
    It user oracle 12 c as db

    could you please assist me on this?

    Reply
    • Sorry for the delay in response, I hope you were able to successfully complete your POC. In case you need any further help, please feel free to drop a whatsapp message. My Number is present on the website

      Reply
  • Hi Srinivas,

    When I navigate to a web page (Forms->Export) from forms, a new browser is being opened which is asking for login and that browser is not getting identified by OpenScript.

    Can you please help me to identify the browser / let me know if there is any workaround for this.

    Note : We already had a browser opened by OpenScript .Objects in this browser are getting recorded , but not on the new browser opened from Forms.

    Browser: Chrome
    OATS Version: 13.3.0.1 Build 262

    Thanks!

    Reply
    • If you are facing this issue while recording, there will be a globe icon in your IDE, go and select the latest browser in that globe and then try to record it might start recording.
      Ideally you should not face issue when playing back the script though, as long as your xpaths and attributes and values are properly given.

      Reply

Leave a Reply

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