This discussion is archived
7 Replies Latest reply: May 22, 2011 8:29 PM by 838779 RSS

Purge Concurrent Request and/or Manager Data

838779 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points