The ODF Comparison utility(ADODFCMP) compares the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model.
Each application consists of certain building blocks. An object descriptor file (ODF) describes the oracle tables, oracle view, oracle indexes, sequences, and privilege sets for the particular building block. ODF Comparison compares the building block to the object descriptor file (ODF). A log file is created showing any missing, extra, or incorrectly defined objects
Whenever we apply the Oracle application patches, patches supply odf’s file and Oracle adpatch runs the odf comparison utility to make the changes in the database.
Sometimes we need to run odf comparison manually to check for missing objects.
How to run ODF comparison utility(ADODFCMP)
cd $PROD_TOP/admin/odf
Parameters can be specified in any order on the command line. The following
parameters are required: mode, touser, priv_schema, odffile, userid
mode (required): Determines the type of objects to compare against the ODF. Example tables, indexes
touser (required): Specifies the Oracle username/password of the Oracle Applications product to grant to. In Release 11i/R12 this is usually APPS schema.
priv_schema (required): Specify a schema having DBA privileges, along with its password. You may specify the SYSTEM schema
odffile (required): The name of the object descriptor file (file extension .odf) to compare.
userid (required): The Oracle username/password for the product’s base schema. This is the schema where the product tables, indexes, and sequences are located for example inv/inv
changedb (opt) No: Set to yes to change the database objects to match the definitions in the object descriptor files. Customizations are not affected because the utility does not delete objects not found in the ODF. Using the default, No, will not make any changes only produce a log file indicating what changes need to be made.
Example
Make a comparison of the indexes in onttab.odf. Make changes to the database.
Create a log file called onttab.log in the current directory.
adodfcmp odffile=onttab.odf userid=ont/ont changedb=yes priv_schema=system/manager mode=indexes touser=apps/apps logfile=onttab.log
In the earlier Releases of the E-Business-Suite the odf-files (Object Description File) were introduced to create DB Objects like tables, synonyms, views, Indexes, etc using the appropriate AD-Utility. These odf-files are available in Release 10.7, 11.0.3, 11i and R12. But the odf-files are more and more replaced by the xdf files, starting with Release 11i and further implemented in R12.
To verify and create Database Objects, defined in an xdf-File you are using the Java Utility FndXdfCmp, which is located under the $JAVA_TOP/oracle/apps/fnd/odf2.
Also Reads
FNDLOAD command
FNDCPASS
oracle apps DBA interview questions
How To Verify Or Create A Database Object Using An ODF (Adodfcmp) Or XDF (FndXdfCmp) File (Doc ID 551325.1)