Use of odfgen and odfcmp utilities with ORACLE Applications 9.3.6

Hye,

The two utilities odfgen and odfcmp that ORACLE provides with their Financials package MPL9.3.6 are not explained anywhere. So here is how to use these programs:

The odfgen utility is used to create an ASCII file which contains the definitions of tables, indexes, sequences, views, synonyms and grants. Whenever you re-create your Financials database and you which to check that all the tables, indexes, ... are there you will have to run the odfgen program first.

1. Go to the $APPL_TOP/install directory.
2. Edit the userids.txt file which contains the modules names as well as the tablespaces names. Do not forget to remove the comments at the beginning of the lines.
3. Run odfgen and let the program do it all for you.
4. Type the name of the log file. (the log file will be located in the $APPL_TOP/install directory.) Type return to accept the default name.
5. Type the ORACLE username of the module you wish to select. (GL for example)
6. Type the password of the module. Note that the password will appear on the screen. Is this a bug ???
7. Enter the filename to generate. (This is the ASCII file .odf) By default the name will be composed of the ORACLE username with the extension odf)
8. Answer Yes or No to the questions: Generate tables ? views ? indexes ? sequences ? grants ? synonyms ?
9. Enter the name of the userids.txt file. By default it will take the one in the current directory.)
10. Give a sizing factor. (100 % by default)
11. Let it run.

Note that the odfgen utility will only create a file with descriptions of objects and will not export data.

The odfcmp utility runs quite the same way. You can use the odfcmp utility to 1) report missing objects from an ORACLE Financials account, 2) report extra objects in the account or 3) report detailed differences between an object in the account and an object of the same name in the file.

The odfcmp utility also reports and optionally executes the SQL statements to fix these differences. You can review the SQL statements before actually executing them. An example of the use of odfcmp with the created GL.odf file which contains descriptions of all objects in the account.

$ odfcmp

Filename [odfcmp.log] : glcmp.log

Enter the ORACLE username to compare the file with: GL

Enter the ORACLE password for that username: GL

Connecting to GL/GL...... Connected successfully

Enter the filename to compare with [GL.odf]: <Return>

Enter the name of the ORACLE userids file [userids.txt] : <Return> ...

Now the odfcmp utility will run and create a log file called glcmp.log. It reports differences but does not correct them. You can run odfcmp with the option "changedb=yes" to automatically change the database for you or you can get the SQL statements from the log file. If you use the option "listmatch=no", odfcmp will not report on objects in the database that match the ODF file. It will only report the actual differences. By default odfcmp prints a line like :

"=======Table GL_INTERFACE all columns match"

for each object that is the same in the database and in the odf file.

If you have any questions do not hesitate to write me an e-mail at the address below.

Philippe BORGONOVO                    Phone  : (33) 92.94.45.54
Application Development Consultant    E-mail : Philippe.Borgonovo_at_Sophia.NCR.FR
Financial Management Systems          Fax    : (33) 92.94.45.45
NCR European Development Center	      VoicePlus: 327-4554