Syntax:
$ adjava –mx512m –nojit
oracle.apps.fnd.odf2.FndXdfCmp <Oracle_Schema> <Oralce_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>
Example:
$adjava -mx512m -nojit
oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin IP_ADDRESS:DB_PORT: SID
all /u02/applt/SID/apps/apps_st/appl/gl/12.0.0/patch/115/xdf/gl_alloc_int_3.xdf
/u02/applt/SID/apps/apps_st/appl/fnd/12.0.0/patch/115/xdf/xsl
Output:
Copyright (c) 2002 Oracle Corporation
Redwood
Shores, California, USA
AD Java
Version 12.0.0
NOTE: You may not use this utility for custom development
unless you have written
permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH
to:
"/u02/applt/TRAIN/apps/apps_st/appl/ad/12.0.0/java/adjava.zip:/u02/applt/TRAIN/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u02/applt/TRAIN/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u02/applt/TRAIN/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u02/applt/TRAIN/apps/apps_st/comn/java/lib/appsborg.zip:/u02/applt/TRAIN/apps/tech_st/10.1.2/forms/java:/u02/applt/TRAIN/apps/tech_st/10.1.2/forms/java/frmall.jar:/u02/applt/TRAIN/apps/tech_st/10.1.2/jlib/ewt3.jar:/u02/applt/TRAIN/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u02/applt/TRAIN/apps/apps_st/comn/java/classes"
Calling
/u02/applt/TRAIN/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
XDF file application started. Current time is: Fri Apr 11 11:01:37 IST
2014
================================================================================
Applying XDF file :
/u02/applt/TRAIN/apps/apps_st/appl/gl/12.0.0/patch/115/xdf/gl_alloc_int_3.xdf
================================================================================
Copyright (c) 2003
Oracle Corporation
Redwood Shores,
California, USA
XDF(XML Object Description
File) Comparison Utility
Version 1
NOTE: You may not use this utility for custom development
unless you have written
permission from Oracle Corporation.
Creating Table in the XDF file
Table Name is GL_ALLOC_INT_3
Table does not exist in the target database
Executing create Statement
Create Statement is
CREATE GLOBAL TEMPORARY TABLE
"GL"."GL_ALLOC_INT_3"
( "FORMULA_ID" NUMBER(15,0) NOT
NULL ENABLE,
"FORMULA_LINE_NUMBER" NUMBER(15,0) NOT NULL ENABLE,
"ENTERED_AMOUNT"
NUMBER NOT NULL ENABLE,
"ACCOUNTED_AMOUNT" NUMBER NOT NULL ENABLE,
"LEDGER_ID"
NUMBER(15,0),
"SEGMENT1"
VARCHAR2(25),
"SEGMENT2"
VARCHAR2(25),
"SEGMENT3"
VARCHAR2(25),
"SEGMENT4"
VARCHAR2(25),
"SEGMENT5"
VARCHAR2(25),
"SEGMENT6"
VARCHAR2(25),
"SEGMENT7"
VARCHAR2(25),
"SEGMENT8"
VARCHAR2(25),
"SEGMENT9"
VARCHAR2(25),
"SEGMENT10" VARCHAR2(25),
"SEGMENT11"
VARCHAR2(25),
"SEGMENT12"
VARCHAR2(25),
"SEGMENT13"
VARCHAR2(25),
"SEGMENT14"
VARCHAR2(25),
"SEGMENT15"
VARCHAR2(25),
"SEGMENT16"
VARCHAR2(25),
"SEGMENT17"
VARCHAR2(25),
"SEGMENT18" VARCHAR2(25),
"SEGMENT19"
VARCHAR2(25),
"SEGMENT20"
VARCHAR2(25),
"SEGMENT21"
VARCHAR2(25),
"SEGMENT22"
VARCHAR2(25),
"SEGMENT23"
VARCHAR2(25),
"SEGMENT24"
VARCHAR2(25),
"SEGMENT25"
VARCHAR2(25),
"SEGMENT26"
VARCHAR2(25),
"SEGMENT27"
VARCHAR2(25),
"SEGMENT28"
VARCHAR2(25),
"SEGMENT29"
VARCHAR2(25),
"SEGMENT30"
VARCHAR2(25)
) ON COMMIT PRESERVE ROWS
Start time for statement above is Fri Apr 11 11:01:38 IST 2014
End time for statement above is Fri Apr 11 11:01:38 IST 2014
Executing grants on GL_ALLOC_INT_3 to APPS
GRANT ALL ON GL.GL_ALLOC_INT_3 TO APPS WITH GRANT OPTION
Creating synonym GL_ALLOC_INT_3
for GL.GL_ALLOC_INT_3
Synonym created
Index hashcode(s) extracted from the XDF.
Hashcodes generated for DB indexes.
Index GL_ALLOC_INT_3_N1 does not exist in GL.
CREATE INDEX "GL"."GL_ALLOC_INT_3_N1" ON
"GL"."GL_ALLOC_INT_3" ("FORMULA_ID")
Start time for statement above is Fri Apr 11 11:01:38 IST 2014
End time for statement above is Fri Apr 11 11:01:38 IST 2014
Index GL_ALLOC_INT_3_N1 Created
No AOL metadata present in the XDF file
Completed.
