Friday, August 3, 2007 APPL_TOP Part -I
There is only one APLL_TOP for every Oracle Application Database. APPL_TOP directory contains product files & directories, core technology files & directories, consolidated environment file (APPS.env) & main application environment file (.env). Core Technology Directories – (admin, ad, au and fnd directories) APPL_TOP/admin – it contains files and scripts used by AD utilities during upgrade and maintenance. APLL_TOP/admin/ - it contains subdirectories like „log‟, „out‟, „restart‟ containg log, output and restart file used by AD upgrade. APPL_TOP/admin/preupg – it contains product specific pre upgrade scripts. APPL_TOP/admin/adovars.env – it is an enviroemnt file that sets the environment variables, directories and file locations. APPL_TOP/admin/ - It is called Application context file or generally we called it XML file. It contains all the information required to configure the oracle application 11i. It is most important file in 11i. AU_TOP- It contains product files that are consolidated in a single location. AU_TOP/forms/US – It contains forms of all products with “.fmb” (source code). AU_TOP/reports/US- It contains reports of all products with “.rdf” format. AU_TOP/resource-It contains libraries used by forms. AU_TOP/plsql- It contain plsql libraries used by reports. AU/TOP/java- It contains copy of „java‟ files used by Jinitiator. AD_TOP – It contains installation and maintenance utilities known as AD utilities like AD admin, Auto Patch, etc . AD_TOP/bin-It contains all the executable of all AD utilities. AD_TOP/admin-It contains directories like driver, import, odf, sql, and template. Used for AD upgradation. FND_TOP- This is one of the imp. Directory that contains programs and scripts used to build data dictionaries, „c‟ object libraries and forms for all Application products. It also contains fnd.env environment file called by main environment file FND_TOP/secure – It contains data base connection file (.dbc) that is used for authentication process. FND_TOP/usrxit- It contains „devenv.env‟ file . APPL_TOP/ (PROD) - It is the top most directory of each product. Admin: APPL_TOP/admin – It contains product specific files. These files are used by the Auto upgrade. APPL_TOP/admin/driver – It contains .drv files which is used to control the auto upgrade phases. APPL_TOP/admin/import – Files in this directory are used to upgrade seed data.
APPL_TOP/admin/sql – sql scripts are stored here and used to upgrade data. APPL_TOP/admin/Odf – It contains .odf files (Object description file) that is used to created database objects like tables, , columns, indexes, etc. APPL_TOP/admin/template – It contains .tmp files. Other sub Directories under product top are: Bin – It contains the executables of each products. Html- It contains jsp files, html, java scripts. Java – It contains java dependency files and jar files. Lib – It contains files that are used to relink concurrent programs with Oracle server libraries. Log – It contains „.req‟ files (log files for concurrent process) and „.mgr‟ (master log files for concurrent manager). Media – It contains files (.gif) that are used to display graphics and text. Mesg – It contains binary files that are used in run time (.msb) and also the language specific files.