4 Replies Latest reply on Sep 11, 2017 3:03 AM by Beauty_and_dBest

    SHRD0043: ERROR: ORA-00942: table or view does not exist

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2

      OL6

      12c

       

       

      Capture.GIFI encountered above error, and the suggested solution is to run :

       

      Suggested Solution from community:

      1. Go to  cd $GL_TOP/patch/115/xdf

      adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp fnd apps thin

      :: all gl_summary_interim_0.xdf $FND_TOP/patch/115/xdf/xsl

      or

      adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl <glpwd> apps <appspwd> thin <hostname>:<db_port>:<db_sid> all gl_summary_interim_0.xdf $FND_TOP/patch/115/xdf/xsl

       

       

      Whe I run :

       

      adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin fitr12.myoracle.com:1521:VISN all gl_summary_interim_0.xdf $FND_TOP/patch/115/xdf/xsl

       

       

                           Copyright (c) 2002, 2012 Oracle Corporation

       

                              Redwood Shores, California, USA

                                          AD Java

                                       Version 12.2.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:

        "/u01/appvisn/VISN/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/java/classes:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/forms/java:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

        Calling /u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...

      Exception occured

                    Copyright (c) 2003 Oracle Corporation

                       Redwood Shores, California, USA

               XDF(XML Object Description File) Comparison Utility

       

      Invalid XML file

       

       

      Why is it invalid?

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: SHRD0043: ERROR: ORA-00942: table or view does not exist
          Shaik

          Hi JC

           

          steps are correct which yoou found in community same mentioned in doc id 1613003.1

           

          1. Goto  cd $GL_TOP/patch/115/xdf

           

          adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp fnd apps thin

          :: all gl_summary_interim_0.xdf $FND_TOP/patch/115/xdf/xsl

           

           

          Regards

          Shaik

          • 2. Re: SHRD0043: ERROR: ORA-00942: table or view does not exist
            Beauty_and_dBest

            Thanks Shaik

             

            I run the script again, and it got different error? or is it successful?

             

            $ adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin fitr12.myoracle.com:1521:VISN all gl_summary_interim_0.xdf  $FND_TOP/patch/115/xdf/xsl

             

            XDF file application started. Current time is: Mon Sep 11 00:45:08 PHT 2017

            ================================================================================

            Applying XDF file : gl_summary_interim_0.xdf

            ================================================================================

                          Copyright (c) 2003 Oracle Corporation

                             Redwood Shores, California, USA

                     XDF(XML Object Description File) Comparison Utility

             

            Creating Table in the XDF file

             

            Table Name is GL_SUMMARY_INTERIM_0

            Table does not exist in the target database

            Executing create Statement

            Create Statement is

             

                  CREATE GLOBAL TEMPORARY TABLE "GL"."GL_SUMMARY_INTERIM_0"

               (    "SOURCE_FLEX_VALUE" VARCHAR2(25),

                    "TARGET_FLEX_VALUE" VARCHAR2(25)

               )  ON COMMIT PRESERVE ROWS

             

            Start time for statement above is Mon Sep 11 00:45:10 PHT 2017

            End time for statement above is Mon Sep 11 00:45:10 PHT 2017

             

            Executing grants on GL_SUMMARY_INTERIM_0 to APPS

            GRANT ALL ON GL.GL_SUMMARY_INTERIM_0 TO APPS WITH GRANT OPTION

            Creating synonym :CREATE SYNONYM GL_SUMMARY_INTERIM_0 FOR GL.GL_SUMMARY_INTERIM_0

            Synonym created

             

            Index hashcode(s) extracted from the XDF.

             

            Hashcodes generated for DB indexes.

             

            Index GL_SUMMARY_INT_0_U1 does not exist in GL.

             

            CREATE UNIQUE INDEX "GL"."GL_SUMMARY_INT_0_U1" ON "GL"."GL_SUMMARY_INTERIM_0" ("SOURCE_FLEX_VALUE", "TARGET_FLEX_VALUE")

            Start time for statement above is Mon Sep 11 00:45:12 PHT 2017

            End time for statement above is Mon Sep 11 00:45:12 PHT 2017

            Index GL_SUMMARY_INT_0_U1 Created

             

            No AOL metadata present in the XDF file

            • 3. Re: SHRD0043: ERROR: ORA-00942: table or view does not exist
              Beauty_and_dBest

              Hi Shaik,

               

              I docs siad to replace 0 to 30. But when I replace and run it, I got invalid xml file again

               

               

              [appvisn@fitr12 ~]$ cd $GL_TOP/patch/115/xdf

              [appvisn@fitr12 xdf]$ adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin fitr12.myoracle.com:1521:VISN all gl_summary_interim_30.xdf $FND_TOP/patch/115/xdf/xsl

               

                                   Copyright (c) 2002, 2012 Oracle Corporation

                                      Redwood Shores, California, USA

               

                                                  AD Java

               

                                               Version 12.2.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:

                "/u01/appvisn/VISN/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/appvisn/VISN/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/appvisn/VISN/fs1/EBSapps/comn/java/classes:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/forms/java:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u01/appvisn/VISN/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

               

              Calling /u01/appvisn/VISN/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...

              Exception occured

                            Copyright (c) 2003 Oracle Corporation

                               Redwood Shores, California, USA

                       XDF(XML Object Description File) Comparison Utility

               

              Invalid XML file

              • 4. Re: SHRD0043: ERROR: ORA-00942: table or view does not exist
                Beauty_and_dBest

                Thanks all, it okay now 

                 

                The docs says run 0 up to 30, but there is no 30, but 29 is the 30th