Hi All,
we had this discussion a long time ago. I have a customer that needs to provide an automated testsystem by a government requirement. All the tools on the market I have analysed so far (Auratest, Smartbear, Loadrunner, ORACLE ATS) work by recording sessions and replay with some options of modification. I have talked with a couple of managers that run large Forms solutions and they confessed, that they need a test system but were not able to reach the requirements. Some test the application covering 10-15% with UTPLSQL but need a do a huge effort for this. Insurance companies started with some tools mentioned above but were not able to cover it because of the complexity.
As I go more and more into Forms "NOCODE" solutions I trust in the very fast Buildins in Forms that allow to read the values of various items and change them in a couple of milliseconds.
My Idea is to record sessions in Forms during a live user session into the database and make them to replay later. To read prompts and items and values out of Forms into the database and get values and workflows database driven. Goal is a minimum work for the test management and a high performance.
In my case I calculated at least 50.000 testcases for 475 modules. It is impossible to record this testcases hand by hand. I believe in the extremly fast C program on the serverside (frmweb) and the unbeatable speed to access the DB via SQLNET. In former test cases I was surprised by the the speed of loops and screen automation within forms. Changing a complete block with 40 items (Prompts, toolstips, values, position) was performed in 2 roundtrips (20ms).
Before I start with a POC here the question:
Did anyone do a solution like this before or heard from a large Forms customer that does mass tests with Oracle Forms? Are there solutions like this on the market (Forms+Database only) - and are there experiences and known limitations?
I want to start Forms with a testing parameter and start the testautomation with Formspackages and Formsbuildins within Forms and write all test results into a db test repository.
Any comments or hints would be very welcome!!
warm regards,
Frank
@michael-ferrante-oracle at the time you worked for the NASA - did they have a testsystem for their Forms applications? Do you know of a test system that ORACLE uses for their own EBS Forms solution?