5 Replies Latest reply on Apr 15, 2015 3:19 PM by user10664242

    Error while applying patch the EBS R12.2 upgrade driver

    1005557

      Hi, While running adpatch options=nocopyportion,nogenerateportion for an 11i to R12.2 upgrade we are getting the following error:

       

      About to update the current-view snapshot: Thu Mar 12 2015 16:08:18

        Updating the current-view snapshot...


      Done updating the current-view snapshot: Thu Mar 12 2015 16:08:24

      Completed uploading Java objects to patch history tables.

      1 "left over" javaupdates.txt files uploaded to DB: Thu Mar 12 2015 16:08:17

      0 patches uploaded from the ADPSV format patch history files: Thu Mar 12 2015 16:08:24


      Uploading /u001/ebsr12/fs1/EBSapps/appl/admin/TFMSD5/adpsv20150312152342_preinst.txt...
      > Inserted 1 patch history records (total).

      ADOP record out.

      AutoPatch warning:
      Error while inserting into AD_TRACKABLE_ENTITIES
        ABBREVIATION ... csc
        NAME ........... Customer Care
        TYPE ........... product
        BASELINE .......
        CODELEVEL ......

      ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TRACKABLE_ENTITIES"."CODELEVEL")

      Freeing includes hash table
      Freeing fixes hash table
      Freeing basedons hash table
      Freeing entities hash table

      0 patches uploaded from the ADPSV format preinstall patch history files: Thu Mar 12 2015 16:08:24


      Uploading information about files copied during the previous runs ...

      0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Mar 12 2015 16:08:25

           ****************** E N D   O F   U P L O A D ******************

       

      Thank you,

       

      J

        • 1. Re: Error while applying patch the EBS R12.2 upgrade driver
          user10664242

          Did you ever find a fix for this, we're encountering the same problem.

          • 3. Re: Error while applying patch the EBS R12.2 upgrade driver
            user10664242

            Our problem is a bit later in the process, but very similar to the OP.  The records do exist in AD_TRACKABLE_ENTITIES, but reflect the incorrect codelevel because they were not updated due to the ORA- error

             

            AutoPatch warning:
            Error while inserting into AD_TRACKABLE_ENTITIES
              ABBREVIATION ... csc
              NAME ........... Customer Care
              TYPE ........... product
              BASELINE .......
              CODELEVEL ......

            ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TRACKABLE_ENTITIES"."CODELEVEL")

            Freeing includes hash table
            Freeing fixes hash table
            Freeing basedons hash table
            Freeing entities hash table


            Uploading /u01/app/oracle/fs1/EBSapps/appl/admin/EBS/adpsv20150329133324_preinst.txt...
            > Inserted 3 patch history records (total).

            ADOP record out.

            AutoPatch warning:
            Error while inserting into AD_TRACKABLE_ENTITIES
              ABBREVIATION ... csc
              NAME ........... Customer Care
              TYPE ........... product
              BASELINE .......
              CODELEVEL ......

            ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TRACKABLE_ENTITIES"."CODELEVEL")

            Freeing includes hash table
            Freeing fixes hash table
            Freeing basedons hash table
            Freeing entities hash table

             

             

            SQL> select * from ad_trackable_entities where abbreviation = 'csc';

            ABBREVIA NAME
            -------- --------------------------------------------------
            TYPE                           U L
            ------------------------------ - -
            CODELEVEL
            --------------------------------------------------------------------------------
            BASELINE
            --------------------------------------------------------------------------------
            csc      Oracle Customer Care
            product
            R12
            R12

             

            This becomes problematic when attempting to apply the 12.2.4 upgrade driver

             

             

            AutoPatch error:

            --------

            This patch is not compatible with your current codelines.

            This patch is compatible with: entity 'csc' - codeline 'R12.CSC.C'.

            Your current on-site codeline for the entity 'csc' is: 'R12.CSC.R12'.

             

            You should not apply this patch.

            Apply an equivalent patch that is compatible with your

            current codelines instead.

            • 4. Re: Error while applying patch the EBS R12.2 upgrade driver
              ;) ApPsMasTi ;)

              please log an SR with oracle
              they will suggest you whether you can skip this worker or not

               

              AppsmAsti
              Sharing is Caring

              • 5. Re: Error while applying patch the EBS R12.2 upgrade driver
                user10664242

                I already did.  It's moving slowly, so I was checking out other resources.  Thanks!