1 Reply Latest reply: Jun 2, 2011 8:49 AM by Hussein Sawwan-Oracle RSS

    Stage outcome with error in oracle apps

    865811
      Hi,

      I am having a request set in which first stage is a Pl/Sql extract and second stage is a oracle report in oracle apps.
      When I am running the request set my extract is completing normally but my report is giving following error:

      But when I am executing my Pl/sql extract and my report separately through single request then both are completing normally and giving me the output.

      Please help me out with the reason and solution of the below error.


      ---------------------------------------------------------------------------
      General Ledger: Version : 11.5.0 Copyright (c) 1979, 1999, Oracle Corporation.
      All rights reserved. FNDRSSUB2294 module: Request Set PA0400- New
      ---------------------------------------------------------------------------
      Current system time is 02-JUN-2011 03:48:30
      ---------------------------------------------------------------------------
      **Starts**02-JUN-2011 03:48:30 **Ends**02-JUN-2011 03:48:30 Request submitted
      for stage Paid_EXTRACT - Paid Type - Commercial (10).
      ---------------------------------------------------------------------------
      Current system time is 02-JUN-2011 03:48:30
      ---------------------------------------------------------------------------
      Request restarted at :02-JUN-2011 03:54:33 **Starts**02-JUN-2011 03:54:33
      **Ends**02-JUN-2011 03:54:33 Request submitted for stage PC0400 New Report -
      Type - Commercial (20).
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      Current system time is 02-JUN-2011 03:54:33
      ---------------------------------------------------------------------------
      Request restarted at :02-JUN-2011 03:54:34 **Starts**02-JUN-2011 03:54:34
      **Ends**02-JUN-2011 03:54:34 The set completed normally with outcome Error. The
      outcome was determined by the stage PC0400 New Report - Type - Commercial (20).
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      Executing request completion options... Finished executing request completion
      options.
      ---------------------------------------------------------------------------
      Concurrent request completed Current system time is 02-JUN-2011 03:54:34
      ---------------------------------------------------------------------------


      Thanks in advance.
        • 1. Re: Stage outcome with error in oracle apps
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.

          Was this working before? If yes, any changes have been done recently?

          Please see if these docs help.

          FNDRSSUB Set Completed Normally With Outcome Error due to FADEPR [ID 298055.1]
          FNDRSSUB: Report Set Mass Addition Delete Completes in Error [ID 339424.1]
          GENERATE ACCOUNTS - FAGDA COMPLETES WITH ERROR [ID 1074299.6]
          Rollback Depreciation (FADRB) Process Completed With Outcome Error [ID 133620.1]

          Thanks,
          Hussein