1 Reply Latest reply on Oct 9, 2013 12:32 PM by Srini Chavali-Oracle

    Error when attempting to run auto invoice report

    Jonathan_Ditchfield_1985

      Hi,

       

      We are currently using Oracle E-Business Suite 11.2.  One of our users was attempting to run an Auto Invoice Report this morning and got an error occur.  The log file shows the following:

       

      SELECT INTERFACE_LINE_ID

      FROM   RA_INTERFACE_LINES L2

      WHERE  L2.REQUEST_ID = :b5

      AND    L2.INTERFACE_LINE_CONTEXT = 'UPLS INVOICES'

      AND    L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT

      AND    L1.LINK_TO_LINE_ATTRIBUTE10 = L2.INTERFACE_LINE_ATTRIBUTE10

      AND    L1.LINK_TO_LINE_ATTRIBUTE11 = L2.INTERFACE_LINE_ATTRIBUTE11

      AND    L1.LINK_TO_LINE_ATTRIBUTE12 = L2.INTERFACE_LINE_ATTRIBUTE12

      )

      WHERE NVL(INTERFACE_STATUS, '~') != 'P'

      AND (REQUEST_ID IS NULL OR REQUEST_ID IN (:b6)

      )

      AND EXISTS

      (

      SELECT 'x'

      FROM   RA_INTERFACE_LINES L2

      WHERE  L2.REQUEST_ID = :b7

      AND    L2.INTERFACE_LINE_CONTEXT = 'UPLS INVOICES'

      AND    L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT

      AND    L1.LINK_TO_LINE_ATTRIBUTE10 = L2.INTERFACE_LINE_ATTRIBUTE10

      AND    L1.LINK_TO_LINE_ATTRIBUTE11 = L2.INTERFACE_LINE_ATTRIBUTE11

      AND    L1.LINK_TO_LINE_ATTRIBUTE12 = L2.INTERFACE_LINE_ATTRIBUTE12

      )

       

      len = 1171

      Current system time is 09-OCT-2013 07:33:50

      APP-AR-11526: ORA-01427: single-row subquery returns more than one row

                  

      UPDATE RA_INTERFACE_LINES L1

      SET REQUEST_ID = :b1,

      LAST_UPDATE_DATE =

      APP-AR-11526: 2913367/ar/src/autoinv/raamil.lpc 1333

      UPDATE RA_INTERFACE_LINES L1

      SET REQUEST_ID = :b1,

      LAST_UPDATE_DATE = sysdate,

      LAST_UPDATED_BY = :b2,

      LAST_UPDATE_LOGIN = :b3,

      CUSTOMER_TRX_ID = NULL,

      INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID,

      RA_CUSTOMER_TRX_LINES_S.NEXTVAL),

      SET_OF_BOOKS_ID = NVL(SET_OF_BOOKS_ID, :b4),

      LINK_TO_LINE_ID =

       

      Would someone be able to help me with this as my knowledge on Oracle is quite basic and the person who usually deals with these queries is out of the office.

       

      Regards,

       

      Jon Ditchfield

        • 1. Re: Error when attempting to run auto invoice report
          Srini Chavali-Oracle

          The error is

           

          APP-AR-11526: ORA-01427: single-row subquery returns more than one row


          A subquery that is supposed to return only one row is returning more than one. Most likely it is this query


          SELECT 'x'

          FROM   RA_INTERFACE_LINES L2

          WHERE  L2.REQUEST_ID = :b7

          AND    L2.INTERFACE_LINE_CONTEXT = 'UPLS INVOICES'

          AND    L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT

          AND    L1.LINK_TO_LINE_ATTRIBUTE10 = L2.INTERFACE_LINE_ATTRIBUTE10

          AND    L1.LINK_TO_LINE_ATTRIBUTE11 = L2.INTERFACE_LINE_ATTRIBUTE11

          AND    L1.LINK_TO_LINE_ATTRIBUTE12 = L2.INTERFACE_LINE_ATTRIBUTE12