6 Replies Latest reply on Jun 14, 2011 4:14 PM by Hussein Sawwan-Oracle

    ame_engine error : ORA-01427: single-row subquery returns more than one row

    Sudarshan
      We have implemented AME with iProcurement and I've received an error while generating the approval list for a requisition.

      I have checked the exception log and the exception string gave me the following error:

      ORA-01427: single-row subquery returns more than one row

      the package associated with the error is ame_engine.

      I could understand that the subquery has given more than one rows but I could not find out where it really happened.

      There was not a clue for me to get to the root from which the error occurred.

      Please help me.

      Thanks