5 Replies Latest reply: Oct 29, 2012 12:12 AM by user13100220 RSS

    sales  customer report shows this error

    user13100220
      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.