1 2 Previous Next 16 Replies Latest reply on Apr 1, 2016 8:48 AM by 3142679

    adop phase=apply patches=20745242 hotpatch=yes / from fnd_nodes fn, adop_valid_nodes avn / ORA-00942: table or view does not exist

    user11952526

      Hi,

       

      I am upgrading from R12.2.0 to R12.2.5.0.

      Following the below MOS...

       

      Upgrading Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to the latest 11gR1 (11.1.1.x) PatchSet (Doc ID 1590356.1)

      Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

       

      While applying the below patch getting the below error... How to fix this ?

       

      1. Error...

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

      $ . ./APPSEBT1_erp1.env

      [applebt1@erp1][/home/applebt1]

      $ adop phase=apply patches=20745242 hotpatch=yes

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      1. Initializing.

          Run Edition context  : /u03/ebt1/fs1/inst/apps/EBT1_erp1/appl/admin/EBT1_erp1.xml

          Patch edition context: /u03/ebt1/fs2/inst/apps/EBT1_erp1/appl/admin/EBT1_erp1.xml

      *******FATAL ERROR*******

      PROGRAM : (/u03/ebt1/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Sun Mar 27 20:18:31 2016

      FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

      MESSAGES:

      SQLPLUS error: buffer=

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 27 20:18:31 2016

       

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

       

      SQL> SQL> Connected.

      SQL>    from fnd_nodes fn, adop_valid_nodes avn

                                 *

      ERROR at line 3:

      ORA-00942: table or view does not exist

       

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

       

       

      STACK TRACE

      at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

              TXK::Error::abort('TXK::Error', 'HASH(0x1fb6f30)') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299

              TXK::Common::doError('TXK::SQLPLUS=HASH(0x3dff978)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314

              TXK::Common::setError('TXK::SQLPLUS=HASH(0x3dff978)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832

              TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x3dff978)', 0) called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234

              TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x3dff978)', 'HASH(0x3b54f98)') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618

              TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x3fc0798)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

              TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x3fc0798)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 1278

              ADOP::GlobalVars::_GetMandatoryArgs() called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3178

              ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /u03/ebt1/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1745

              ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /u03/ebt1/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 146

       

      adop exiting with status = 1 (Fail)

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

       

      Thanks

        1 2 Previous Next