upgrade from 12.1.3 to R12.2. on solaris 10

[ErmanArslansOracleBlog]

Okay.. it maybe related.
So, skip the worker.. Let the patch finish.
After the execute sqlplus to run the problematic sql and see...

[syed raza]

Hi Emran,
I am successfully upgrade the 12.1.3 to 12.2.0.At what stage we can deployed the custom top which is already present in 12.1.3 and one off cycle product i.e CLE

[ErmanArslansOracleBlog]

After finishing your upgrade...

Are you following the document named :  "Oracle E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part Number E48839-16"

Please follow it..

There are important notes there..

For ex: Do not run adsplice when you are at the Oracle E-Business Suite Release 12.2.0 level. Before running adsplice, you must upgrade to R12.AD.C.Delta.5 and R12.TXK.C.Delta.5 Release update packs or higher for AD and TXK.

Please follow the document above and do your actions accordingly. With the same order as documented in the document above.

[syed raza]

Thanks Emran,
I follow the same document will update ypou  if i face any issue
thanks for your help

[syed raza]

whilr applying the delta 10 patch
SQL> ALTER PACKAGE APPS.AD_ZD_ADOP COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2583/20  PL/SQL: Item ignored
2583/49  PLS-00302: component 'C_PATCH_SERVICE' must be declared
2749/5   PL/SQL: Statement ignored
2749/5   PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

2755/5   PL/SQL: SQL Statement ignored
2756/29  PL/SQL: ORA-00904: "L_PATCH_SERVICE": invalid identifier
2756/29  PLS-00320: the declaration of the type of this expression is
         incomplete or malformed


LINE/COL ERROR
-------- -----------------------------------------------------------------
2757/5   PL/SQL: SQL Statement ignored
2758/29  PL/SQL: ORA-00904: "L_PATCH_SERVICE": invalid identifier
2758/29  PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

[ErmanArslansOracleBlog]

What DELTA 10 patch?
What is the patch number?
Did you check AD_ZD_ADOP package? Are l_patch_service and c_patch_service defined in it?

[syed raza]

bash-3.2$ adop -status                                  

Enter the APPS password:
*******FATAL ERROR*******
PROGRAM : (/app/oracle/PROD/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Thu Feb  1 19:19:27 2018
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Feb 1 19:19:27 2018

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

SQL> SQL> Connected.
SQL>   select ad_zd_adop.validate_session_id('') from dual
                                                 *
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



STACK TRACE
 at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
        TXK::Error::abort('TXK::Error', 'HASH(0x10064d1e0)') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
        TXK::Common::doError('TXK::SQLPLUS=HASH(0x102c5cf20)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
        TXK::Common::setError('TXK::SQLPLUS=HASH(0x102c5cf20)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
        TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x102c5cf20)', 0) called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
        TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x102c5cf20)', 'HASH(0x102b34758)') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
        TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x102b1ab98)', '  select ad_zd_adop.validate_session_id(\'\') from dual\x{a}') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
        TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x102b1ab98)', '  select ad_zd_adop.validate_session_id(\'\') from dual\x{a}') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 510
        ADOP::GlobalVars::_getADOPStatus(undef, undef) called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2280
        ADOP::GlobalVars::_ValidateArgs() called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3126
        ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1842
        ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /app/oracle/PROD/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)

adop phase=apply patches=25820806 hotpatch=yes

[ErmanArslansOracleBlog]

What errors does  "APPS.AD_ZD_ADOP" have?

[syed raza]

SQL> alter package APPS.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2583/20  PL/SQL: Item ignored
2583/49  PLS-00302: component 'C_PATCH_SERVICE' must be declared
2749/5   PL/SQL: Statement ignored
2749/5   PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

2755/5   PL/SQL: SQL Statement ignored
2756/29  PL/SQL: ORA-00904: "L_PATCH_SERVICE": invalid identifier
2756/29  PLS-00320: the declaration of the type of this expression is
         incomplete or malformed


LINE/COL ERROR
-------- -----------------------------------------------------------------
2757/5   PL/SQL: SQL Statement ignored
2758/29  PL/SQL: ORA-00904: "L_PATCH_SERVICE": invalid identifier
2758/29  PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

[ErmanArslansOracleBlog]

This is undocumented.
Probably, you did something wrong during your upgrade.

What is the number of the patch that is failing?