One Stop Oracle Standard Script to find all the Oralce Applications Product related details
In AD Top we have script by name adutconf.sql ($AD_TOP/sql/adutconf.sql) file which gives
Product Group Information
Multi-Org enabled or not
Existing Operating Units
Multi-Currency enabled or not
Registered ORACLE Schemas
Product Installation Status, Version Info and Patch Level
Product Database Configuration
Localization Module Information
Registered Data Groups
Base language and other Installed languages
Replication Package Installed or not
How to run this script.
1. Login to application tier
2. source the applications env
3. cd $AD_TOP/sql
4. login to apps schema through sqlplus
sqlplus apps @adutconf.sql
###~~~## it will prompt for apps password provide apps password.
the output will be generated in $AD_TOP/sql folder itself as adutconf.lst
Make use of it...This will be useful for most of you....