Dependencies PL / SQL, and FORMS

[Renato Menezes Viana]

Personnel:

The tables all_dependencies, public_dependency, all_objects and others make it possible to verify various levels of dependence.

I believe that all of them only inform dependence of procedures cataloged in the BD, that is, those of ALL_PROCEDURES.

I ask where all dependencies of Oracle Forms applications are recorded?

That tree of a forms application demonstrating your dependencies get stored where in BD Oracle?

So an application forms access which tables, which procedures, which FUNCTIONS, calls for other FORMS applications?

I put in the wrong place the question, but the dependencies also end up in any wrong table?

Renato Viana

[dr_gori]

Topic moved to Oracle Forms.
Well, there is no table in Oracle that shows the dependencies of the forms.
This is a problem.
I'vê seen companies make a "Mutirão" to do this analysis. That is, open one by one and check which tables and other objects were used.

[Renato Menezes Viana]

Cacilda!

Do you want Triad Systems (UNIFY) with those Forms 6 migration applications for the most current versions do you know these tables and secret formats of Forms?

If you know, you will not talk right?

I will continue in the survey.

ABS

[dr_gori]

Well, you can try to do the following:
* Export the forms to text
* Try to find within the text the references of tables you need.

This is possible if you create a list of all objects of the bank + tables + synonyms + views, etc.
AI you are looking within the text to use these objects.

is well manual, but I think it is easier to open one by one and simply look. (The good old way of Grandpa)

[Renato Menezes Viana]

Gori: No Forms 6 What are the steps in the menu after opening the .fmb file to have the text file?

[dr_gori]

Vaie Menu File / Converert / Form / Direction Binary-to-Text
Then simply choose the FMB file that wants to convert and click Convert.

It will generate an FMT file with the same name. This file is forms in text format.
: -O

[Renato Menezes Viana]

Gori:

With the Forms open with the FMB that you want to get the objects in use, I believe the best shape is Menu File / Administration / Object List Report.

A text file will be generated with the same identification as your FMB, so for example, source001.fmb generates source001.txt (attention overlapping TXT generated without any questions).

abs,

[Renato Menezes Viana]

Includes image correctly?
[IMG https://drive.google.com/?tab=mo&authus ... UlxWXZOQ1E[/img]

[Renato Menezes Viana]

Gori: I attached the public link from the document how to ensure impact analysis and trace:


I will also attach the files from the XREF.SQL and CREATE CREATE from XRF_DEPENDENES and CREATE da XRF_OWNERS Just an Owner column.

I'm waiting for a good place.

abs,

[dr_gori]

Very good! :-O

[Renato Menezes Viana]

Gori: You know a way to automate the task of picking each .fmb, open, go to the file / administration / object list report, to generate the corresponding .txt

already thought something around of 400 .fmb and make one by one? There is a way?

abs,

[dr_gori]

Try to use Forms_Doc = YES on the command line!

Select all

frmcmp module=myform1.fmb module_type=form logon=no batch=yes forms_doc=yes

[Renato Menezes Viana]

Gori: The suggestion of the use of the CMPFMB is very good, but sometimes, as is my case, the development environment is Windows and execution even is UNIX ("true" compilation occurs in UNIX).

In this way the sets of libraries and BD connections sometimes create a very specific development environment and in this case for "documentation" Object List Report Generation (.txt) should be Generated in Windows, where fonts (.fmb) are preferably placed in the station that is making "documentation" and respective libraries to optimize processing time and ensure the moment of the "version of the documentation".

The output was automated via Excel (SendKey) running Forms Builder (Time 5 seconds for each generation).

I attached the Excel spreadsheet with the macro responsible for the process.

My Windows 7 64-bit Environment, Excel 2010 (14.0.7106.5003 - 32 bits), Forms (32 bits - 10.1.2.3.0).

[stcoutinho]

Guys,

I came across a "Forms Freewer Documenter." I do not know if it is good, but it generates HTML reports of the analyzed forms even dependencies.

It may be useful for analyzing forms to be customized, or even generate an "online website" of forms documentation. The only requirement would be to have Oracle Forms installed on the machine.

Follow the link and other details:

Foreedoclet http://foredoclet.sourceforge.net/produ ... /index.htm)

Hugs,

Sergio Coutinho

[Renato Menezes Viana]

Coutinho: very nice even the "java" documentator for forms pl / sql !!!!

I am attaching a new version of the "automating forms generation object report", after all it is important that if it is said that the forms should be in the Portuguese version (Alt Keys menu) and in this new version works for Forms 10 and 6 (asks the beginning of the version).

I will continue my "documentation" project based on the Impact Analysis and Tracking Line, according to the document in this forum.

Hugs.

[Renato Menezes Viana]

Personal: Version 3 of automates, correcting SIM / does not consider subdirectories.

ABS, Renato

[Renato Menezes Viana]

Personnel: All material required is in the topic below:
http://en.glufke.net/oracle/viewtopic.php?f=2&t=9849
Do not forget that it is necessary to read the public information document.

ABS, Renato Viana https://br.linkedin.com/pub/renato-mene ... 35/573/11b