0 Replies Latest reply on Aug 8, 2018 7:27 AM by Srinadh.P

    Patch 26965486:R12.SCM_PF.C is failing with an error

    Srinadh.P

      Hi All,

       

      When I am applying the above patch using adop utility it is failing with status 1 after checking log file it is showing that invak.jlt file is failed on worker 1.

       

      So I checked worker log files and there i came to know that invoking akload utility returned an error and lot of ora errors are there like ora 04061 apps.ak_on_objects_pvt_ltd has been invalidated.

       

      Please help me out to resolve this issue. Check the worker log file which I attached here.

       

       

       

      ************* Start of AD Worker session *************

      AD Worker version: 12.2.0

      AD Worker started at: Tue Aug 07 2018 11:58:27

       

       

      APPL_TOP is set to /opt/ebs/applmgr/VIS/fs2/EBSapps/appl

       

       

      Worker id = 1

      Started by: adpatch

       

       

      NLS_LANG value from the environment is    : AMERICAN_AMERICA.AL32UTF8

      NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.AL32UTF8

       

       

      Connecting to SYSTEM......Connected successfully.

       

       

      Already asked for the ORACLE username and password

      of Application Object Library.

      (The given username/password was: APPLSYS/*****)

       

       

      Connecting to APPS......Connected successfully.

       

       

       

       

      The status of various features in this run of AD Worker is:

       

       

                                                 <-Feature version in->

      Feature                          Active?   APPLTOP    Data model    Flags

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

      CHECKFILE                        Yes       1          1             Y N N Y N Y

      PREREQ                           Yes       6          6             Y N N Y N Y

      CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N

      PATCH_TIMING                     Yes       2          2             Y N N Y N Y

      PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y

      SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y

      JAVA_WORKER                      Yes       1          1             Y N N Y N Y

      CODELEVEL                        Yes       1          1             Y N N Y N Y

       

       

       

       

       

       

      Reading product information from file...

       

       

      Reading language and territory information from file...

       

       

      Reading language information from applUS.txt ...

       

       

      Currently, the following language is installed:

       

       

      Code   Language                                Status

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

      US     American English                        Base       

       

       

      Your base language will be AMERICAN.

       

       

      Ready to run jobs.

      Setting parallel context: PARALLEL AUTOPATCH AT R120

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 11:58:28

       

       

       

       

      Start time for file is: Tue Aug 07 2018 11:58:28

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

       

       

      adjava -ms128m -mx256m -Dad.worker_id=1 oracle.apps.ad.worker.AdJavaWorker "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" APPS ***** thin 1 /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/adUtilMapNew.txt

       

       

       

       

                           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:

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

       

       

        Calling /opt/ebs/applmgr/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

       

       

      Invoking Utility FndXdfCmp ...

      Class: oracle.apps.fnd.odf2.FndXdfCmp

      Method: applyXDF

      Arguments: &un_wms &pw_wms &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath_wms_patch/115/xdf_WMS_WAVEPLAN_TASKS_TEMP.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=small parallel_index_threshold=20000

      **** Reseting package states in the current session ****

      TimeStamp : [Tue Aug 07 11:58:35 EDT 2018]

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

       

       

      XDF file application started. Current time is: Tue Aug 07 11:58:35 EDT 2018

       

       

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

      Applying XDF file : /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/wms/12.0.0/patch/115/xdf/WMS_WAVEPLAN_TASKS_TEMP.xdf

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

       

       

       

       

      Table Name is WMS_WAVEPLAN_TASKS_TEMP6

      Table does not exist in the target database

      Executing create Statement

      Create Statement is

       

       

       

       

            CREATE GLOBAL TEMPORARY TABLE "WMS"."WMS_WAVEPLAN_TASKS_TEMP6"

         ( "TASK_ID" NUMBER,

      "TRANSACTION_TEMP_ID" NUMBER,

      "PARENT_LINE_ID" NUMBER,

      "INVENTORY_ITEM_ID" NUMBER,

      "ITEM" VARCHAR2(240),

      "ITEM_DESCRIPTION" VARCHAR2(240),

      "UNIT_WEIGHT" NUMBER,

      "WEIGHT_UOM_CODE" VARCHAR2(3),

      "DISPLAY_WEIGHT" NUMBER,

      "UNIT_VOLUME" NUMBER,

      "VOLUME_UOM_CODE" VARCHAR2(3),

      "DISPLAY_VOLUME" NUMBER,

      "TIME_ESTIMATE" NUMBER,

      "ORGANIZATION_ID" NUMBER,

      "ORGANIZATION_CODE" VARCHAR2(3),

      "REVISION" VARCHAR2(3),

      "SUBINVENTORY" VARCHAR2(10),

      "LOCATOR_ID" NUMBER,

      "LOCATOR" VARCHAR2(240),

      "TRANSACTION_TYPE_ID" NUMBER,

      "TRANSACTION_ACTION_ID" NUMBER,

      "TRANSACTION_SOURCE_TYPE_ID" NUMBER,

      "TRANSACTION_SOURCE_TYPE" VARCHAR2(240),

      "TRANSACTION_SOURCE_ID" NUMBER,

      "TRANSACTION_SOURCE_LINE_ID" NUMBER,

      "TO_ORGANIZATION_ID" NUMBER,

      "TO_ORGANIZATION_CODE" VARCHAR2(3),

      "TO_SUBINVENTORY" VARCHAR2(10),

      "TO_LOCATOR_ID" NUMBER,

      "TO_LOCATOR" VARCHAR2(204),

      "TRANSACTION_UOM" VARCHAR2(3),

      "TRANSACTION_QUANTITY" NUMBER,

      "USER_TASK_TYPE_ID" NUMBER,

      "USER_TASK_TYPE" VARCHAR2(4),

      "PERSON_ID" NUMBER,

      "PERSON_ID_ORIGINAL" NUMBER,

      "PERSON" VARCHAR2(240),

      "EFFECTIVE_START_DATE" DATE,

      "EFFECTIVE_END_DATE" DATE,

      "PERSON_RESOURCE_ID" NUMBER,

      "PERSON_RESOURCE_CODE" VARCHAR2(10),

      "MACHINE_RESOURCE_ID" NUMBER,

      "MACHINE_RESOURCE_CODE" VARCHAR2(10),

      "EQUIPMENT_INSTANCE" VARCHAR2(30),

      "STATUS_ID" NUMBER,

      "STATUS_ID_ORIGINAL" NUMBER,

      "STATUS" VARCHAR2(80),

      "CREATION_TIME" DATE,

      "DISPATCHED_TIME" DATE,

      "LOADED_TIME" DATE,

      "DROP_OFF_TIME" DATE,

      "MMTT_LAST_UPDATE_DATE" DATE,

      "MMTT_LAST_UPDATED_BY" NUMBER,

      "WDT_LAST_UPDATE_DATE" DATE,

      "WDT_LAST_UPDATED_BY" NUMBER,

      "PRIORITY" NUMBER,

      "PRIORITY_ORIGINAL" NUMBER,

      "TASK_TYPE_ID" NUMBER,

      "TASK_TYPE" VARCHAR2(80),

      "MOVE_ORDER_LINE_ID" NUMBER,

      "PICK_SLIP_NUMBER" NUMBER,

      "CARTONIZATION_ID" NUMBER,

      "ALLOCATED_LPN_ID" NUMBER,

      "CONTAINER_ITEM_ID" NUMBER,

      "CONTENT_LPN_ID" NUMBER,

      "TO_LPN_ID" NUMBER,

      "CONTAINER_ITEM" VARCHAR2(240),

      "CARTONIZATION_LPN" VARCHAR2(30),

      "ALLOCATED_LPN" VARCHAR2(30),

      "CONTENT_LPN" VARCHAR2(30),

      "TO_LPN" VARCHAR2(30),

      "REFERENCE" VARCHAR2(240),

      "REFERENCE_ID" NUMBER,

      "CUSTOMER_ID" NUMBER,

      "CUSTOMER" VARCHAR2(240),

      "SHIP_TO_LOCATION_ID" NUMBER,

      "SHIP_TO_STATE" VARCHAR2(60),

      "SHIP_TO_COUNTRY" VARCHAR2(60),

      "SHIP_TO_POSTAL_CODE" VARCHAR2(60),

      "DELIVERY_ID" NUMBER,

      "DELIVERY" VARCHAR2(30),

      "SHIP_METHOD" VARCHAR2(80),

      "CARRIER_ID" NUMBER,

      "CARRIER" VARCHAR2(360),

      "SHIPMENT_DATE" DATE,

      "SHIPMENT_PRIORITY" VARCHAR2(80),

      "WIP_ENTITY_TYPE" NUMBER,

      "WIP_ENTITY_ID" NUMBER,

      "ASSEMBLY_ID" NUMBER,

      "ASSEMBLY" VARCHAR2(240),

      "LINE_ID" NUMBER,

      "LINE" VARCHAR2(10),

      "DEPARTMENT_ID" NUMBER,

      "DEPARTMENT" VARCHAR2(10),

      "SOURCE_HEADER" VARCHAR2(240),

      "LINE_NUMBER" VARCHAR2(240),

      "OPERATION_PLAN_ID" NUMBER,

      "OPERATION_PLAN" VARCHAR2(255),

      "RESULT" VARCHAR2(1),

      "ERROR" VARCHAR2(240),

      "IS_MODIFIED" VARCHAR2(1),

      "EXPANSION_CODE" VARCHAR2(1),

      "FROM_LPN" VARCHAR2(30),

      "FROM_LPN_ID" NUMBER,

      "NUM_OF_CHILD_TASKS" NUMBER,

      "OPERATION_SEQUENCE" NUMBER,

      "OP_PLAN_INSTANCE_ID" NUMBER,

      "PLANS_TASKS" VARCHAR2(80),

      "TRANSACTION_SET_ID" NUMBER,

      "PICKED_LPN_ID" NUMBER,

      "PICKED_LPN" VARCHAR2(30),

      "LOADED_LPN" VARCHAR2(30),

      "LOADED_LPN_ID" NUMBER,

      "DROP_LPN" VARCHAR2(30),

      "SECONDARY_TRANSACTION_QUANTITY" NUMBER,

      "SECONDARY_TRANSACTION_UOM" VARCHAR2(3),

      "PRIMARY_PRODUCT" VARCHAR2(240),

      "LOAD_SEQ_NUMBER" NUMBER,

      "WAVE_HEADER_ID" NUMBER,

      "TRIP_ID" NUMBER,

      "TRIP_NAME" VARCHAR2(32),

      "ZONE" VARCHAR2(256),

      "TO_ZONE" VARCHAR2(256),

      "OUTERMOST_LPN" VARCHAR2(30)

         )  ON COMMIT PRESERVE ROWS

       

      Start time for statement above is Tue Aug 07 11:58:38 EDT 2018

      End time for statement above is Tue Aug 07 11:58:39 EDT 2018

       

       

      Executing grants on WMS_WAVEPLAN_TASKS_TEMP6 to APPS

      GRANT ALL ON WMS.WMS_WAVEPLAN_TASKS_TEMP6 TO APPS WITH GRANT OPTION

      Synonym exists at the target DB but it does not match.

      Hence drop and recreate the synonym

      Dropping synonym  WMS_WAVEPLAN_TASKS_TEMP

      DROP SYNONYM WMS_WAVEPLAN_TASKS_TEMP

      Drop Synonym Successful.

       

       

      Creating synonym  CREATE SYNONYM WMS_WAVEPLAN_TASKS_TEMP FOR WMS.WMS_WAVEPLAN_TASKS_TEMP6

      Synonym created

       

       

      Index hashcode(s) extracted from the XDF.

       

       

      Hashcodes generated for DB indexes.

       

       

      Index WMS_WAVEPLAN_TASKS_TEMP_N1 exists under WMS schema.

      Checking for differences

      Column_name and Uniqueness do not match for both file and DB Indexes

      Creating Revised index

      Drop query is DROP INDEX WMS."WMS~WAVEPLAN~TASKS~TEMP~N1"

      Drop query is DROP INDEX WMS."WMS~WAVEPLAN~TASKS~TEMP~N1"

       

       

      CREATE INDEX "WMS"."WMS~WAVEPLAN~TASKS~TEMP~N1" ON "WMS"."WMS_WAVEPLAN_TASKS_TEMP6" ("TRANSACTION_TEMP_ID", "TASK_TYPE_ID")

      Start time for statement above is Tue Aug 07 11:58:44 EDT 2018

      End time for statement above is Tue Aug 07 11:58:44 EDT 2018

      Index WMS_WAVEPLAN_TASKS_TEMP_N1 Created

       

       

      Index WMS_WAVEPLAN_TASKS_TEMP_N2 exists under WMS schema.

      Checking for differences

      Column_name and Uniqueness do not match for both file and DB Indexes

      Creating Revised index

      Drop query is DROP INDEX WMS."WMS~WAVEPLAN~TASKS~TEMP~N2"

      Drop query is DROP INDEX WMS."WMS~WAVEPLAN~TASKS~TEMP~N2"

       

       

      CREATE INDEX "WMS"."WMS~WAVEPLAN~TASKS~TEMP~N1" ON "WMS"."WMS_WAVEPLAN_TASKS_TEMP6" ("TRANSACTION_TEMP_ID", "TASK_TYPE_ID")

      Start time for statement above is Tue Aug 07 11:58:44 EDT 2018

      End time for statement above is Tue Aug 07 11:58:44 EDT 2018

      Index WMS_WAVEPLAN_TASKS_TEMP_N1 Created

       

       

      CREATE INDEX "WMS"."WMS~WAVEPLAN~TASKS~TEMP~N2" ON "WMS"."WMS_WAVEPLAN_TASKS_TEMP6" ("RESULT")

      Start time for statement above is Tue Aug 07 11:58:44 EDT 2018

      End time for statement above is Tue Aug 07 11:58:44 EDT 2018

      Index WMS_WAVEPLAN_TASKS_TEMP_N2 Created

       

       

       

       

       

       

      Performing AOL meta data updates

      Number of columns for the table in the xml file is 124

      Attempting to update fnd tablespace meta data

      Upload of Fnd_Object_Tablespaces is successful

      AOL metadata updated successfully.

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

      Done calling the utility function. Return Code = [0] TimeStamp = [Tue Aug 07 12:35:36 EDT 2018]

      Updating task with status 0

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:36:05

      Java worker is exiting ...

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:41:10

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:41:11

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

       

       

      adjava -ms128m -mx256m -Dad.worker_id=1 oracle.apps.ad.worker.AdJavaWorker "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" APPS ***** thin 1 /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/adUtilMapNew.txt

       

       

       

       

                           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:

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

       

       

        Calling /opt/ebs/applmgr/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

       

       

      Invoking Utility FndXdfCmp ...

      Class: oracle.apps.fnd.odf2.FndXdfCmp

      Method: applyXDF

      Arguments: &un_wms &pw_wms &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath_wms_patch/115/xdf_WMS_WAVEPLAN_TASKS_TEMP.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=large parallel_index_threshold=20000

      **** Reseting package states in the current session ****

      TimeStamp : [Tue Aug 07 12:41:29 EDT 2018]

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

       

       

      XDF file application started. Current time is: Tue Aug 07 12:41:29 EDT 2018

       

       

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

      Applying XDF file : /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/wms/12.0.0/patch/115/xdf/WMS_WAVEPLAN_TASKS_TEMP.xdf

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

       

       

       

       

      Table Name is WMS_WAVEPLAN_TASKS_TEMP6

      Table exists in the target database

      Checking for differences

      Number of columns for the table in the xml file is 124

      The table definition in the XDF is the same as the one in DB.

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

      Done calling the utility function. Return Code = [0] TimeStamp = [Tue Aug 07 12:41:32 EDT 2018]

      Updating task with status 0

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:41:34

      Java worker is exiting ...

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:09

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:09

       

       

       

       

      Creating temporary archive file

      /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001invdbtrx.jar

      using input file

      /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/java/jar/invdbtrx.jar

      to load into database with arguments:

       

       

      -ms128m -mx256m  oracle.apps.ad.jri.admetarm -inputFile /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/java/jar/invdbtrx.jar -outputFile /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001invdbtrx.jar

       

       

       

       

        Temporarily resetting CLASSPATH to:

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

       

       

        Calling /opt/ebs/applmgr/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

      All processing successful; exiting with status 0

       

       

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

      Loading contents of archive file into database with arguments

       

       

      -ms128m -mx256m  oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001invdbtrx.jar

       

       

      Skipping LoadJava action: -ms128m -mx256m  oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001invdbtrx.jar

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:12

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:12

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:12

       

       

      **** Reseting package states in the current session ****

       

       

      Initializing PL/SQL direct execute exceptions hash table ...

       

       

      Done initializing PL/SQL direct execute exceptions hash table.

       

       

      Uploading PL/SQL direct execute exceptions from file ...

       

       

      Done uploading PL/SQL direct execute exceptions from file.

       

       

      Statement executed.

      Set the Module name & Client id successfully for file 'INVRCVLS.pls'

       

       

      package /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/patch/115/sql/INVRCVLS.pls

       

       

      Line 35: Changed as follows:

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

      CREATE OR REPLACE PACKAGE INV_UI_RCV_LOVS AS

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

      CREATE OR REPLACE PACKAGE INV_UI_RCV_LOVS AUTHID CURRENT_USER AS

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

       

       

       

       

      Done deactivating PL/SQL compilation.

       

       

      Statement executed.

       

       

      Done resetting PL/SQL compilation.

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:14

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:15

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:15

       

       

      **** Reseting package states in the current session ****

       

       

      Statement executed.

      Set the Module name & Client id successfully for file 'INVSTDRS.pls'

       

       

      package /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/patch/115/sql/INVSTDRS.pls

       

       

      Line 40: Changed as follows:

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

      CREATE OR REPLACE PACKAGE inv_rcv_std_rcpt_apis AS

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

      CREATE OR REPLACE PACKAGE inv_rcv_std_rcpt_apis AUTHID CURRENT_USER AS

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

       

       

       

       

      Done deactivating PL/SQL compilation.

       

       

      Statement executed.

       

       

      Done resetting PL/SQL compilation.

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:18

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:19

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:19

       

       

       

       

      Creating temporary archive file

      /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001wmscrtzn.jar

      using input file

      /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/wms/12.0.0/java/jar/wmscrtzn.jar

      to load into database with arguments:

       

       

      -ms128m -mx256m  oracle.apps.ad.jri.admetarm -inputFile /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/wms/12.0.0/java/jar/wmscrtzn.jar -outputFile /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001wmscrtzn.jar

       

       

       

       

        Temporarily resetting CLASSPATH to:

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

       

       

        Calling /opt/ebs/applmgr/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

      All processing successful; exiting with status 0

       

       

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

      Loading contents of archive file into database with arguments

       

       

      -ms128m -mx256m  oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001wmscrtzn.jar

       

       

      Skipping LoadJava action: -ms128m -mx256m  oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/VIS_patch/out/p001wmscrtzn.jar

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:19

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:21

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:21

       

       

      **** Reseting package states in the current session ****

       

       

      Statement executed.

      Set the Module name & Client id successfully for file 'INVDIRDB.pls'

       

       

      package /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/patch/115/sql/INVDIRDB.pls

       

       

      Done deactivating PL/SQL compilation.

       

       

      Statement executed.

       

       

      Done resetting PL/SQL compilation.

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:35

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:35

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:35

       

       

      **** Reseting package states in the current session ****

       

       

      Statement executed.

      Set the Module name & Client id successfully for file 'INVSTDDB.pls'

       

       

      package /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/inv/12.0.0/patch/115/sql/INVSTDDB.pls

       

       

      Done deactivating PL/SQL compilation.

       

       

      Statement executed.

       

       

      Done resetting PL/SQL compilation.

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 12:44:44

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 12:44:53

       

       

       

       

      Start time for file is: Tue Aug 07 2018 12:44:53

       

       

      sqlplus -s APPS/***** @/opt/ebs/applmgr/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/opt/ebs/applmgr/VIS/fs2/EBSapps/appl/ad/12.0.0/sql/adutlrcmp.sql '

      Connected.

       

       

      PL/SQL procedure successfully completed.

       

       

      Session Information:

       

       

      INSTANCE_NAME SCHEMA_NAME EDITION_NAME SYSDATE

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

      VIS APPS V_20180807_0833 2018-08-07 12:44

       

       

       

       

      Invalid Objects per Owner (before compile):

       

       

      OWNER    ACTUAL STUB   TOTAL

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

      APPS        15 891     906

       

       

       

       

      Compiling Objects...

       

       

      PL/SQL procedure successfully completed.

       

       

      Elapsed: 01:36:45.62

       

       

      Invalid Objects per Owner (after compile):

       

       

      OWNER    ACTUAL STUB   TOTAL

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

      APPS 0   53      53

       

       

       

       

      Commit complete.

       

       

       

       

       

       

      Time when worker completed job: Tue Aug 07 2018 14:22:54

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 14:23:07

       

       

       

       

      Start time for file is: Tue Aug 07 2018 14:23:07

       

       

      JDBC connect string from AD_APPS_JDBC_URL is

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))

       

       

       

       

      adjava -ms128m -mx256m -Dad.worker_id=1 oracle.apps.ad.worker.AdJavaWorker "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsol.algarytm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS_ebs_patch)(INSTANCE_NAME=VIS)))" APPS ***** thin 1 /opt/ebs/applmgr/VIS/fs2/EBSapps/appl/admin/adUtilMapNew.txt

       

       

       

       

                           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:

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

       

       

        Calling /opt/ebs/applmgr/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

       

       

      Invoking Utility akload ...

      Class: oracle.apps.ak.akload

      Method: processAK

      Arguments: &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr UPLOAD &fullpath_inv_patch/115/import/US_invak.jlt NCUPDATE &env=NLS_LANG

      **** Reseting package states in the current session ****

      TimeStamp : [Tue Aug 07 14:23:47 EDT 2018]

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

      Error: 4068 ORA-04068: existing state of packages has been discarded

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

      ORA-04065: not executed, altered or dropped package body "APPS.AK_ON_OBJECTS_PVT"

      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AK_ON_OBJECTS_PVT"

      ORA-06512: at "APPS.AK_UPLOAD_GRP", line 191

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

      ORA-04065: not executed, altered or dropped package body "APPS.AK_ON_OBJECTS_PVT"

      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AK_ON_OBJECTS_PVT"

      ORA-06512: at line 1

       

       

      java.sql.SQLException: ORA-04068: existing state of packages has been discarded

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

      ORA-04065: not executed, altered or dropped package body "APPS.AK_ON_OBJECTS_PVT"

      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AK_ON_OBJECTS_PVT"

      ORA-06512: at "APPS.AK_UPLOAD_GRP", line 191

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

      ORA-04065: not executed, altered or dropped package body "APPS.AK_ON_OBJECTS_PVT"

      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AK_ON_OBJECTS_PVT"

      ORA-06512: at line 1

       

       

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

      at oracle.apps.ak.akload.performUpload(akload.java:399)

      at oracle.apps.ak.akload.process(akload.java:199)

      at oracle.apps.ak.akload.processAK(akload.java:105)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:512)

      at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:358)

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

      Done calling the utility function. Return Code = [1] TimeStamp = [Tue Aug 07 14:33:18 EDT 2018]

      Updating task with status 1

       

       

      AD Worker error:

      The utility akload returned error for the above task.

       

       

      AD Worker error:

      The above program failed.  See the error messages listed

      above, if any, or see the log and output files for the program.

       

       

      Time when worker failed: Tue Aug 07 2018 14:33:40

       

       

       

       

      Time when worker started job: Tue Aug 07 2018 14:33:57

       

       

       

       

      Start time for file is: Tue Aug 07 2018 14:33:57

       

       

      Invoking Utility akload ...

      Class: oracle.apps.ak.akload

      Method: processAK

      Arguments: &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr UPLOAD &fullpath_inv_patch/115/import/US_invak.jlt NCUPDATE &env=NLS_LANG

      **** Reseting package states in the current session ****

      TimeStamp : [Tue Aug 07 14:33:57 EDT 2018]

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

      **********

      Start of Core Modules - AK Loader file Upload Session.

      TUE 08 07 2018 14:34:05

      **********

       

      ORA-06508: PL/SQL: could not find program unit being called in Package AK_ON_OB\

      JECTS_PVT Procedure Upload

      **********

      TUE 08 07 2018 15:13:43

      End of Core Modules - AK Loader file Upload Session.

      Error: java.lang.Exception: Error encountered while calling upload stored procedure

      java.lang.Exception: Error encountered while calling upload stored procedure

      at oracle.apps.ak.akload.performUpload(akload.java:421)

      at oracle.apps.ak.akload.process(akload.java:199)

      at oracle.apps.ak.akload.processAK(akload.java:105)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:512)

      at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:358)

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

      Done calling the utility function. Return Code = [1] TimeStamp = [Tue Aug 07 15:13:44 EDT 2018]

      Updating task with status 1

       

       

      AD Worker error:

      The utility akload returned error for the above task.

       

       

      AD Worker error:

      The above program failed.  See the error messages listed

      above, if any, or see the log and output files for the program.

       

       

      Time when worker failed: Tue Aug 07 2018 15:14:04

      The table ad_util_params doesnt have rows for processing OR the table itself isnt existing

       

       

       

       

      Manager says to quit.

       

       

       

       

      Time when worker quit: Tue Aug 07 2018 15:14:16

       

       

      AD Worker is complete.

       

       

      Errors and warnings are listed in the log file

      /opt/ebs/applmgr/VIS/fs_ne/EBSapps/log/adop/19/20180807_115007/apply/ebsol/26965486/log/adwork001.log

       

       

      and in other log files in the same directory.

       

       

       

      Regards

      Srinadh