Forum Stats

  • 3,874,426 Users
  • 2,266,734 Discussions


Database Object Dependency Report removed in Apex 20.2 !!!

Runrig Member Posts: 257 Blue Ribbon

From the Documentation….

4.1.14 Database Object Dependencies Utility Removed

The app-level utility "Database Object Dependecies" is removed from this release because the dependency report omitted many of the new attributes for functionality in recent releases and gave an incomplete assessment of the objects used in your app.

Oracle may update this functionality in a future release.

So my question is how do I find which pages in my application use a specific object, so that I can do an impact analysis ?

Best Answer

  • fac586
    fac586 Senior Technical Architect Member Posts: 21,460 Red Diamond

    I did try the PL/SQL but got nothing returned for my application 100 and an object I know is used in Interactive Reports within a subselect. Other than that it work fine as long as the object is not pl/sql with a subselect

    The fact that query is 10 years old and was developed in APEX 3.0 before Interactive Reports existed might have something to do with that. The link to that thread was posted as an indication of what is possible using the metadata exposed in the APEX views rather than being intended as a plug-and-play replacement for the Database Object Dependencies utility.