Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Forms Automated Testsystem with Forms Technology and PL/SQL only

FCHFeb 24 2021 — edited Feb 24 2021

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?

This post has been answered by FCH on Aug 25 2021
Jump to Answer

Comments

Processing

Post Details

Added on Feb 24 2021
6 comments
641 views