8 Replies Latest reply on Feb 2, 2016 11:26 AM by Bashar.

    Online Patching Error Log

    Ramaraju

      We are upgrading EBS R11.5.10.2 to R12.24. In this we applied 'Online Patching Enablement Patch'. After this we executed ADZDDBCC.sql to find the status of objects after online patching enablement, but we found issues against table objects under section-1 which are seeded. Oracle recommends to fix these objects. So, please provide the solution to fix these objects.

      Section 1 contains following error. Please help us here.

      DOC>  **********************************************************************

      DOC>  SECTION-1

      DOC>  **********************************************************************

      DOC>  Online Patching Error Log

      DOC>

      DOC>  This section shows errors that occurred during Online Patching Enablement

      DOC>  or the most recent Online Patching session.  Logged errors indicate that

      DOC>  an action did not complete correctly on the initial attempt, but in some

      DOC>  cases the problem is corrected later by automatic or manual retry.  Use

      DOC>  the diagnostic log to determine whether logged errors were resolved.

      DOC>#

      PL/SQL procedure successfully completed.

      Elapsed: 00:00:00.11

      LOG_MODULE                                 LOG_LEVEL  LOG_MESSAGE

      ------------------------------------------ ---------- --------------------------------------------------------------------------------------------------------------------------------------------

      ad.plsql.ad_zd.set_edition                 ERROR      Unable to set edition. Invalid edition type : PATCH

      ad.plsql.ad_zd.set_edition                 ERROR      Unable to set edition. Invalid edition type : PATCH

      ad.plsql.ad_zd_table.install_ev            ERROR      ERROR: ORA-04020: deadlock detected while trying to lock object APPS.AP_CHECKS_ALL, SQL: create or replace synonym "APPS"."AP_CHECKS_ALL" fo

                                                            r "AP"."AP_CHECKS_ALL#"

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:13 ddl_id=11332] ORA-04020: deadlock detected while trying to lock object APPS.AP_CHECKS_ALL SQL: begin ad_zd_table.upgrad

                                                            e('AP', 'AP_CHECKS_ALL'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:20 ddl_id=11979] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_OAM_BF_TL'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:31 ddl_id=12054] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_OBJECT_TYPE_MEMBERS'); en

                                                            d;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:32 ddl_id=11703] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_CACHE_VERSIONS'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:15 ddl_id=12326] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AR', 'AR_BPA_CONTENT_AREAS_TL'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:24 ddl_id=12367] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AR', 'AR_CASH_REMIT_REFS_INTERIM'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:17 ddl_id=12264] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'WF_MESSAGES_TL'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:4 ddl_id=12251] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'WF_LOCAL_ROLES_OLD'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:2 ddl_id=12089] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_PROFILE_OPTIONS_TL'); end

                                                            ;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:6 ddl_id=12221] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'WF_ACTIVITY_ATTRIBUTES_TL');

                                                            end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:28 ddl_id=11443] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AP', 'AP_REPORTING_ENTITY_LINES_ALL'); e

                                                            nd;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:29 ddl_id=12148] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_STATS_HIST'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:9 ddl_id=12032] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_OAM_DS_PSET_ELMNTS'); end

                                                            ;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:12 ddl_id=12451] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AR', 'AR_GTA_RULE_TRX_TYPES_ALL'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:21 ddl_id=12428] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AR', 'AR_CUSTOMER_CALL_TOPICS_ALL'); end

                                                            ;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:18 ddl_id=12233] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'WF_DIG_SIG_SPI_FLAVORS'); end

                                                            ;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:8 ddl_id=11871] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_FORM_CUSTOM_ACTIONS'); en

                                                            d;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:5 ddl_id=11804] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_DM_NODES'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:7 ddl_id=11774] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_DATABASE_ASSIGNMENTS'); e

                                                            nd;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:3 ddl_id=12122] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_SELAUDIT_GROUPS'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:10 ddl_id=12161] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_TEMP_FILES'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:23 ddl_id=12014] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_OAM_DSCRAM_ARG_VALUES');

                                                            end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:1 ddl_id=12216] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'UMX_REG_SERVICES_B'); end;

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:19 ddl_id=11786] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_DEBUG_RULES'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:11 ddl_id=12098] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_REQUEST_GROUP_UNITS'); en

                                                            d;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:16 ddl_id=12039] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_OAM_METS_TL'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:13 ddl_id=11748] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_CONC_REL_DISJ_MEMBERS');

                                                            end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:27 ddl_id=12338] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AR', 'AR_BPA_RULES_TL'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:14 ddl_id=11781] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('APPLSYS', 'FND_DB_SERVICE_MEMBERS'); end

                                                            ;

       

       

      ad.plsql.ad_zd_table.install_ev            ERROR      ERROR: ORA-04020: deadlock detected while trying to lock object APPS.AP_CARDS, SQL: create or replace synonym "APPS"."AP_CARDS" for "AP"."AP

                                                            _CARDS_ALL#"

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:26 ddl_id=11313] ORA-04020: deadlock detected while trying to lock object APPS.AP_CARDS SQL: begin ad_zd_table.upgrade('AP

                                                            ', 'AP_CARDS_ALL'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:26 ddl_id=11345] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AP', 'AP_DUPLICATE_VENDORS_ALL'); end;

       

       

      ad.plsql.ad_zd_table.install_ev            ERROR      ERROR: ORA-04020: deadlock detected while trying to lock object APPS.AP_INVOICES_ALL, SQL: create or replace synonym "APPS"."AP_INVOICES_ALL

                                                            " for "AP"."AP_INVOICES_ALL#"

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:22 ddl_id=11373] ORA-04020: deadlock detected while trying to lock object APPS.AP_INVOICES_ALL SQL: begin ad_zd_table.upgr

                                                            ade('AP', 'AP_INVOICES_ALL'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:22 ddl_id=11405] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AP', 'AP_OU_GROUP'); end;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:25 ddl_id=11408] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AP', 'AP_PAYMENT_DISTRIBUTIONS_ALL'); en

                                                            d;

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:30 ddl_id=11413] AD_ZD Packages Invalid, exiting.  ORA-04061: existing state of  has been invalidated

                                                            ORA-04061: existing state of package body "APPS.AD_ZD_TABLE" has been invalidated

                                                            ORA-04065: not executed, altered or dropped package body "APPS.AD_Z SQL: begin ad_zd_table.upgrade('AP', 'AP_PAYMENT_REP_ITF'); end;

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      ERROR: ORA-00923: FROM keyword not found where expectedSQL(CLOB): create or replace editioning view  "XBSI"."XBSI_EBS_ITEM#" as select Item

                                                            Number Item Number, EBS_DESCRIPTION EBS_DESCRIPTION, EBS_ITEM_TYPE EBS_ITEM_TYPE, EBS_MFG_CODE EBS_MFG_CODE, EBS_PRICE_CATEGORY EBS_PRICE_CA

                                                            TEGORY, EBS_ISTORE_CATEGORY EBS_ISTORE_CATEGORY, EBS_HARMONIZED_CODE EBS_HARMONIZED_CODE, EBS_SHIP_WEIGHT EBS_SHIP_WEIGHT, EBS_MSRP EBS_MSRP

                                                            , EBS_FLO_COST EBS_FLO_COST, EBS_BMF_COST EBS_BMF_COST, EBS_FLO_BUYER EBS_FLO_BUYER, EBS_BMF_BUYER EBS_BMF_BUYER, EBS_APPRV_SUPPLIER_NAME EB

                                                            S_APPRV_SUPPLIER_NAME, EBS_APPRV_SUPPLIER_SITE EBS_APPRV_SUPPLIER_SITE, EBS_COUNTRY_OF_ORIGIN EBS_COUNTRY_OF_ORIGIN, EBS_MIN EBS_MIN, EBS_MA

                                                            X EBS_MAX, EBS_RETURNABLE EBS_RETURNABLE, EBS_SERIALIZED EBS_SERIALIZED, EBS_IMAGE EBS_IMAGE, EBS_ITEM_STATUS EBS_ITEM_STATUS, EBS_MFG_NAME

                                                            EBS_MFG_NAME from "XBSI"."XBSI_EBS_ITEM"

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      XBSI.XBSI_EBS_ITEM: ORA-00923: FROM keyword not found where expected

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 32:15 ddl_id=27878] ORA-00923: FROM keyword not found where expected SQL: begin ad_zd_table.upgrade('XBSI', 'XBSI_EBS_ITEM');

                                                             end;

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      ERROR: ORA-00923: FROM keyword not found where expectedSQL(CLOB): create or replace editioning view  "XBSI"."XBSI_EBS_ITEM#" as select Item

                                                            Number Item Number, EBS_DESCRIPTION EBS_DESCRIPTION, EBS_ITEM_TYPE EBS_ITEM_TYPE, EBS_MFG_CODE EBS_MFG_CODE, EBS_PRICE_CATEGORY EBS_PRICE_CA

                                                            TEGORY, EBS_ISTORE_CATEGORY EBS_ISTORE_CATEGORY, EBS_HARMONIZED_CODE EBS_HARMONIZED_CODE, EBS_SHIP_WEIGHT EBS_SHIP_WEIGHT, EBS_MSRP EBS_MSRP

                                                            , EBS_FLO_COST EBS_FLO_COST, EBS_BMF_COST EBS_BMF_COST, EBS_FLO_BUYER EBS_FLO_BUYER, EBS_BMF_BUYER EBS_BMF_BUYER, EBS_APPRV_SUPPLIER_NAME EB

                                                            S_APPRV_SUPPLIER_NAME, EBS_APPRV_SUPPLIER_SITE EBS_APPRV_SUPPLIER_SITE, EBS_COUNTRY_OF_ORIGIN EBS_COUNTRY_OF_ORIGIN, EBS_MIN EBS_MIN, EBS_MA

                                                            X EBS_MAX, EBS_RETURNABLE EBS_RETURNABLE, EBS_SERIALIZED EBS_SERIALIZED, EBS_IMAGE EBS_IMAGE, EBS_ITEM_STATUS EBS_ITEM_STATUS, EBS_MFG_NAME

                                                            EBS_MFG_NAME from "XBSI"."XBSI_EBS_ITEM"

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      XBSI.XBSI_EBS_ITEM: ORA-00923: FROM keyword not found where expected

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 1:1 ddl_id=27878] ORA-00923: FROM keyword not found where expected SQL: begin ad_zd_table.upgrade('XBSI', 'XBSI_EBS_ITEM'); e

                                                            nd;

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      ERROR: ORA-00923: FROM keyword not found where expectedSQL(CLOB): create or replace editioning view  "XBSI"."XBSI_EBS_ITEM#" as select Item

                                                            Number Item Number, EBS_DESCRIPTION EBS_DESCRIPTION, EBS_ITEM_TYPE EBS_ITEM_TYPE, EBS_MFG_CODE EBS_MFG_CODE, EBS_PRICE_CATEGORY EBS_PRICE_CA

                                                            TEGORY, EBS_ISTORE_CATEGORY EBS_ISTORE_CATEGORY, EBS_HARMONIZED_CODE EBS_HARMONIZED_CODE, EBS_SHIP_WEIGHT EBS_SHIP_WEIGHT, EBS_MSRP EBS_MSRP

                                                            , EBS_FLO_COST EBS_FLO_COST, EBS_BMF_COST EBS_BMF_COST, EBS_FLO_BUYER EBS_FLO_BUYER, EBS_BMF_BUYER EBS_BMF_BUYER, EBS_APPRV_SUPPLIER_NAME EB

                                                            S_APPRV_SUPPLIER_NAME, EBS_APPRV_SUPPLIER_SITE EBS_APPRV_SUPPLIER_SITE, EBS_COUNTRY_OF_ORIGIN EBS_COUNTRY_OF_ORIGIN, EBS_MIN EBS_MIN, EBS_MA

                                                            X EBS_MAX, EBS_RETURNABLE EBS_RETURNABLE, EBS_SERIALIZED EBS_SERIALIZED, EBS_IMAGE EBS_IMAGE, EBS_ITEM_STATUS EBS_ITEM_STATUS, EBS_MFG_NAME

                                                            EBS_MFG_NAME from "XBSI"."XBSI_EBS_ITEM"

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      XBSI.XBSI_EBS_ITEM: ORA-00923: FROM keyword not found where expected

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 1:1 ddl_id=27878] ORA-00923: FROM keyword not found where expected SQL: begin ad_zd_table.upgrade('XBSI', 'XBSI_EBS_ITEM'); e

                                                            nd;

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      ERROR: ORA-00923: FROM keyword not found where expectedSQL(CLOB): create or replace editioning view  "XBSI"."XBSI_EBS_ITEM#" as select Item

                                                            Number Item Number, EBS_DESCRIPTION EBS_DESCRIPTION, EBS_ITEM_TYPE EBS_ITEM_TYPE, EBS_MFG_CODE EBS_MFG_CODE, EBS_PRICE_CATEGORY EBS_PRICE_CA

                                                            TEGORY, EBS_ISTORE_CATEGORY EBS_ISTORE_CATEGORY, EBS_HARMONIZED_CODE EBS_HARMONIZED_CODE, EBS_SHIP_WEIGHT EBS_SHIP_WEIGHT, EBS_MSRP EBS_MSRP

                                                            , EBS_FLO_COST EBS_FLO_COST, EBS_BMF_COST EBS_BMF_COST, EBS_FLO_BUYER EBS_FLO_BUYER, EBS_BMF_BUYER EBS_BMF_BUYER, EBS_APPRV_SUPPLIER_NAME EB

                                                            S_APPRV_SUPPLIER_NAME, EBS_APPRV_SUPPLIER_SITE EBS_APPRV_SUPPLIER_SITE, EBS_COUNTRY_OF_ORIGIN EBS_COUNTRY_OF_ORIGIN, EBS_MIN EBS_MIN, EBS_MA

                                                            X EBS_MAX, EBS_RETURNABLE EBS_RETURNABLE, EBS_SERIALIZED EBS_SERIALIZED, EBS_IMAGE EBS_IMAGE, EBS_ITEM_STATUS EBS_ITEM_STATUS, EBS_MFG_NAME

                                                            EBS_MFG_NAME from "XBSI"."XBSI_EBS_ITEM"

       

       

      ad.plsql.ad_zd_table.generate_ev           ERROR      XBSI.XBSI_EBS_ITEM: ORA-00923: FROM keyword not found where expected

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_TABLE 1:1 ddl_id=27878] ORA-00923: FROM keyword not found where expected SQL: begin ad_zd_table.upgrade('XBSI', 'XBSI_EBS_ITEM'); e

                                                            nd;

       

       

      ad.plsql.ad_zd_mview.process_mv            ERROR      ORA-38818: illegal reference to editioned object INV.MTL_ONHAND_QUANTITIES_DETAIL#CREATE MATERIALIZED VIEW "XBSI"."ARCH_XX_EDI_832_846_RESV1

                                                            _MV"  ("INVENTORY_ITEM_ID", "ORGANIZATION_ID", "ON_HAND", "LAST_DATE")   ON PREBUILT TABLE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

                                                              REFRESH COMPLETE ON DEMAND

                                                              USING DEFAULT LOCAL ROLLBACK SEGMENT

                                                              USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

                                                               AS SELECT "A2"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID","A2"."ORGANIZATION_ID" "ORGANIZATION_ID",SUM("A2"."TRANSACTION_QUANTITY") "ON_HAND

                                                            ",MAX("A2"."LAST_UPDATE_DATE") "LAST_DATE" FROM "APPS"."MTL_ONHAND_QUANTITIES_DETAIL" "A2","APPS"."MTL_SECONDARY_INVENTORIES" "A1" WHERE "A2

                                                            "."ORGANIZATION_ID"="A1"."ORGANIZATION_ID" AND "A2"."SUBINVENTORY_CODE"="A1"."SECONDARY_INVENTORY_NAME" AND "A1"."INVENTORY_ATP_CODE"=1 AND

                                                            "A1"."RESERVABLE_TYPE"=1 GROUP BY "A2"."INVENTORY_ITEM_ID","A2"."ORGANIZATION_ID"

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_MVIEW 1:1 ddl_id=10646] ORA-38818: illegal reference to editioned object INV.MTL_ONHAND_QUANTITIES_DETAIL# SQL: begin APPS.ad_zd_mv

                                                            iew.upgrade('XBSI','ARCH_XX_EDI_832_846_RESV1_MV'); end;

       

       

      ad.plsql.ad_zd_mview.process_mv            ERROR      ORA-38818: illegal reference to editioned object INV.MTL_DEMAND#CREATE MATERIALIZED VIEW "XBSI"."XX_EDI_832_846_RESERVQTY1_MV"  ("ORGANIZATI

                                                            ON_ID", "INVENTORY_ITEM_ID", "RESERVE_QTY")   ON PREBUILT TABLE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

                                                              REFRESH COMPLETE ON DEMAND

                                                              USING DEFAULT LOCAL ROLLBACK SEGMENT

                                                              USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

                                                               AS SELECT "A1"."ORGANIZATION_ID" "ORGANIZATION_ID","A1"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID",SUM(NVL("A1"."PRIMARY_UOM_QUANTITY",0)) "

                                                            RESERVE_QTY" FROM "APPS"."MTL_DEMAND" "A1" GROUP BY "A1"."ORGANIZATION_ID","A1"."INVENTORY_ITEM_ID"

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_MVIEW 1:1 ddl_id=10647] ORA-38818: illegal reference to editioned object INV.MTL_DEMAND# SQL: begin APPS.ad_zd_mview.upgrade('XBSI'

                                                            ,'XX_EDI_832_846_RESERVQTY1_MV'); end;

       

       

      ad.plsql.ad_zd_mview.process_mv            ERROR      ORA-38818: illegal reference to editioned object INV.MTL_ONHAND_QUANTITIES_DETAIL#CREATE MATERIALIZED VIEW "XBSI"."ARCH_XX_EDI_832_846_RESV1

                                                            _MV"  ("INVENTORY_ITEM_ID", "ORGANIZATION_ID", "ON_HAND", "LAST_DATE")   ON PREBUILT TABLE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

                                                              REFRESH COMPLETE ON DEMAND

                                                              USING DEFAULT LOCAL ROLLBACK SEGMENT

                                                              USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

                                                               AS SELECT "A2"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID","A2"."ORGANIZATION_ID" "ORGANIZATION_ID",SUM("A2"."TRANSACTION_QUANTITY") "ON_HAND

                                                            ",MAX("A2"."LAST_UPDATE_DATE") "LAST_DATE" FROM "APPS"."MTL_ONHAND_QUANTITIES_DETAIL" "A2","APPS"."MTL_SECONDARY_INVENTORIES" "A1" WHERE "A2

                                                            "."ORGANIZATION_ID"="A1"."ORGANIZATION_ID" AND "A2"."SUBINVENTORY_CODE"="A1"."SECONDARY_INVENTORY_NAME" AND "A1"."INVENTORY_ATP_CODE"=1 AND

                                                            "A1"."RESERVABLE_TYPE"=1 GROUP BY "A2"."INVENTORY_ITEM_ID","A2"."ORGANIZATION_ID"

       

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_MVIEW 1:1 ddl_id=10646] ORA-38818: illegal reference to editioned object INV.MTL_ONHAND_QUANTITIES_DETAIL# SQL: begin APPS.ad_zd_mv

                                                            iew.upgrade('XBSI','ARCH_XX_EDI_832_846_RESV1_MV'); end;

      ad.plsql.ad_zd_mview.process_mv            ERROR      ORA-38818: illegal reference to editioned object INV.MTL_DEMAND#CREATE MATERIALIZED VIEW "XBSI"."XX_EDI_832_846_RESERVQTY1_MV"  ("ORGANIZATI

                                                            ON_ID", "INVENTORY_ITEM_ID", "RESERVE_QTY")   ON PREBUILT TABLE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

                                                              REFRESH COMPLETE ON DEMAND

                                                              USING DEFAULT LOCAL ROLLBACK SEGMENT

                                                              USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

                                                               AS SELECT "A1"."ORGANIZATION_ID" "ORGANIZATION_ID","A1"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID",SUM(NVL("A1"."PRIMARY_UOM_QUANTITY",0)) "

                                                            RESERVE_QTY" FROM "APPS"."MTL_DEMAND" "A1" GROUP BY "A1"."ORGANIZATION_ID","A1"."INVENTORY_ITEM_ID"

       

      ad.plsql.ad_zd_parallel_exec.execute       ERROR      [UPGRADE_MVIEW 1:1 ddl_id=10647] ORA-38818: illegal reference to editioned object INV.MTL_DEMAND# SQL: begin APPS.ad_zd_mview.upgrade('XBSI'

                                                            ,'XX_EDI_832_846_RESERVQTY1_MV'); end;

       

      60 rows selected.

      Elapsed: 00:00:22.68

       

      Thanks,

      Ramaraju

        • 1. Re: Online Patching Error Log
          Bashar.

          Hi,

           

          Please run these commands as APPS and post the results:

           

          alter package AD_ZD_TABLE compile body;

           

          show errors

           

          Regards,

          Bashar

          • 2. Re: Online Patching Error Log
            Ramaraju

            Hi,

            We have valid object. Please see below

            SQL> select owner,object_name,object_type,status from dba_objects where object_name like'AD_ZD_TABLE';

            OWNER     OBJECT_NAME     OBJECT_TYPE    STATUS

            --------------------------------------------------------------------------------

            APPS     AD_ZD_TABLE     PACKAGE              VALID

            APPS     AD_ZD_TABLE     PACKAGE BODY    VALID

             

            Thanks,

            Ramaraju

            • 3. Re: Online Patching Error Log
              Ramaraju

              SQL> alter package AD_ZD_TABLE compile body;

               

              Package body altered.

               

              SQL> sho error

              No errors.

              • 4. Re: Online Patching Error Log
                Bashar.

                You have 3 kinds of errors:

                 

                1- ORA-04061: I recommend to run the SQL statements in the error description such as the following two statements:

                 

                create or replace synonym "APPS"."AP_CHECKS_ALL" for "AP"."AP_CHECKS_ALL#";

                begin ad_zd_table.upgrade('APPLSYS', 'FND_OBJECT_TYPE_MEMBERS'); end;

                 

                2- ORA-00923: Make sure that the columns and aliases in the custom views do not contain a space (item_number or itemnumber but not item number)

                 

                3- ORA-38818: Follow the below documents to enable editioning for custom schemas and objects.

                 

                Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

                Creating a Custom Application in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)

                 

                Regards,

                Bashar

                • 5. Re: Online Patching Error Log
                  Ramaraju

                  SQL> create or replace synonym "APPS"."AP_CHECKS_ALL" for "AP"."AP_CHECKS_ALL#";

                  Synonym created.

                   

                  SQL> begin ad_zd_table.upgrade('APPLSYS', 'FND_OBJECT_TYPE_MEMBERS'); end;

                    2  /

                  PL/SQL procedure successfully completed.

                   

                  After this I executed ADZDDBCC.sql again, but getting same error.

                   

                  Thanks,

                  Ramaraju

                  • 6. Re: Online Patching Error Log
                    Bashar.

                    I advise to fix all the issues first and run the script.

                    Take a look at section 20 in the output and make sure that it does not show any records.

                     

                    If any of the reported errors cannot be fixed then I recommend to log a SR.

                     

                    Regards,

                    Bashar

                    • 7. Re: Online Patching Error Log
                      Ramaraju

                      DOC>  **********************************************************************

                      DOC>  SECTION-20  [full]

                      DOC>  **********************************************************************

                      DOC>  "Table must have an editioning view."

                      DOC>

                      DOC>   - P2: These tables may not be patched using online patching.

                      DOC>   - Fix:  Execute the table upgrade procedure.

                      DOC>       SQL> exec ad_zd_table.upgrade(table_owner, new_table_name)

                      DOC>   Note: Tables that are dynamically created by application runtime

                      DOC>         can be ignored.

                      DOC>   Note: Tables that end with "_A" are typically audit tables

                      DOC>         by the Audit Trail feature, and can be ignored.

                      DOC>   Note: This check is only active after Online Patching Enablement.

                      DOC>#

                      OWNER            TABLE_NAME

                      ---------------- ------------------------------

                      XBSI             XBSI_EBS_ITEM

                      XBSI             XX_EDI_832_846_RESERVQTY1_MV

                      2 rows selected.

                      Elapsed: 00:00:18.11

                       

                      XBSI is the custom schema. Please advice.

                       

                      Thanks,

                      Ramaraju

                      • 8. Re: Online Patching Error Log
                        Bashar.

                        I already told you in a prior post that you need to handle the ORA-38818 error.

                        Once you handle that, on the next run this section will be empty.

                         

                        Regards,

                        Bashar