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....

Narasimha Rao

1 comment:

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.