3 Replies Latest reply: Jan 12, 2013 1:22 PM by Hussein Sawwan-Oracle RSS

    R12.HR_PF.A.DELTA.10

    user3714906
      Hi,

      We are on 12.0.6 Release,I am applying patch 13774477 (R12.HR_PF.A.DELTA.10) as a part of ongoing SR.

      During the patch application I got below error

      In worker log file

      ---------------------------------------------------------
      syntax error occurred at line 889 in file /u02/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscprof.lct
      Current system time is Mon Jan 7 12:36:36 2013


      A syntax error occurred at line 889 in file /u02/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscprof.lct
      Current system time is Mon Jan 7 12:36:37 2013


      A syntax error occurred at line 889 in file /u02/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscprof.lct
      ~
      -------------------------------------------------------------

      and in Alert log file

      ORA-12012: error on auto execute of job 7804
      ORA-04063: view "APPS.PAY_AU_ASG_LEAVE_TAKEN_V" has errors
      ORA-06512: at line 1
      Mon Jan 7 11:37:04 2013
      Errors in file /u01/oracle/db/tech_st/10.2.0/admin/TEST_test/bdump/test_j001_1421.trc:
      ORA-12012: error on auto execute of job 7837
      ORA-04063: view "APPS.PAY_AC_EMP_DEDN_ACTION_INFO_V" has errors

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

      Please suggest

      Regards

      Edited by: user3714906 on Jan 7, 2013 3:32 AM
        • 1. Re: R12.HR_PF.A.DELTA.10
          Hussein Sawwan-Oracle
          We are on 12.0.6 Release,I am applying patch 13774477 (R12.HR_PF.A.DELTA.10) as a part of ongoing SR.
          Did you apply all pre-req. patches?
          ORA-12012: error on auto execute of job 7804
          ORA-04063: view "APPS.PAY_AU_ASG_LEAVE_TAKEN_V" has errors
          ORA-06512: at line 1
          Mon Jan 7 11:37:04 2013
          Errors in file /u01/oracle/db/tech_st/10.2.0/admin/TEST_test/bdump/test_j001_1421.trc:
          ORA-12012: error on auto execute of job 7837
          ORA-04063: view "APPS.PAY_AC_EMP_DEDN_ACTION_INFO_V" has errors
          Is this view valid? Please compile it manually and check then. If you still get the same error, please post the contents of the trace file here.

          Thanks,
          Hussein
          • 2. Re: R12.HR_PF.A.DELTA.10
            user3714906
            Hi Hussein,

            I created a new clone of production and re-applied this patch, but this time I am getting below error

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

            sqlplus -s APPS/***** @/u02/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFDDATES.pls
            CREATE or REPLACE PACKAGE FND_DATE as
            *
            ERROR at line 1:
            ORA-04021: timeout occurred while waiting to lock object APPS.FND_DATE




            Time when worker failed: Sat Jan 12 2013 16:47:03
            --------------------------------------------------------------------------------------------

            I checked there are no locks in the database neither on any object

            Please suggest

            Edited by: user3714906 on Jan 12, 2013 5:56 AM
            • 3. Re: R12.HR_PF.A.DELTA.10
              Hussein Sawwan-Oracle
              user3714906 wrote:
              Hi Hussein,

              I created a new clone of production and re-applied this patch, but this time I am getting below error

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

              sqlplus -s APPS/***** @/u02/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFDDATES.pls
              CREATE or REPLACE PACKAGE FND_DATE as
              *
              ERROR at line 1:
              ORA-04021: timeout occurred while waiting to lock object APPS.FND_DATE




              Time when worker failed: Sat Jan 12 2013 16:47:03
              --------------------------------------------------------------------------------------------

              I checked there are no locks in the database neither on any object

              Please suggest
              The error indicates that there is a lock (or more than one) in the database and you have to release it.

              Please make sure all the application services are down, and bounce the database then try again.

              OERR: ORA 4021 time-out occurred while waiting to lock object <name> [ID 19833.1]

              Thanks,
              Hussein