Tuesday, August 28, 2012

odf and xdf in Oracle E-Business Suite

odf - Object Description file, Oracle use this in EBS to create database objects, ie tables, views, indexes. The replacement for odf is called xdf.

useage of odf:
$AD_TOP/bin/adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \
userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>

useage of xdf:
$JAVA_TOP/oracle/apps/fnd/odf2/adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp <Oracle_Schema> <Oracle_Password> \
<apps_schema> <apps_password> <jdbc protocol> <JDBC_Connect_String> <Object Type> \
<full path to xdf file> <full path of $FND_TOP/patch/115/xdf/xsl>

More details in Oracle support notes:
How to verify or create a Database Object using a odf (adodfcmp) or xdf (FndXdfCmp) file ? [ID 551325.1]

1 comment:

  1. Nice blog and absolutely outstanding. You can do something much better but i still say this perfect.Keep trying for the best. Eric Samek

    ReplyDelete