If you need to gather details about the installed modules, product installation statuses, and configurations, you can leverage the following SQL utility.
The Query
sqlplus apps/<apps_pw>@AD_TOP/sql/adutconf.sql
Why use this
This script particularly using for during:
- Upgrades: Ensure all modules are dependencies are installed correctly.
- System Diagostics: Verity the product version and statues when trubleshooting
