3 Replies Latest reply on Mar 13, 2017 5:36 AM by Girish Sunkara

    error while applying consolidated seed table upgrade patch17197281:12.2.0 (CUP4)

    Girish Sunkara

      Hello all,


      I am trying to upgrade EBS vision 12.2.0 to 12.2.3 by following doc 1586214.1. While applying patch17197281:12.2.0 (CUP4) as hotpatch, adop is failing at finalize stage with below error, I do have 3 invalid objects namely, OE_ITEMS_MV, OZF_EARNING_SUMMARY_MV, and AD_ZD_MVIEW.


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

      PROGRAM : (/u01/devAPPS/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Wed Mar  8 02:34:31 2017

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


      SQLPLUS error: buffer=


      SQL*Plus: Release - Production on Wed Mar 8 02:29:58 2017


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


      SQL> SQL> Connected.

      SQL>       begin


      ERROR at line 1:

      ORA-20001: Error: while calling ad_zd.finalize .ORA-06508: PL/SQL: could not

      find program unit being called

      ORA-06512: at line 8


      Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



      at /u01/devAPPS/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

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

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

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

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

        TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x280fb90)', 'HASH(0x2324350)') called at /u01/devAPPS/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618

        TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x18c61b8)', '      begin\x{a}        ad_zd.finalize;\x{a}      exception\x{a}        w...') called at /u01/devAPPS/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

        TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x18c61b8)', '      begin\x{a}        ad_zd.finalize;\x{a}      exception\x{a}        w...') called at /u01/devAPPS/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 262

        ADOP::Phase::executeSQL('ADOP::ApplyPhase=HASH(0x17322a0)', '      begin\x{a}        ad_zd.finalize;\x{a}      exception\x{a}        w...') called at /u01/devAPPS/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/ApplyPhase.pm line 579

        ADOP::ApplyPhase::runAutopatch('ADOP::ApplyPhase=HASH(0x17322a0)', 2) called at /u01/devAPPS/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 421

        main::executePhaseSequence() called at /u01/devAPPS/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 863

        main::adopMain() called at /u01/devAPPS/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 872

      adop exiting with status = 255 (Fail)



      I was also reading Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) and it says "Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode." This is not mentioned in EBS 12.2.3 readme 1586214.1. Is this error because of not applying merged patch? How to solve this situation?