DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, October 3, 2012

Oracle Standard Script to find all the Oralce Applications Product related details


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 Applications
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
NLS Settings
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....

Yours
Narasimha Rao

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.