It is strange some times, that Oracle Application Testing Suite identifies Oracle EBS Forms objects with VTextField instead of the actual name attributes, people get crazy when this happens and they wouldn’t be able to fix it, unless they know that they need to set a value for a profile “ICX: Forms Launcher”.
Remember that, these steps need to be performed only if you observe that Oracle EBS Forms objects are identified something like VTextField, which otherwise I strongly recommend you to look out what could be the various possibilities, or you can still reach out to us.
Following steps lets Oracle Application Testing suite identify the Oracle EBS Forms objects the right way:
- Login to Oracle EBS application manually, make sure the logged in user has “System Administrator” responsibility
- Navigate to set profile values using the following navigation: System Administrator > Profile > System
- Search with string like %ICX%Forms%Launcher% , the profile would be found , now you can set the value at site level so that it reflects every where.
- Basically you need to append following string to existing value, and string is ?play=&record=names
- Save the profile value , exit Oracle EBS applications and launch again.
- Next when you record using Oracle Application Testing suite, it should work like a charm.
- In case it still doesn’t work you need to get the instance bounced 🙂 to get the profile values reflecting.
This all started from a small scenario that occurred recently: Here it goes:
Recently one of my blog reader had faced an interesting problem. In the company where she worked they had a quite a number of test automation scripts which were developed to automate Oracle EBS Forms 10g, later when their customer had upgraded to Oracle EBS Forms 12c , the same scripts weren’t working. Knowing that I had worked on test automation of Oracle EBS Applications with Oracle Applications Testing suite for more than 5 years, she had reached out to me for help. That is when i started asking for various possibilities, I discovered that Oracle Application Testing suite was identifying Oracle EBS forms 12c, but with name attribute value as VTextField. It striked me just then, that we had to set a specific value to make Oracle Application Testing Suite recognize the forms objects the right way.
I hope this helps you and saves your time in troubleshooting to fix it. 🙂
Thanks much Srinivas…
I am glad that we are of help o you 🙂 continue reading, posting queries and share with your other friends 🙂 too
Hi Srinivas, thanks for sharing this solution with us.
In my case, I cannot login to Oracle EBS application as System Administrator due to restrictions. Is there any workaround/function to get the VTextField from the attribute name ? How can I easily get the VTextField of an Oracle Forms 12c Item ? Much appreciated.
Regards,
Rami
Only other option which i see is, you need to ask your Support team to do it for you, i.e. who have the access to that responsibility . There might be other reasons like the JRE version enabled in OATS and the JRE Version used by apps to launch forms should match too. kindly check if that is the case, you may have to fix that as well, if this is fine, only option left is the one i mentioned earlier.
Hi Srinivas, thanks for sharing this solution with us.
In my case, I cannot login to Oracle EBS application as System Administrator due to restrictions. Is there any workaround/function to get the VTextField from the attribute name ? How can I easily get the VTextField of an Oracle Forms 12c Item ? Much appreciated.
Regards,
Rami
unfortunately no
Hi Srinivas
You need to update the configuration file and make the same changes you mentioned i.e record=names. Even we faced the same issue we made changes in the cfg file or configuration file and restarted the manage server.
Regards
Gopal
Hi Gopal,
Thank you for sharing your insights, but could you let us know more details of the configuration file, that is the name of the file and where is it located and who would be able to update this file etc?
Thank You,
Regards,
srinivas p
Hi Srinivas,
I have been following your blogs.Thanks and keep blogging more.
I am automating oracle EBS applications in OATS. Till now I automated for web pages but now I need to automate Oracle forms for invoices. While creating the script I selected “Oracle EBS/Forms ” and tried to record.
1. Initially, a web page opens up in browser for login credential and enters home page. This recording happened normally.
2. But after that, I clicked on “Batch Invoices” link in the home page. Clicking on this link will opens up the oracle forms, where we need to enter invoice details and payments and all.
3.Problem I am facing is while recording,clicking on “Batch Invoices” link is not opening oracle forms. It shows error as “Unable to launch the application”. If I stop recording and click on that link, it will opens up.
4. I am not getting how to record the forms. I also tried to do inspect but still those forms are not identifying.
5. I have Openscript Version: 13.2.0.1 Build 173 and Java version “1.8.0_171”. This is a live project I need to complete it as soon as possible. Please help me to sort this problem.
Thanks.
Hi Radhika,
Yes it is expected to get this kind of issues, when working with OATS, but there are ways to solve them as well.
Make sure the following prerequisites are met:
Even if it doesn’t work, you need to perform following steps:
Understand even for the above steps to work, the prerequisites mentioned should be valid.
If you still continue to face issues, we can go on a screen share and then try to get it resolved. you can reach out to me at testingtools.co@gmail.com
Please do revert to me in case of any queries.
Thank You,
Regards,
Srinivas P.
Hi Srinivas,
According to the prerequisites you mentioned,
1) I trying to automate oracle 11i forms. And I have OATS 13.2 version. I hope their is no compatibility issue since I have latest OATS tool.
2) I did not get the 2nd prerequisite. How to check the correct java version is selected in the OATS tool.
Thanks in advance.
Hi Srinivas,
Actually as you suggested I cleaned the java cache and also checked the compatibility of forms and openscript.
One more thing I did is, we have to go for
Tools -> Manage EBS/Forms Automation -> and needs to check the JRE is selected and Automation is enabled. It was disabled in my case ,after enable now I am able to record the forms 🙂
Thanks for your support and kind nature 🙂
Thats great you ot the 2nd prequisite also enabled and there you go.. happy to know that yor issue is resolved now 🙂
Have a good day, pls reach out in case of any further queries
I think this issue is resolved post discussion over phone call. thanks for reaching out to us.
Hi Srinivas P,
Thanks for resolving doubts of everyone.
I have question here, we have installed OATS, currently we are trying to submit concurrent program from Oracle EBS, but how to check the status automatically via script?
Our aim is to submit as many different concurrent programs in EBS sequentially if earlier one is successful with status/phase code=C else stop at there itself.
Can we achieve this through OATS?
Regards,
Sumit
Hi Sumit,
Thank you for reaching out to us, yes it is very well possible to do it in OATS. In case you are using Oracle Flow Builder, the methods would be available already, you need to just use them in your script.
In case you are not, you may have to write a method, which keeps on clicking the “Refresh” button until the status changes to “Completed” and once it changes to “Completed” you can get the value from the other column and see if its Normal / Failed / etc..
Please do revert to me in case of any further queries