Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, October 8, 2007

XDF : XML definition file

XDF or XML definition file was introduced as a new feature in FND.H minipack.

XML-based Object Definition File (XDF)

XDF (XML Definition File) captures the E-Business Suite schema object definitions and is the file format that will eventually replace ODF (Object Definition File.). XDFs are applied to E-Business Suite application databases by an internal utility (invoked by AD Patch) that checks for object version updates. A key feature of XDF is its broad support of the latest Oracle RDBMS object types, which helps eliminate the SQL script-based method of distributing schema object information.

I came across this file during the upgrade, when some of the xdfs showed skipped in adworker logs but completed in patch log.

Metalink note 306906.1 gives the method of manually loading xdf files:

Create missing database objects manually by using FNDXDFCMP utility from the definition of the objects provided through xdf files.

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp &jdbc_protocol "&jdbc_tns_address " &object_type

values for parameters:

&jdbc_protocol = thin
&jdbc_address = hostname.domainname:db_port:
&object_type = table | mview | view | synonym | index | trigger | comment | context | mviewlog|sequence | qtable | sequence | type | queue | policy | all

Example : adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp fnd fnd apps apps thin "hostname:db_port:db_sid" all fnd_usr_roles.xdf $FND_TOP/patch/115/xdf/xsl


Srinivas said...

Helped me in understanding what xdf. Thanks

Jeremy Webb said...

Note 308427.1 gives a fuller explanation together with the complete syntax.

For the Apps DBA's of you, FndXdfCmp is basically the java replacement of ADODFCMP that has been around for ages.