Create a missing Database Object in Oracle E-Buisness suite R12 using a odf (adodfcmp).

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.