We are curretly looking at tools available to do impact analysis in Oracle Forms and Reports. This is for the maintainance of a large Oracle application developed using forms and reports 10g. We use Oracle Designer but only to maintain the db structure and not for forms and reports generation. Our intension is to find out the impact of db model changes, stored procedure changes in Oracle Forms and Reports. Please suggest any tools that are currently used for this purpose.
I remember manually maintaining the CRUD matrix for Oracle Forms and Reports for maintainance purpose. CRUD matrix will have the list of all the tables which are affected by the module. But this is a manual activity and hence the responsibility is with the dev team to keep the document updated. Please suggest if there is any alternative to this way which can be more effecient and less error prone...
I also wonder how these are done in Oracle ERP? how the apps team in oracle is maintaining the forms and reports?
Thnaks in Advance
Thanks for your responses. I have checked the website and found that they could be useful. I am yet to do a full analysis but looks like it is possible, btw is this tool also compares different fmbs and lists the difference?
as far as I remember (we don't use it any more) CAST doesn't show differences between forms.
If you only want to analyze forms CAST might be an overkill as it is quite expensive and the main focus is on reporting code quality management etc.
Quest (the makers of TOAD) have a tool called SQL Impact which gathers data from forms, reports, triggers, packages etc.
FormsMate is a simple, cheap alternative for comparing or searching in forms.
Alternatively, you can export forms to xml (with iff2xml90.bat) and reports to jsp (with rwconverter) and simply grep those and your sql scripts. There are grep tools for windows if you need.
My name is Jason Marra and I work for PITSS. Our tool PITSS.CON can definitely do an impact analysis for all of your Oracle Forms and Reports. I am not sure if you have got into contact with us yet, but please give me a call at (248) 524-0328 or email email@example.com. I would love to help you out.