R12 and R11i Product top decoded Part 2



Last updated on November 23rd, 2015 at 09:28 am

R12 and R11i Product top decoded Part 2

We have already learned directory structure
Now its turn to do deep dive into individual directories
ADMIN directory explained

Admin directory contains following folder.
driver :  AutoInstall driver files (.drv) tell AutoInstall what to do.
import : Import files (.dat and .dmp), DataMerge files (.ctl, .dat, and .exp), and Applications loader files (.slt, .plt, .vlt, .clt, .msg, .wft,.jlt) are used to install seed data.
odf : Object description files (.odf) are used to create the tables and other database objects like seq,index etc
sql : SQL scripts (.sql) and PL/SQL scripts (.sql, .pls and .plb) are used to create objects and install and upgrade data.
template: Autoconfig template for various Product configuration file are stored there
driver directory decoded
it contains Phase driver files that tell AutoInstall what to do during each step of the installation/upgrade process.The installation process is broken up into several phases. AutoInstall completes one phase for every product before moving on to the next phase.
Example filenames are
Explained using “ Module” as Example  ( The files xxseq.drv, xxplb.drv, xxfile.drv and xxdep.drv can be found under $XX_TOP/admin/driver )
“xxpls.drv”, which creates package specification
“xxplb.drv” , which creates package bodies during the package bodies phase.
“xxfile.drv” ( driver file ) which lists all the files you need to run the application  which is categorized by the type of file like
– form files
– report files
– concurrent programs
– message files
This driver is very important file and list all the product specfic files in the release
import directory decoded
This is more relavant in R11i
•  Import files (.dat ) Example :-  $PER_TOP/admin/import/pertime.dat
• DataMerge files (.ctl, .dat, and .exp), and
• Applications loader files (.slt, .plt, .vlt, .clt, .msg, .wft,.jlt)
odf directory decoded
$PRODUCT_TOP/admin/odf (Object Discreptor File)  : the files used to create tables and other database objects.Oracle supplies definition of Database objects in an ODF (Object Description File) file and sometimes they are supplied in individual script files.  An ODF file contains the definition of tables, views, indexes, sequences, and privilege sets for a building block within a product.
sql directorty decoded
sql   : the SQL scripts and PL/SQL scripts used to upgrade data.
template directory decoded
it contains the product specific autoconfig configuration files .Example FND_TOP
afmkinit.cmd                          registersessionwithlog.cmd            txkWebServicesCfg.sql
afmkinit.sh                           registersessionwithlog.sh             txkWfClone.cmd
afTk2Motif_UTF8.txt                   robots.txt                            txkWfClone.sh
afwdbsvr.cmd                          runcol.sh                             txkWfClone.sh.Old
afwdbsvr.sh                           runpref.sh                            txkWfClone.sql
afwebprf_nt.sql                       runses.sh                             txkWfClone.sql.Orig
afwebprf_ux.sql                       runssodatan.cmd                       txkxmlctx.tmp
afwebprf.cmd                          security_nt_ias1022.conf              unregistercollector.cmd
afwebprf.sh                           security_ux_ias1022.conf              unregistercollector.sh
afwebprf.sql                          soap_ias1022.properties               unregisterpreference.cmd
antisamy                              soapConfig.xml                        unregisterpreference.sh
applypreferences.sh

Leave a Reply