You need Oracle Dependencies Analyzer to...

migrate Oracle Forms to APEX

look for an object's(table,view,package) program code reference

find the dependency information of tables/views

browse DB objects usage in Oracle Form

foresee a table changing effect on other objects

The Oracle Dependencies Analyzer(OraDep in the past) - The unique tool looks for database object dependency in program code.
It may be tables, views, PL/SQL packages and procedures in Oracle database or Forms/Reports.

The ODA gathers the program code and the objects' metadata and, after a code parsing, builds object dependencies tree.
This allows you to give one answer for multiple platforms used in the company.
The ODA is kind of reverse engineering, impact analysis tools.

You see here an answer to the question "Where's the RM_CLIENT_ARRNG table used?".
The table is used in Oracle forms Table usage in Oracle form

The RM_CLIENT_ARRNG table is used in UNION_CLIENT_PKG package body in one procedure GET_MARK_DETAILS for "select".
The ODA shows one procedure only. Other 18 program units of UNION_CLIENT_PKG package don't have usage of this table.

There's a consolidated table of DML operators and %ROWTYPE, %TYPE the table dependency.
You can see an accurate type of DML statement and the statement itself.

The ODA shows multi-level dependencies, two direction dependencies, Informatica dependencies etc. in Presentation>Screenshots

Forms Dependency Analysis
A database object usage in Oracle*Forms

A dependency analyzer gives you the opportunity to see a table or any other database object usage in Oracle*Forms.
Where, in what triggers/block/program unit, and most importantly, how the database object used. It's looking for the table reference in forms and reports.

Impact analysis and refactoring
What's your changes result of?

Do you want to change a table or to add a parameter into procedure? What's the result of these changes? What are programs must be changed? What are oracle forms must be recompiled? What does code make CRUD of the table.

Table usage and its relationship
Oracle table dependency tree

A program code analyzing enables to show the table usage, to sign DML statements and to present them in a compact table. The object dependency analyzer is looking for a table reference in PL/SQL programs, Informatica workflows, text files.

Reverse engineering
What's an object dependency hierarchy?

Everyone knows such cases: an application was written for a long time, perhaps, its creators have already retired, you need to understand how it all works. Or you want to create an application on another platform, convert it from forms to Java Spring, for example. The ODA provides an understanding of the interaction of code and data in the database.

The ODA is a search engine
The accumulated projects like Internet heterogeneous sites

What are Google, Yahoo, and other search engines? A finder is needed where a logical structure doesn't exist, that requires a robot that will bypass all sites and gather information. Then, the search engine will be able to answer the questions of the user. The Oracle object Dependencies Analyzer is a search engine for the company's software. The ODA gathers the code (written on different platforms) and puts it in its repository. The ODA is the answer for the search of oracle object dependencies in Oracle Forms, PL/SQL stored procedures, Word documents, Informatica processes.

Legacy code
Look for object dependencies in several projects written on different platforms

During the life, companies accumulate projects written by different developers in different languages, with unequal applied harmonized standards, or new trends in programming. The main thing is that this software works with a database and that data - this is a common place that allows us to give one answer to all projects.

The ODA and Oracle Applications ERP
Research relations and in really big applications

ERP Oracle Applications is an application has hundreds of thousands of objects and to understand their relationship is a very difficult task. The ODA can load the Oracle Applications metadata into its repository, to explore it and after this, one shows object dependency view.

Informatica reverse engineering
Search the workflow and database objects dependency

The ODA provides an answer to this question: "How and where to use database objects?" That is to say that the workflow takes the data from this table, put them in such table, this table used in the lookup or expression, in the pre/post SQL mapping/session. Conversely, it is possible to know how to use the table in which mapping/mapplet/session/worklet/workflow.

The ODA browsers
The ODA has a personal browser for each kind of objects

  • Oracle tables
  • PL/SQL program(DB and forms/reports)
  • Oracle Forms/Reports
  • Informatica workflow
  • Starteam
  • Word documents
  • Any flat text files