7 Replies Latest reply: May 22, 2011 10:29 PM by 838779 RSS

    Purge Concurrent Request and/or Manager Data

    838779
      Hi,

      I got an error when execute Purge Concurrent Request and/or Manager Data after upgrade the Application from R12.1.1 to R12.1.3

      The log file :
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      Application Object Library: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      FNDCPPUR module: Purge Concurrent Request and/or Manager Data
      ---------------------------------------------------------------------------

      Current system time is 07-MAY-2011 10:39:39

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

      APP-FND-01564: ORACLE error 1 in request

      Cause: request failed due to ORA-00001: unique constraint (%s.%s) violated
      .

      The SQL statement being executed at the time of the error was: and was executed from the file .
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...

      Output file size:
      249


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Exceptions posted by this request:
      Could not purge concurrent request records and request log/output files
      Concurrent Request for "Purge Concurrent Request and/or Manager Data" has completed with error.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 07-MAY-2011 10:39:44

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

      Please Helpp....

      Thank you.
      Jimmy
        • 1. Re: Purge Concurrent Request and/or Manager Data
          Hussein Sawwan-Oracle
          Has this ever worked?

          Can you find any errors in the database?

          Please review these docs and see if it helps.

          FDPRRC Failed Due to ORA-00001:Unique Constraint (APPLSYS.FND_CONC_REQUEST_ARGUMENTS_U1) Violated [ID 824529.1]
          Error APP-FND-01564 ORA-00001 when Starting the Concurrent Managers [ID 552142.1]

          I would also suggest yo enable trace/debug for this concurrent program, submit it again, and check the concurrent request log file then.

          Thanks,
          Hussein
          • 2. Re: Purge Concurrent Request and/or Manager Data
            838779
            Hi,

            Thank you for your respon, before I upgrade to R12.1.3 it was working fine.
            I'm checking your doc.


            Thank you
            Jimmy
            • 3. Re: Purge Concurrent Request and/or Manager Data
              838779
              Hi Hussein,

              I checked all the document, but it doesn't help.
              1. I tried doc. 824529.1, the sequence is ok.
              2. I tried doc. 552142.1 and still error.

              Any suggest.. ? please help.
              Thank you for your attention.

              Regards,
              Jimmy
              • 4. Re: Purge Concurrent Request and/or Manager Data
                Hussein Sawwan-Oracle
                Jimmy,

                Please enable trace/debug for this concurrent program, submit it again and check the log file then.

                Also, please confirm that you have no invalid objects in the database that could be relevant.

                Have you tried to relink FNDCPPUR via adadmin and see if it helps?

                Thanks,
                Hussein
                • 5. Re: Purge Concurrent Request and/or Manager Data
                  838779
                  Hi Hussein,

                  the trace/debug is enabled now for this concurrent program.
                  the log file as bellow:
                  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                  ---------------------------------------------------------------------------
                  Application Object Library: Version : 12.0.0

                  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                  FNDCPPUR module: Purge Concurrent Request and/or Manager Data
                  ---------------------------------------------------------------------------

                  Current system time is 21-MAY-2011 12:51:01

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

                  APP-FND-01564: ORACLE error 1 in request

                  Cause: request failed due to ORA-00001: unique constraint (%s.%s) violated
                  .

                  The SQL statement being executed at the time of the error was: and was executed from the file .
                  ---------------------------------------------------------------------------
                  Start of log messages from FND_FILE
                  ---------------------------------------------------------------------------
                  ---------------------------------------------------------------------------
                  End of log messages from FND_FILE
                  ---------------------------------------------------------------------------


                  ---------------------------------------------------------------------------
                  Executing request completion options...

                  Output file size:
                  249


                  Finished executing request completion options.

                  ---------------------------------------------------------------------------
                  Exceptions posted by this request:
                  Could not purge concurrent request records and request log/output files
                  Concurrent Request for "Purge Concurrent Request and/or Manager Data" has completed with error.

                  ---------------------------------------------------------------------------
                  Concurrent request completed
                  Current system time is 21-MAY-2011 12:51:04

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

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

                  the total of invalid object is 285, I tried to compile the invalid object twice, but it still 285 invalid objects.

                  the FNDCPPUR has been relink, but it doesn't help.

                  Please advice.

                  Regards,
                  Jimmy
                  • 6. Re: Purge Concurrent Request and/or Manager Data
                    Hussein Sawwan-Oracle
                    Jimmy,

                    Do you have any invalid objects which start with FND_*? If yes, compile it manually and post the error here.

                    I would also suggest logging a SR.

                    Thanks,
                    Hussein
                    • 7. Re: Purge Concurrent Request and/or Manager Data
                      838779
                      Hi Hussein,

                      there are no invalid objects which start with FND_*?
                      Ok, I will create a SR for this problem.

                      Thank you for your support.

                      Regards,
                      Siagian