This discussion is archived
1 Reply Latest reply: Jun 2, 2011 6:49 AM by Hussein Sawwan-Oracle RSS

Stage outcome with error in oracle apps

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

Legend

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