This discussion is archived
5 Replies Latest reply: Oct 28, 2012 10:12 PM by user13100220 RSS

sales  customer report shows this error

user13100220 Newbie
Currently Being Moderated
Hi ,

please how to resolve this error recently it showed this error ..i have send my log file error ..i am not figured out where the problem lies...its urgent ...greateful to all..please help me....this problem taken after creation of new legal entity.


---------------------------------------------------------------------------
Projects: Version : 12.0.0

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

XXTGSCPR005 module: Consolidated Sales by Customer Client wise
---------------------------------------------------------------------------

Current system time is 19-OCT-2012 12:09:23

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

**Starts**19-OCT-2012 12:09:23
ORACLE error 1427 in FDPSTP

Cause: FDPSTP failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.XX_XML_SALES_CUSTOMER3", line 127
ORA-06512: at "APPS.XX_XML_SALES_CUSTOMER3", line 318
ORA-06512: at line 1
.

The SQL s
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

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

------------- 1) PUBLISH -------------
Beginning post-processing of request 1306154 on node ORAPSPR01 at 19-OCT-2012 12:09:23.
Post-processing of request 1306154 failed at 19-OCT-2012 12:09:23 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
--------------------------------------

Finished executing request completion options.

---------------------------------------------------------------------------
Exceptions posted by this request:
Concurrent Request for "Consolidated Sales by Customer Client wise" has completed with error.

---------------------------------------------------------------------------
Concurrent request completed
Current system time is 19-OCT-2012 12:09:23

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



thanks,

User13100220.

Legend

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